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
  Exception Handling
oracle 11g
By: Satheesh.A on Mon, 20 June 2016
4 546 Mon, 20 June 2016 03:01
By: cookiemonster
  LAG function
10g, win8.1
By: rzkhan on Sat, 18 June 2016
3 586 Sat, 18 June 2016 02:30
By: Michel Cadot
  connect and level
sql developer
By: nath123 on Fri, 17 June 2016
1 462 Fri, 17 June 2016 15:10
By: Solomon Yakobson
  Query table with multi part column names
11g
By: bobghw on Thu, 16 June 2016
6 529 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 534 Thu, 16 June 2016 08:39
By: Bill B
  TO_NUMBER function not working
By: richard_oak on Wed, 15 June 2016
2 553 Wed, 15 June 2016 17:56
By: richard_oak
  What is wrong with this sql code?
By: anticristo on Tue, 14 June 2016
3 663 Wed, 15 June 2016 07:34
By: EdStevens
  regexp replace
Oracle 11g, Win 7
By: rajivn786 on Tue, 14 June 2016
9 656 Tue, 14 June 2016 15:55
By: Bill B
  "ORA-22813: operand value exceeds system limits" on executing sql returning XMLTYPE data
Oracle 11g
By: Nikita_01 on Tue, 14 June 2016
12 1762 Wed, 15 June 2016 13:01
By: Michel Cadot
  Removing specific line from file using UTL_FILE
11g
By: harshadsp on Tue, 14 June 2016
6 679 Thu, 16 June 2016 02:33
By: harshadsp
  What is the use of %ROWTYPE and %TYPE in PL/SQL?
By: abhik143 on Fri, 17 June 2016
2 554 Fri, 17 June 2016 02:13
By: Frank Naude
  External Table and Blank spaces
Oracle 12C Windows NT
By: pstanand on Mon, 13 June 2016
14 7979 Tue, 14 June 2016 11:01
By: Michel Cadot
icon5.gif Extract the most data after joining 3 tables
Oracle SQL
By: misy on Sat, 11 June 2016
8 739 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 621 Fri, 10 June 2016 17:31
By: Barbara Boehmer
  RAISE_APPLICATION_ERROR to display multiple line
11g
By: harshadsp on Fri, 10 June 2016
1 370 Fri, 10 June 2016 08:35
By: Bill B
icon5.gif Listing individual average price
Oracle SQL
By: misy on Thu, 09 June 2016
3 546 Fri, 10 June 2016 12:00
By: misy
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 1090 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 644 Thu, 09 June 2016 01:01
By: Michel Cadot
  Read/write files from remote server using utl_file in oracle
oracle 11g
By: tolupuluri on Wed, 08 June 2016
3 921 Wed, 08 June 2016 09:52
By: tolupuluri
  Query Date Ranges with select statement (merged 3)
Oracle SQL
By: basitfaazal on Tue, 07 June 2016
12 984 Fri, 10 June 2016 08:36
By: Bill B
  How To Update Encrypted Password for all user id's using Update Query
Oracle 11
By: ramraju20000 on Tue, 07 June 2016
13 2677 Wed, 08 June 2016 18:30
By: Solomon Yakobson
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 468 Tue, 07 June 2016 11:35
By: Bill B
  Need Help to convert rows into column
Oracle 11g
By: chintan.patel on Tue, 21 June 2016
12 3365 Thu, 23 June 2016 03:50
By: Michel Cadot
  Set a range into in time
Forms,
By: Salehin on Tue, 07 June 2016
32 1846 Sat, 23 July 2016 06:54
By: BlackSwan
  behaviour of to_timestamp and time zones
Win10, Oracle 12c
By: GusGF on Mon, 06 June 2016
5 726 Wed, 08 June 2016 04:47
By: GusGF
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 11719 Mon, 06 June 2016 08:21
By: Michel Cadot
  Transpose rows to columns without aggregation
By: dancko on Sat, 04 June 2016
9 595 Sat, 04 June 2016 12:17
By: dancko
  Collections in plsql - syntax
Oracle 11.2.0.4.0
By: adfnewbie on Mon, 06 June 2016
5 545 Tue, 07 June 2016 11:46
By: adfnewbie
  Adding Cells from two different tables
12.1.0.2
By: bdtran on Thu, 02 June 2016
5 665 Sat, 04 June 2016 23:35
By: bdtran
  try to insert data in to table using procedure
sql developer
By: nath123 on Thu, 02 June 2016
13 852 Fri, 03 June 2016 22:08
By: nath123
  FIFO Algorithm to calculate Avg weighted value
Oracle 10g
By: anil029 on Thu, 02 June 2016
15 906 Fri, 03 June 2016 15:13
By: Michel Cadot
  encrypt and decrypt URL
Oracle Database 11.2.0.3
By: metal_navin on Wed, 01 June 2016
1 493 Thu, 02 June 2016 07:43
By: Bill B
  order of geting value from sequence by trigger
Oracle 11g
By: miodas007 on Wed, 01 June 2016
6 4092 Mon, 13 June 2016 09:58
By: Bill B
  Issue with UTL_FILE.INVALID_OPERATION
11g
By: namitanamburi on Wed, 01 June 2016
7 689 Fri, 03 June 2016 18:58
By: namitanamburi
  package error
By: narang_me12 on Wed, 01 June 2016
7 557 Thu, 02 June 2016 07:38
By: Bill B
  Chinese Characters not display in table
Oracle 12C UNIX
By: pstanand on Tue, 31 May 2016
19 900 Tue, 31 May 2016 22:14
By: pstanand
  percentages of data population
Oracle 11.2.0.3
By: pointers on Tue, 31 May 2016
10 579 Thu, 02 June 2016 14:32
By: Bill B
  query to write rows to column values
11.2.0.4
By: grpatwari on Tue, 31 May 2016
13 832 Mon, 29 August 2016 23:00
By: grpatwari
  Filler / Bound Filler in External tables
oracle 11g
By: ORAGENASHOK on Tue, 31 May 2016
2 459 Tue, 31 May 2016 08:28
By: Bill B
  Updating Status W to A
SQL
By: Salehin on Tue, 31 May 2016
28 1646 Mon, 04 July 2016 02:59
By: cookiemonster
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: Sun Nov 19 09:56:42 CST 2017

Total time taken to generate the page: 0.00804 seconds