Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  ora-12096 error in materialized view (2 threads merged by bb)
oracle 10g
By: prashant_ora on Mon, 05 September 2011
8 13388 Thu, 29 January 2015 06:28
By: Michel Cadot
  need a query for following description
By: pmrnk03 on Thu, 29 January 2015
4 486 Thu, 29 January 2015 03:57
By: pmrnk03
  Query taking too long to execute and then throws an error. Need to change the SQL query
Oracle 11g, Oracle SQL developer 4
By: SQL_Dev on Tue, 27 January 2015
9 1065 Thu, 29 January 2015 01:33
By: John Watson
  How to insert with100 Million record's sql query result into another table 1 million by 1 million
Oracle 10g
By: victoryhendry on Fri, 09 January 2015
12 977 Wed, 28 January 2015 15:54
By: BlackSwan
  unknown procedure or function
By: palpali on Tue, 27 January 2015
20 1137 Wed, 28 January 2015 01:23
By: palpali
  Group by clause doubt - Can you please suggest me the query to this problem???
Oracle, windows
By: PHCR on Tue, 23 December 2014
11 2209 Tue, 27 January 2015 12:01
By: ravikanth_b
  Need sql script or proceedure
11G R2
By: mvrkr44 on Mon, 26 January 2015
23 624 Mon, 26 January 2015 10:29
By: cookiemonster
  variable declaration in procedure if we are calling the procedure within itself
By: chavva.kiru@gmail.com on Sun, 25 January 2015
1 393 Sun, 25 January 2015 16:52
By: Solomon Yakobson
  Updating a table with group by
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: wantmannu on Sat, 24 January 2015
6 609 Sun, 25 January 2015 11:29
By: wantmannu
  sql query to get avg value
Oracle 11g
By: thelearner on Fri, 23 January 2015
11 1105 Sun, 25 January 2015 04:36
By: John Watson
  REG:Variable declaration in procedure
By: chavva.kiru@gmail.com on Sat, 24 January 2015
2 500 Sun, 25 January 2015 01:06
By: Michel Cadot
  error while running procedure
By: chavva.kiru@gmail.com on Sun, 18 January 2015
3 595 Sat, 24 January 2015 23:43
By: chavva.kiru@gmail.com
  need to get perfect query
oracle database
By: Ganesha on Sat, 24 January 2015
2 440 Sat, 24 January 2015 14:48
By: Michel Cadot
  Subtracting Years from As_Of_Date
PL/SQL, Version 9.0.6.1665
By: jburdell on Fri, 23 January 2015
6 405 Fri, 23 January 2015 16:10
By: Bill B
  How to find first prior number from current date
By: aaditya321 on Thu, 15 January 2015
36 3772 Fri, 23 January 2015 09:27
By: Lalit Kumar B
  Error While Fetching Data Through Database Link In Oracle
By: qanita786 on Fri, 23 January 2015
8 660 Fri, 23 January 2015 06:32
By: EdStevens
  Special character issues
By: raopatwariyahoocom on Thu, 22 January 2015
6 730 Fri, 23 January 2015 03:00
By: Michel Cadot
  Help with REGEXP
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: mokarem on Wed, 14 January 2015
25 3205 Fri, 23 January 2015 01:08
By: m.abdulhaq
  Query on pagination Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
By: gopal.biswal on Sat, 17 January 2015
2 1085 Thu, 22 January 2015 21:44
By: gopal.biswal
  Need help on hierarchial query
Oracle 11.2.0.4, Linus
By: sspn2010 on Thu, 22 January 2015
5 336 Thu, 22 January 2015 13:11
By: sspn2010
  Need help on a query
Oracle 10G
By: bahubcd on Thu, 22 January 2015
4 299 Thu, 22 January 2015 11:44
By: John Watson
  bulk collect
By: palpali on Wed, 21 January 2015
10 703 Thu, 22 January 2015 09:11
By: palpali
  Distributing a total amount (payment) according to individual records (requests)
11.2.0.1.0
By: OraFerro on Thu, 22 January 2015
4 504 Thu, 22 January 2015 08:23
By: Solomon Yakobson
  How to trim the last matching string using regexp_substr
By: oracleso on Wed, 21 January 2015
9 1031 Thu, 22 January 2015 07:59
By: Michel Cadot
  Populate List from Java
Oracle 10g
By: Xandot on Thu, 22 January 2015
1 747 Thu, 22 January 2015 07:48
By: Michel Cadot
  status based use of SUM function
By: suji6281 on Thu, 22 January 2015
5 725 Thu, 22 January 2015 05:00
By: Michel Cadot
  Confusion about data length in CLOB type variable in PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: mokarem on Tue, 20 January 2015
5 604 Wed, 21 January 2015 21:59
By: mokarem
  Want to split value based on space if no space want to show null in second column
11g
By: cplusplus1 on Mon, 19 January 2015
4 1153 Wed, 21 January 2015 18:30
By: cplusplus1
  How to control the inserting the new records when it cross the limits
11g, Window 8
By: Bilal Khan on Tue, 09 December 2014
21 1649 Wed, 21 January 2015 10:17
By: Solomon Yakobson
  display group name
By: sudeshna_bio08 on Tue, 20 January 2015
5 818 Tue, 20 January 2015 09:22
By: Lalit Kumar B
  Finding SQL Query ...
Oracle 11.2.0.1 on Linux
By: suddhasatwa_oracle on Tue, 20 January 2015
5 828 Tue, 20 January 2015 06:26
By: Michel Cadot
  How to get right side value after comma
11g
By: cplusplus1 on Mon, 19 January 2015
7 954 Tue, 20 January 2015 00:18
By: Michel Cadot
  issue with a select query using row_number
oracle pl/sql
By: marouene.lm on Thu, 15 January 2015
12 540 Mon, 19 January 2015 21:28
By: Barbara Boehmer
  Logic to create new column in Oracle database - Multiple conditions making it more challenging
By: tableaudev2010 on Fri, 16 January 2015
11 1245 Sat, 17 January 2015 06:39
By: EdStevens
  CR/LR in column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Fri, 16 January 2015
34 1980 Fri, 16 January 2015 13:40
By: Duane
  XML Count rollup
Oracle 10g
By: zpele on Fri, 16 January 2015
4 922 Fri, 16 January 2015 12:36
By: BlackSwan
  cursor_for_loop allows PL/SQL SELECT..INTO statement
By: Lalit Kumar B on Mon, 12 January 2015
9 1417 Fri, 16 January 2015 10:04
By: Michel Cadot
  How to calculate in percent in sql query?
By: aaditya321 on Tue, 13 January 2015
31 3001 Thu, 15 January 2015 06:21
By: Lalit Kumar B
  pl sql to XML conversion
11g ( 1 2)
By: saniya on Tue, 13 January 2015
44 2129 Thu, 15 January 2015 01:03
By: Michel Cadot
  SQL query for a project scheduler
11.2.0.3
By: Amine on Fri, 09 January 2015
21 4062 Wed, 14 January 2015 13:25
By: Amine
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Sat Aug 29 02:48:19 CDT 2015

Total time taken to generate the page: 0.05191 seconds