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
  Using REGEXP_SUBSTR
By: mist598 on Wed, 30 July 2014
3 227 Wed, 30 July 2014 04:05
By: mist598
  need the output
By: mist598 on Tue, 29 July 2014
16 504 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 324 Tue, 29 July 2014 15:31
By: Littlefoot
  Global Temp Table
11G
By: Yuvraaj on Tue, 29 July 2014
5 264 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 1013 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 719 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 240 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 400 Mon, 28 July 2014 07:10
By: knw15pwr
  why this code with error?
By: hahaie on Sun, 27 July 2014
3 260 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 344 Mon, 28 July 2014 00:07
By: Michel Cadot
  SQL
Oracle 11g
By: ORAGENASHOK on Sun, 27 July 2014
12 350 Sun, 27 July 2014 09:39
By: Lalit Kumar B
  Calculating Index Growth
11
By: Yuvraaj on Sun, 27 July 2014
1 160 Sun, 27 July 2014 07:54
By: Michel Cadot
  Wrapper Procedure
Oracle 11g
By: ORAGENASHOK on Fri, 25 July 2014
6 403 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 343 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 585 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 908 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 625 Fri, 25 July 2014 07:23
By: krishnapawan.44@gmail.com
  Selecting a column not in group by clause
Oracle 10g
By: Member2014 on Thu, 24 July 2014
1 273 Thu, 24 July 2014 15:06
By: Michel Cadot
icon10.gif Compare SUM of column to another table (column)
Oracle 11g
By: Laf4sens on Thu, 24 July 2014
10 317 Thu, 24 July 2014 14:43
By: Solomon Yakobson
  Getting Unique Results
By: itcoracle on Tue, 22 July 2014
11 597 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 524 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 463 Wed, 23 July 2014 15:50
By: Bill B
icon5.gif SQL Help
10g
By: jimbojames on Tue, 22 July 2014
6 271 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 261 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 402 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 396 Tue, 22 July 2014 06:59
By: Solomon Yakobson
  SQL
9i, 10g
By: glmjoy on Tue, 22 July 2014
2 183 Tue, 22 July 2014 03:54
By: Lalit Kumar B
  SubQuery Problem
Oracle SQL Developer 3.1.07
By: HeyMoe on Wed, 16 July 2014
13 701 Tue, 22 July 2014 02:17
By: flyboy
  use between in case on one fild
By: hahaie on Mon, 21 July 2014
8 303 Tue, 22 July 2014 01:20
By: Michel Cadot
icon14.gif date function
By: hahaie on Sun, 20 July 2014
6 393 Tue, 22 July 2014 00:11
By: Lalit Kumar B
  Oracle RDBMS equivalent for CONCAT_WS() - create CSV output
Oracle 11g
By: rc3d on Mon, 21 July 2014
9 313 Mon, 21 July 2014 14:04
By: Lalit Kumar B
  how can i used connect by prior function.
oracle10g
By: ajamitjain129@gmail.com on Fri, 18 July 2014
24 908 Mon, 21 July 2014 08:24
By: Michel Cadot
  Reverse Engineer any Object
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Sun, 20 July 2014
4 269 Sun, 20 July 2014 22:53
By: Lalit Kumar B
  why use BETWEEN? BETWEEN vs. <= and >=
Oracle 11g
By: rc3d on Sun, 20 July 2014
6 298 Sun, 20 July 2014 13:54
By: rc3d
  Table statistics
11g
By: andrewscharles89 on Mon, 14 July 2014
4 422 Fri, 18 July 2014 14:15
By: Bill B
  Searching a string and replacing with value
Oracle 10g
By: sss111ind on Fri, 11 April 2014
15 1206 Fri, 18 July 2014 10:42
By: Lalit Kumar B
  Single select query or multiple cursor output as collection
By: ORAGENASHOK on Thu, 17 July 2014
4 256 Fri, 18 July 2014 07:40
By: ORAGENASHOK
  Using Case statement after "AND"
Oracle SQL Developer
By: rksample on Fri, 18 July 2014
5 274 Fri, 18 July 2014 06:57
By: Littlefoot
  Rebuild tree with fullpath - connect by (?)
11gR2
By: ric90 on Thu, 17 July 2014
7 254 Fri, 18 July 2014 03:25
By: ric90
  View is invalid
Oracle 11g,Linux 2.6
By: Database admin on Thu, 17 July 2014
5 217 Thu, 17 July 2014 21:33
By: Database admin
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 13:52:56 CDT 2014

Total time taken to generate the page: 0.13694 seconds