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
  Avoid Exception
Oracle 11g,Win7 32 bit
By: Xandot on Mon, 04 August 2014
1 236 Mon, 04 August 2014 04:26
By: Michel Cadot
  How to sort within concatenated columns
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
By: rappaj on Thu, 31 July 2014
9 402 Sun, 03 August 2014 18:03
By: rappaj
  Dynamic Column Generation by using pivot
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 27 November 2012
5 2663 Sun, 03 August 2014 12:19
By: ShantveerS
icon14.gif Executing procedures in parallel
Any
By: km88 on Sun, 03 August 2014
3 271 Sun, 03 August 2014 10:29
By: Lalit Kumar B
  how to select data from subpartition table
oracle 10g
By: jgjeetu on Sat, 02 August 2014
3 589 Sat, 02 August 2014 02:23
By: jgjeetu
  case statemnent
By: mist598 on Fri, 01 August 2014
7 674 Sat, 02 August 2014 01:11
By: jpatel7
  Rights query
Oracle 10.2.0.3
By: pointers on Fri, 01 August 2014
9 576 Sat, 02 August 2014 00:46
By: pointers
  Exception Handling For %type , %Rowtype variables
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionE
By: saipradyumn on Fri, 01 August 2014
1 306 Fri, 01 August 2014 06:30
By: Solomon Yakobson
  How to write query for subpartition table
oracle 10g
By: jgjeetu on Fri, 01 August 2014
4 328 Fri, 01 August 2014 04:20
By: jgjeetu
  small question related to loading of table in database
oracle 10g
By: harry13 on Fri, 01 August 2014
5 299 Fri, 01 August 2014 04:16
By: Lalit Kumar B
  Update Query with Returning Clause
Oracle 12c
By: cklh2000 on Wed, 30 July 2014
14 585 Thu, 31 July 2014 15:17
By: Michel Cadot
  Production Query
Oracle 11g
By: madsen on Thu, 31 July 2014
8 529 Thu, 31 July 2014 15:07
By: madsen
  SQL query to retrieve one record for each employee
By: mist598 on Thu, 31 July 2014
15 603 Thu, 31 July 2014 15:02
By: Lalit Kumar B
  Oracle server address
11g
By: andrewscharles89 on Wed, 30 July 2014
5 377 Wed, 30 July 2014 11:48
By: Solomon Yakobson
  REG_EXP csv and double quotes
Oracle 11g
By: wmgonzalbo on Mon, 28 July 2014
11 989 Wed, 30 July 2014 08:15
By: Lalit Kumar B
  Using REGEXP_SUBSTR
By: mist598 on Wed, 30 July 2014
3 307 Wed, 30 July 2014 04:05
By: mist598
  need the output
By: mist598 on Tue, 29 July 2014
16 603 Wed, 30 July 2014 01:41
By: mist598
  Convert SYSDATE to Julian Date format
Oracle DB 10205
By: praveenramaswamy on Tue, 29 July 2014
4 484 Tue, 29 July 2014 15:31
By: Littlefoot
  Global Temp Table
11G
By: Yuvraaj on Tue, 29 July 2014
5 354 Tue, 29 July 2014 13:41
By: John Watson
  Short-Circuit Evaluation operators in oracle
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 22 July 2014
15 1237 Mon, 28 July 2014 12:59
By: Solomon Yakobson
  Generating the Range for the given dates
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Mon, 28 July 2014
5 809 Mon, 28 July 2014 12:26
By: Solomon Yakobson
  How to use distinct with 2nd column to display desired output
oracle 10g
By: jgjeetu on Mon, 28 July 2014
3 291 Mon, 28 July 2014 08:20
By: Lalit Kumar B
  Update a single character within string column
11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production (Exadata)
By: knw15pwr on Thu, 24 July 2014
10 510 Mon, 28 July 2014 07:10
By: knw15pwr
  why this code with error?
By: hahaie on Sun, 27 July 2014
3 320 Mon, 28 July 2014 02:39
By: Michel Cadot
  find different or missing rows in one table
Oracle, 11.2, Windows 2008R2
By: forumwurm on Sun, 27 July 2014
8 412 Mon, 28 July 2014 00:07
By: Michel Cadot
  SQL
Oracle 11g
By: ORAGENASHOK on Sun, 27 July 2014
12 438 Sun, 27 July 2014 09:39
By: Lalit Kumar B
  Calculating Index Growth
11
By: Yuvraaj on Sun, 27 July 2014
1 221 Sun, 27 July 2014 07:54
By: Michel Cadot
  Wrapper Procedure
Oracle 11g
By: ORAGENASHOK on Fri, 25 July 2014
6 511 Sun, 27 July 2014 07:37
By: Lalit Kumar B
  All Child tables of given table
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: saipradyumn on Sat, 26 July 2014
3 412 Sat, 26 July 2014 11:29
By: Michel Cadot
  Hierarchical query, rolling up value from child to parent
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: hendrif2 on Fri, 25 July 2014
13 677 Sat, 26 July 2014 09:19
By: Kevin Meade
  How to Restrict User from Connecting to Database Through Specific hostname
11g, 11.2.0.3, AIX 7.1.0.0
By: ashishkumarmahanta80 on Mon, 21 July 2014
20 1053 Fri, 25 July 2014 10:20
By: Michel Cadot
  Cocatenate (unload: function of sap hana) and each record of a coulmn which is a table name and run
By: krishnapawan.44@gmail.com on Fri, 25 July 2014
22 751 Fri, 25 July 2014 07:23
By: krishnapawan.44@gmail.com
icon10.gif Compare SUM of column to another table (column)
Oracle 11g
By: Laf4sens on Thu, 24 July 2014
10 389 Thu, 24 July 2014 14:43
By: Solomon Yakobson
  Getting Unique Results
By: itcoracle on Tue, 22 July 2014
11 666 Thu, 24 July 2014 06:09
By: Solomon Yakobson
  Create a select statement for below scenario
10g or 11g
By: sachinpawar80 on Tue, 22 July 2014
7 597 Thu, 24 July 2014 04:52
By: pablolee
  How to implement the below code in the PL/SQL?
By: mist598 on Wed, 23 July 2014
12 548 Wed, 23 July 2014 15:50
By: Bill B
icon5.gif SQL Help
10g
By: jimbojames on Tue, 22 July 2014
6 337 Wed, 23 July 2014 03:38
By: Michel Cadot
  Can someone tell me How to debugg the procedure in the package without using any tool toad or pl sql
10g or 11g
By: sachinpawar80 on Tue, 22 July 2014
3 335 Tue, 22 July 2014 12:03
By: sachinpawar80
  Nested Aggregate Functions Group By Error
Oracle 11g
By: Charles_Aspire_Consult on Mon, 21 July 2014
9 527 Tue, 22 July 2014 08:23
By: Charles_Aspire_Consult
  To_number on only number fields
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 22 July 2014
13 521 Tue, 22 July 2014 06:59
By: Solomon Yakobson
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: Thu Dec 18 08:54:22 CST 2014

Total time taken to generate the page: 0.08263 seconds