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
  SQL to filter redundant key field
Oracle 9.2 on Solaris
By: raghx on Mon, 20 June 2016
2 288 Mon, 20 June 2016 19:34
By: Barbara Boehmer
  how to export the data from table to the file
oracle 11g
By: tolupuluri on Mon, 20 June 2016
4 333 Mon, 20 June 2016 15:31
By: tolupuluri
  Aggregate based on serial number after checking for thresholds
By: ketangarg86 on Mon, 20 June 2016
3 263 Mon, 20 June 2016 13:06
By: Michel Cadot
  Exception Handling
oracle 11g
By: Satheesh.A on Mon, 20 June 2016
4 379 Mon, 20 June 2016 03:01
By: cookiemonster
  LAG function
10g, win8.1
By: rzkhan on Sat, 18 June 2016
3 403 Sat, 18 June 2016 02:30
By: Michel Cadot
  connect and level
sql developer
By: nath123 on Fri, 17 June 2016
1 314 Fri, 17 June 2016 15:10
By: Solomon Yakobson
  What is the use of %ROWTYPE and %TYPE in PL/SQL?
By: abhik143 on Fri, 17 June 2016
2 407 Fri, 17 June 2016 02:13
By: Frank Naude
  Query table with multi part column names
11g
By: bobghw on Thu, 16 June 2016
6 325 Thu, 16 June 2016 15:21
By: Bill B
  Calculating values from two different tables by using SQL command.
Oracle 11g ver 11.2.0.1.0
By: faisal78 on Thu, 16 June 2016
5 347 Thu, 16 June 2016 08:39
By: Bill B
  Removing specific line from file using UTL_FILE
11g
By: harshadsp on Tue, 14 June 2016
6 509 Thu, 16 June 2016 02:33
By: harshadsp
  TO_NUMBER function not working
By: richard_oak on Wed, 15 June 2016
2 331 Wed, 15 June 2016 17:56
By: richard_oak
  "ORA-22813: operand value exceeds system limits" on executing sql returning XMLTYPE data
Oracle 11g
By: Nikita_01 on Tue, 14 June 2016
12 788 Wed, 15 June 2016 13:01
By: Michel Cadot
  What is wrong with this sql code?
By: anticristo on Tue, 14 June 2016
3 444 Wed, 15 June 2016 07:34
By: EdStevens
  regexp replace
Oracle 11g, Win 7
By: rajivn786 on Tue, 14 June 2016
9 424 Tue, 14 June 2016 15:55
By: Bill B
  External Table and Blank spaces
Oracle 12C Windows NT
By: pstanand on Mon, 13 June 2016
14 7708 Tue, 14 June 2016 11:01
By: Michel Cadot
  order of geting value from sequence by trigger
Oracle 11g
By: miodas007 on Wed, 01 June 2016
6 3864 Mon, 13 June 2016 09:58
By: Bill B
icon5.gif Extract the most data after joining 3 tables
Oracle SQL
By: misy on Sat, 11 June 2016
8 546 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1231 Sat, 11 June 2016 10:43
By: EdStevens
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 416 Fri, 10 June 2016 17:31
By: Barbara Boehmer
icon5.gif Listing individual average price
Oracle SQL
By: misy on Thu, 09 June 2016
3 378 Fri, 10 June 2016 12:00
By: misy
  Query Date Ranges with select statement (merged 3)
Oracle SQL
By: basitfaazal on Tue, 07 June 2016
12 682 Fri, 10 June 2016 08:36
By: Bill B
  RAISE_APPLICATION_ERROR to display multiple line
11g
By: harshadsp on Fri, 10 June 2016
1 261 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 696 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 397 Thu, 09 June 2016 01:01
By: Michel Cadot
  How To Update Encrypted Password for all user id's using Update Query
Oracle 11
By: ramraju20000 on Tue, 07 June 2016
13 529 Wed, 08 June 2016 18:30
By: Solomon Yakobson
  Read/write files from remote server using utl_file in oracle
oracle 11g
By: tolupuluri on Wed, 08 June 2016
3 413 Wed, 08 June 2016 09:52
By: tolupuluri
  behaviour of to_timestamp and time zones
Win10, Oracle 12c
By: GusGF on Mon, 06 June 2016
5 469 Wed, 08 June 2016 04:47
By: GusGF
  Collections in plsql - syntax
Oracle 11.2.0.4.0
By: adfnewbie on Mon, 06 June 2016
5 407 Tue, 07 June 2016 11:46
By: adfnewbie
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 308 Tue, 07 June 2016 11:35
By: Bill B
  union all and sql*plus
By: Eugene on Thu, 26 December 2002
8 10374 Tue, 07 June 2016 06:38
By: EdStevens
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 460 Mon, 06 June 2016 08:21
By: Michel Cadot
  Adding Cells from two different tables
12.1.0.2
By: bdtran on Thu, 02 June 2016
5 477 Sat, 04 June 2016 23:35
By: bdtran
  Pattern recognition problem
12.1.0.2
By: bdtran on Thu, 26 May 2016
11 564 Sat, 04 June 2016 13:10
By: bdtran
  Transpose rows to columns without aggregation
By: dancko on Sat, 04 June 2016
9 398 Sat, 04 June 2016 12:17
By: dancko
  try to insert data in to table using procedure
sql developer
By: nath123 on Thu, 02 June 2016
13 598 Fri, 03 June 2016 22:08
By: nath123
  Issue with UTL_FILE.INVALID_OPERATION
11g
By: namitanamburi on Wed, 01 June 2016
7 417 Fri, 03 June 2016 18:58
By: namitanamburi
  FIFO Algorithm to calculate Avg weighted value
Oracle 10g
By: anil029 on Thu, 02 June 2016
15 584 Fri, 03 June 2016 15:13
By: Michel Cadot
  transpose and insert the data
oracle 11g
By: tolupuluri on Fri, 27 May 2016
19 670 Thu, 02 June 2016 15:56
By: tolupuluri
  percentages of data population
Oracle 11.2.0.3
By: pointers on Tue, 31 May 2016
10 425 Thu, 02 June 2016 14:32
By: Bill B
  Data not inserted after MView creation
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: smvmohan on Mon, 30 May 2016
14 517 Thu, 02 June 2016 14:28
By: Bill B
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: Tue Dec 06 14:01:11 CST 2016

Total time taken to generate the page: 0.17695 seconds