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
  Problem with nested FOR Loop
Oracle 11.2.0.3.0 - Sun Solaris unix
By: welchaz on Mon, 29 December 2014
3 1127 Mon, 29 December 2014 15:25
By: welchaz
  How to get list of top 15 sql order by by buffer gets
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
3 1319 Mon, 29 December 2014 08:49
By: BlackSwan
  LONG to VARCHAR2 conversion using dblink
Oracle Enterprise Edition : 10.2.0.5.0 - 64bit,HPUX: Version 10.2.0.5.0
By: Jay1 on Tue, 23 December 2014
12 5445 Mon, 29 December 2014 06:04
By: Jay1
  SQL query to calculate distance and update
Oracle 11.2.0.3
By: pointers on Tue, 23 December 2014
6 2570 Mon, 29 December 2014 04:10
By: pointers
  How to display a record from an array(nested table)
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Sun, 28 December 2014
6 1049 Sun, 28 December 2014 17:16
By: buggleboy007
  When NOLOGGING will not be in effect
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 26 December 2014
12 3663 Sat, 27 December 2014 10:20
By: Solomon Yakobson
  ORA-01722: invalid number
Oracle 11g
By: Oracle_Walker on Wed, 24 December 2014
5 2581 Fri, 26 December 2014 13:37
By: Oracle_Walker
  Error in pl/sql Bubble sort code
By: jahanzaibniazi001 on Thu, 25 December 2014
3 2852 Fri, 26 December 2014 00:30
By: Michel Cadot
  Divide in Groups
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Wed, 24 December 2014
16 1537 Thu, 25 December 2014 12:51
By: manubatham20
  Comparing two TimeStamp columns giving unexpected result
Oracle 11G
By: Asfakul on Wed, 24 December 2014
5 3822 Thu, 25 December 2014 11:15
By: Michel Cadot
  PLS-00103: Encountered the symbol "END" when expecting one of
Oracle Database 11g XE 11.2.0.2.0 PL/SQL Release 11.2.0.2.0 OS WIN 7
By: weather3 on Wed, 24 December 2014
12 1640 Thu, 25 December 2014 05:27
By: Michel Cadot
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
5 2524 Wed, 24 December 2014 10:42
By: andrew again
  Complicate Query
Oracle SQL
By: raajes_n on Tue, 23 December 2014
13 2198 Wed, 24 December 2014 07:18
By: Michel Cadot
  How to write stored function to return column name?
By: mist598 on Wed, 24 December 2014
6 2645 Wed, 24 December 2014 05:14
By: Michel Cadot
  source does not have runnable target
sql developer, oracle 11g
By: zenthil86 on Tue, 23 December 2014
4 2828 Wed, 24 December 2014 01:38
By: Michel Cadot
  sql query for employees based on Org hierarchy
R12.1.3, 11g
By: afzaa2yahoocom on Tue, 23 December 2014
1 2889 Wed, 24 December 2014 01:36
By: Michel Cadot
  Dynamic PL/SQL which reads table and transposes rows to columns
oracle 11g R2, windows
By: zulu69 on Tue, 23 December 2014
3 3785 Wed, 24 December 2014 01:35
By: Michel Cadot
  Re:- how to check column value in particular format
windows7
By: ajamitjain129@gmail.com on Mon, 22 December 2014
4 2494 Tue, 23 December 2014 02:50
By: ajamitjain129@gmail.com
  Procedure to traverse the table based on fk constraints
oracle 11g sql developer
By: zenthil86 on Sat, 20 December 2014
12 3475 Mon, 22 December 2014 13:22
By: BlackSwan
  A question about using nested decode
Oracle 11.2.0.4 on Linux
By: orausern on Mon, 22 December 2014
5 1038 Mon, 22 December 2014 12:39
By: orausern
  How to Delete Parent table record
Oracle 10g,11g
By: amitsukte on Tue, 10 July 2012
9 4137 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 3564 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2911 Sun, 21 December 2014 02:24
By: tamzidulamin
  Connect by Prior parent-child into string of values
10.2
By: lott42 on Fri, 07 February 2014
16 2984 Sun, 21 December 2014 01:32
By: Michel Cadot
  generic queries
11.2.0.3
By: Amine on Fri, 19 December 2014
7 2812 Sat, 20 December 2014 14:27
By: Michel Cadot
icon5.gif DatatypeConverter
Database 11.2
By: ziad-al on Sat, 20 December 2014
9 2847 Sat, 20 December 2014 11:46
By: ziad-al
  Open cursor for select, based on another cursor
11.2.0.1.0
By: OraFerro on Thu, 18 December 2014
12 3551 Sat, 20 December 2014 07:39
By: Michel Cadot
  I tried , adn tried, and tried, and for that reason, I'm notgoint to give up...
windows 7, oracle 11g toad
By: xebec on Fri, 19 December 2014
11 3945 Sat, 20 December 2014 00:52
By: Michel Cadot
  How to fetch a single record in an array/nested table
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Thu, 18 December 2014
37 1018 Thu, 18 December 2014 15:34
By: buggleboy007
  utl_request ORA-29049 error when request salesforce.com
By: junkai.niu on Thu, 18 December 2014
1 1417 Thu, 18 December 2014 09:55
By: BlackSwan
  plsql table partitions
By: palpali on Tue, 16 December 2014
17 2257 Thu, 18 December 2014 09:22
By: cookiemonster
  Issue with DBMS_LOB.SubStr
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Tue, 16 December 2014
7 3151 Thu, 18 December 2014 06:42
By: Michel Cadot
  table type indexed by binary integer
By: mist598 on Wed, 17 December 2014
4 1070 Thu, 18 December 2014 01:45
By: sss111ind
  ORA-00907 : Formatting Error
Oracle 10g
By: abhayman on Wed, 17 December 2014
2 1852 Wed, 17 December 2014 01:56
By: abhayman
  Replacing wrong ID values with calculated ID
11.2.0.1.0
By: OraFerro on Mon, 15 December 2014
9 1469 Tue, 16 December 2014 22:04
By: OraFerro
  Concatenating an array output into one single string
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Mon, 15 December 2014
10 1328 Tue, 16 December 2014 16:48
By: buggleboy007
  Program never get completed
11i
By: nishantranjan00787 on Sat, 13 December 2014
10 3112 Tue, 16 December 2014 04:46
By: cookiemonster
  Re:Assigning priviledge to all tables
By: morrism35 on Sun, 14 December 2014
5 1342 Tue, 16 December 2014 03:03
By: cookiemonster
  dynamic sql column concat
11g
By: orsoghu on Mon, 15 December 2014
12 1547 Tue, 16 December 2014 01:31
By: Michel Cadot
  Can someone point me in the right direction
By: morrism35 on Mon, 15 December 2014
6 928 Tue, 16 December 2014 00:29
By: Michel Cadot
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 Feb 13 14:04:31 CST 2016

Total time taken to generate the page: 0.12761 seconds