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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 43139 Mon, 05 September 2011 02:20
By: Littlefoot
  How to select distinct sql_id together with clob column
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
1 174 Mon, 29 December 2014 06:38
By: Michel Cadot
  How to get list of top 15 sql order by by buffer gets
11.2.0.3
By: kytemanaic on Mon, 29 December 2014
2 154 Mon, 29 December 2014 06:36
By: Michel Cadot
  Update multiple rows based on duplication
11.2.0.1.0
By: OraFerro on Mon, 29 December 2014
5 154 Mon, 29 December 2014 06:30
By: OraFerro
  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 3242 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 1471 Mon, 29 December 2014 04:10
By: pointers
  How to define Package Name in Reports Builder
By: naveenbmca on Mon, 29 December 2014
5 334 Mon, 29 December 2014 03:48
By: Littlefoot
  filling summary table from detail and updating the detail with summary reference
11.2.0.1.0
By: OraFerro on Mon, 29 December 2014
2 305 Mon, 29 December 2014 03:30
By: OraFerro
  Optimisation of query sql
ORacle 9i
By: achraf_ef on Thu, 25 December 2014
25 2468 Mon, 29 December 2014 02:44
By: achraf_ef
  Dynamic monthly sales report
By: ocpsujon on Sun, 28 December 2014
3 447 Mon, 29 December 2014 00:04
By: Littlefoot
  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 277 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 3335 Sat, 27 December 2014 10:20
By: Solomon Yakobson
  ORA-01722: invalid number
Oracle 11g
By: Oracle_Walker on Wed, 24 December 2014
5 1915 Fri, 26 December 2014 13:37
By: Oracle_Walker
  Error in pl/sql Bubble sort code
By: jahanzaibniazi001 on Thu, 25 December 2014
3 1827 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 1152 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 3509 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 1031 Thu, 25 December 2014 05:27
By: Michel Cadot
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
5 1928 Wed, 24 December 2014 10:42
By: andrew again
  Complicate Query
Oracle SQL
By: raajes_n on Tue, 23 December 2014
13 1843 Wed, 24 December 2014 07:18
By: Michel Cadot
  Group by clause doubt - Can you please suggest me the query to this problem???
Oracle, windows
By: PHCR on Tue, 23 December 2014
6 1529 Wed, 24 December 2014 06:30
By: Flyby
  How to write stored function to return column name?
By: mist598 on Wed, 24 December 2014
6 2346 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 2542 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 2502 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 3553 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 2190 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 2991 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 750 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 3083 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 3147 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2302 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 2536 Sun, 21 December 2014 01:32
By: Michel Cadot
  generic queries
11.2.0.3
By: Amine on Fri, 19 December 2014
7 2462 Sat, 20 December 2014 14:27
By: Michel Cadot
icon5.gif DatatypeConverter
Database 11.2
By: ziad-al on Sat, 20 December 2014
9 2226 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 2688 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 3064 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 678 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 330 Thu, 18 December 2014 09:55
By: BlackSwan
  plsql table partitions
By: palpali on Tue, 16 December 2014
17 1902 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 2389 Thu, 18 December 2014 06:42
By: Michel Cadot
  table type indexed by binary integer
By: mist598 on Wed, 17 December 2014
4 883 Thu, 18 December 2014 01:45
By: sss111ind
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: Mon Dec 29 07:07:56 CST 2014

Total time taken to generate the page: 0.11441 seconds