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
  passing values from Refcursor into Object type
Oracle 9i
By: anoopmanagoli on Wed, 02 April 2014
1 163 Wed, 02 April 2014 23:29
By: BlackSwan
  Group Values by date/Pivot in PLSQL query
plsql
By: manishc1989 on Wed, 02 April 2014
1 236 Wed, 02 April 2014 10:51
By: Michel Cadot
  How to get when_no_data found exception messages using cursor for loop
By: mist598 on Tue, 01 April 2014
10 623 Wed, 02 April 2014 04:57
By: Michel Cadot
  Get value between two fields
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003
By: hissam78 on Tue, 01 April 2014
5 348 Wed, 02 April 2014 02:44
By: hissam78
  ROW_NUMBER() OVER( ORDER BY 2, 1 )
Oracle 11g Release 2
By: Manoj.Gupta.91 on Wed, 02 April 2014
3 352 Wed, 02 April 2014 02:31
By: Michel Cadot
  GRANTS to user to insert data in table with procedure
By: Alexey.Samoilov on Wed, 02 April 2014
2 229 Wed, 02 April 2014 02:27
By: Alexey.Samoilov
  Change by query widt
Change by query without group operation
By: Alexey.Samoilov on Tue, 01 April 2014
2 218 Wed, 02 April 2014 01:45
By: Alexey.Samoilov
  Grant Create Table On few tables
Oracle 11g Release 2
By: azeem87 on Tue, 01 April 2014
4 248 Tue, 01 April 2014 18:29
By: EdStevens
  Query that will compare two tables row by row and returns distinct rows from both tables
By: Alexey.Samoilov on Tue, 01 April 2014
4 338 Tue, 01 April 2014 15:00
By: Solomon Yakobson
  raise error propagation
oracle 11g2, windows os
By: anncao on Tue, 01 April 2014
1 146 Tue, 01 April 2014 12:07
By: BlackSwan
  VIEW with Global Variables - help needed
By: oralover2006 on Tue, 01 April 2014
2 280 Tue, 01 April 2014 07:04
By: oralover2006
  creating oracle tablespace and quotasize dynamically
ORACLE 11g
By: santhosha4db on Tue, 01 April 2014
17 801 Tue, 01 April 2014 04:59
By: Michel Cadot
  Longest word PL SQL
By: Ben892 on Mon, 31 March 2014
3 342 Tue, 01 April 2014 01:16
By: John Watson
  30 minute Time Interval
By: ertweety11 on Wed, 26 March 2014
17 989 Mon, 31 March 2014 05:37
By: oralover2006
  Case statement with null in where clause
oracle 10g, Toad, xp
By: Crimzon on Sun, 30 March 2014
2 402 Sun, 30 March 2014 12:07
By: Solomon Yakobson
  How to store GMT timestamp in Database from SQL Developer import excelsheet
Oracle 11g R2
By: cpadesur on Sun, 30 March 2014
3 424 Sun, 30 March 2014 07:45
By: Solomon Yakobson
  ORA-00904: "CNT": invalid identifier error
Oralce 11g
By: na.dharma@gmail.com on Sat, 29 March 2014
2 315 Sat, 29 March 2014 07:28
By: na.dharma@gmail.com
  How to handle error in 5th counting on cursor
By: aaditya321 on Sat, 29 March 2014
4 362 Sat, 29 March 2014 04:00
By: dariyoosh
  Union??? or Merge of tables
By: ertweety11 on Fri, 28 March 2014
3 296 Fri, 28 March 2014 15:43
By: BlackSwan
  how to use substr if the error ORA-01403: no data found.
By: mist598 on Fri, 28 March 2014
3 281 Fri, 28 March 2014 09:07
By: cookiemonster
  Nested Select for summary
11g
By: andysam23586 on Fri, 28 March 2014
3 281 Fri, 28 March 2014 08:54
By: BlackSwan
icon5.gif Sorting Issue
ORACLE 9i
By: Sandeep321 on Thu, 27 March 2014
18 585 Fri, 28 March 2014 05:37
By: Solomon Yakobson
  Unable to update a table at remote db in named pl/sql procedure
By: sonalpatel_cse on Thu, 27 March 2014
2 192 Thu, 27 March 2014 13:27
By: Solomon Yakobson
  use of EXTEND in Collection in NESTED TABLES
By: mist598 on Thu, 27 March 2014
7 477 Thu, 27 March 2014 03:56
By: mist598
  One more condition in this script
Oracle,8.1.7.0.0,Windows 2003 Server
By: kumarvk on Wed, 26 March 2014
8 463 Thu, 27 March 2014 03:35
By: cookiemonster
  where can i call the procedure in the procedure in the package
By: mist598 on Wed, 26 March 2014
11 520 Wed, 26 March 2014 08:18
By: cookiemonster
  Please help - comma separated values
Oracle Database 11g Release 11.2.0.3.0
By: oralover2006 on Wed, 26 March 2014
6 373 Wed, 26 March 2014 05:50
By: oralover2006
  Oracle transpose rows into columns
Oracle 11g
By: developer12 on Mon, 24 March 2014
12 818 Wed, 26 March 2014 03:13
By: Michel Cadot
  if in field value "Delete", then don't join other table
Oracle 10g
By: rc3d on Mon, 24 March 2014
5 427 Tue, 25 March 2014 05:56
By: cookiemonster
  Insufficient privileges in DBMS_SESSION.SET_CONTEXT
Oracle 11.2.0.1.0 on OEL 5.7
By: Andrey_R on Sun, 23 March 2014
4 651 Tue, 25 March 2014 04:57
By: Andrey_R
  Dynamic column selection
11g
By: okela_vp on Tue, 10 December 2013
6 597 Tue, 25 March 2014 00:14
By: Barbara Boehmer
  Problem in external table ( 1 2)
By: aaditya321 on Tue, 11 March 2014
65 2980 Mon, 24 March 2014 13:10
By: aaditya321
  Insert statements
Oracle 11g
By: srinivas.k2005 on Wed, 12 March 2014
4 374 Mon, 24 March 2014 12:38
By: Michel Cadot
  generate xls file through pl/sql
By: tisekofti on Sat, 22 March 2014
7 582 Mon, 24 March 2014 08:27
By: cookiemonster
  computing statistics at the schema level
11g
By: ashwanth77 on Mon, 24 March 2014
2 239 Mon, 24 March 2014 07:40
By: EdStevens
  comparing the result of multiple SELECT statements
Oracle 11g, Win7
By: nischalinn on Mon, 24 March 2014
5 228 Mon, 24 March 2014 07:10
By: Michel Cadot
icon4.gif How? - Create Check constraint - field must contain @ symbol
Oracle llg Apex
By: Oracleuser14 on Mon, 24 March 2014
2 212 Mon, 24 March 2014 06:52
By: Michel Cadot
  Error while executing the plsql block for mview refresh
oracle 11g
By: narendra.treddi on Thu, 20 March 2014
10 413 Mon, 24 March 2014 06:46
By: Michel Cadot
  Please help for ORA-01416: two tables cannot be outer-joined to each other
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Mon, 24 March 2014
4 259 Mon, 24 March 2014 04:39
By: msol25
  How to display Last Day In Week Indicate As Y or N as input is start date and end date
Windows
By: spatil522@gmail.com on Mon, 24 March 2014
1 167 Mon, 24 March 2014 03:44
By: Littlefoot
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 Sep 02 00:22:19 CDT 2014

Total time taken to generate the page: 0.27602 seconds