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
  How to use distinct with 2nd column to display desired output
oracle 10g
By: jgjeetu on Mon, 28 July 2014
3 254 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 429 Mon, 28 July 2014 07:10
By: knw15pwr
  why this code with error?
By: hahaie on Sun, 27 July 2014
3 267 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 351 Mon, 28 July 2014 00:07
By: Michel Cadot
  SQL
Oracle 11g
By: ORAGENASHOK on Sun, 27 July 2014
12 366 Sun, 27 July 2014 09:39
By: Lalit Kumar B
  Calculating Index Growth
11
By: Yuvraaj on Sun, 27 July 2014
1 171 Sun, 27 July 2014 07:54
By: Michel Cadot
  Wrapper Procedure
Oracle 11g
By: ORAGENASHOK on Fri, 25 July 2014
6 415 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 354 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 606 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 937 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 646 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 325 Thu, 24 July 2014 14:43
By: Solomon Yakobson
  Getting Unique Results
By: itcoracle on Tue, 22 July 2014
11 612 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 545 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 487 Wed, 23 July 2014 15:50
By: Bill B
icon5.gif SQL Help
10g
By: jimbojames on Tue, 22 July 2014
6 284 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 275 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 424 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 410 Tue, 22 July 2014 06:59
By: Solomon Yakobson
  SQL
9i, 10g
By: glmjoy on Tue, 22 July 2014
2 199 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 729 Tue, 22 July 2014 02:17
By: flyboy
  use between in case on one fild
By: hahaie on Mon, 21 July 2014
8 324 Tue, 22 July 2014 01:20
By: Michel Cadot
icon14.gif date function
By: hahaie on Sun, 20 July 2014
6 418 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 339 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 943 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 282 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 320 Sun, 20 July 2014 13:54
By: rc3d
  Table statistics
11g
By: andrewscharles89 on Mon, 14 July 2014
4 451 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 1236 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 281 Fri, 18 July 2014 07:40
By: ORAGENASHOK
  Using Case statement after "AND"
Oracle SQL Developer
By: rksample on Fri, 18 July 2014
5 290 Fri, 18 July 2014 06:57
By: Littlefoot
  Rebuild tree with fullpath - connect by (?)
11gR2
By: ric90 on Thu, 17 July 2014
7 272 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 236 Thu, 17 July 2014 21:33
By: Database admin
  archive & Purge of table
oracle 11g / Unix
By: balaji123 on Fri, 27 June 2014
7 407 Thu, 17 July 2014 12:34
By: Lalit Kumar B
  SQL ISSUE
oracle 11g / unix
By: balaji123 on Thu, 17 July 2014
3 201 Thu, 17 July 2014 12:33
By: balaji123
  get every result of a query to use after other query
By: mmm286 on Thu, 17 July 2014
17 440 Thu, 17 July 2014 11:22
By: Littlefoot
  Binary tree in Pl/sql
By: suni786 on Mon, 14 January 2013
6 1136 Thu, 17 July 2014 06:54
By: Littlefoot
  Dbms_Parallel_Execute.Run_Task gets stuck
Oracle Database 11g Release 11.2.0.4.0
By: Thilinaa on Thu, 17 July 2014
0 403 Thu, 17 July 2014 06:07
By: Thilinaa
  Materialized view
11g
By: mvrkr44 on Wed, 16 July 2014
9 386 Wed, 16 July 2014 10:26
By: Michel Cadot
  Diffrent Number and type of parameter passing
11g
By: dara.naveen on Mon, 14 July 2014
3 284 Wed, 16 July 2014 02:32
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: Mon Sep 22 05:34:47 CDT 2014

Total time taken to generate the page: 0.12236 seconds