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
  Avoiding duplicate SQL code
Oracle
By: na.dharma@gmail.com on Fri, 04 April 2014
6 568 Tue, 08 April 2014 09:43
By: pablolee
  Date format error
Oracle 10g
By: sss111ind on Tue, 08 April 2014
5 391 Tue, 08 April 2014 09:04
By: sss111ind
  How to get last two max values
Oracle 11g
By: na.dharma@gmail.com on Tue, 08 April 2014
5 409 Tue, 08 April 2014 06:12
By: Littlefoot
  Oracle 10g : Connect by prior
By: ashwanth77 on Tue, 08 April 2014
3 298 Tue, 08 April 2014 04:38
By: Michel Cadot
  Manipulating XML Clob
Oracle 11.2
By: deepugun on Mon, 07 April 2014
1 247 Mon, 07 April 2014 19:37
By: BlackSwan
  How to write query for desire output?
By: aaditya321 on Sat, 29 March 2014
4 464 Mon, 07 April 2014 03:58
By: Michel Cadot
  mutually exclusive query
Oracle, SQL
By: ravikanth_b on Sun, 06 April 2014
3 340 Mon, 07 April 2014 01:41
By: ravikanth_b
  Remove least paid employee who are reporting to BLAKE ?
By: kiranrathodkr916 on Sun, 06 April 2014
6 416 Sun, 06 April 2014 13:27
By: EdStevens
  Two row into one row conversition
Oralce 11g
By: na.dharma@gmail.com on Fri, 04 April 2014
9 516 Fri, 04 April 2014 10:04
By: Michel Cadot
  incorrect output from my sql command
11g
By: kekanap on Thu, 03 April 2014
6 527 Fri, 04 April 2014 10:01
By: Michel Cadot
  finding missing parent from oracle hierarchical query
11g
By: ashwanth77 on Fri, 04 April 2014
8 542 Fri, 04 April 2014 08:25
By: flyboy
  ORA-12899: value too large for column
Oracle 11g
By: na.dharma@gmail.com on Fri, 04 April 2014
3 344 Fri, 04 April 2014 02:00
By: Michel Cadot
  Date Format
By: gauravgautam135 on Thu, 03 April 2014
16 885 Fri, 04 April 2014 00:26
By: gauravgautam135
  sysdate problem with between()
8i
By: bobghw on Thu, 03 April 2014
4 244 Thu, 03 April 2014 19:19
By: bobghw
  Process cursor grp
Oracle 11g
By: namitanamburi on Thu, 03 April 2014
0 425 Thu, 03 April 2014 14:33
By: namitanamburi
  SQL Sub Query Error ORA-00936: missing expression
Oracle 11
By: rlcaputo on Thu, 03 April 2014
4 392 Thu, 03 April 2014 13:28
By: rlcaputo
  Adding subpartitions in template
By: Alexey.Samoilov on Thu, 03 April 2014
0 401 Thu, 03 April 2014 13:08
By: Alexey.Samoilov
  Select distinct record based on NULL date or most recent date
2005 SQL SSIS
By: jbaisch on Wed, 02 April 2014
19 918 Thu, 03 April 2014 09:39
By: cookiemonster
  Dates
By: mist598 on Wed, 02 April 2014
21 817 Thu, 03 April 2014 06:45
By: EdStevens
  Need to get only characters from the given string
By: saipradyumn on Thu, 03 April 2014
2 227 Thu, 03 April 2014 06:15
By: saipradyumn
  before insert & instead OF INSERT trigger
By: mist598 on Thu, 03 April 2014
11 505 Thu, 03 April 2014 04:32
By: cookiemonster
  Sharing column for partitions.
By: Alexey.Samoilov on Thu, 03 April 2014
6 378 Thu, 03 April 2014 03:43
By: Alexey.Samoilov
  Unable to get running total conditionally
Oracle Database 10g Rel.2
By: mazam on Wed, 02 April 2014
6 485 Thu, 03 April 2014 01:43
By: mazam
  Problems in Oracle Hints
By: aaditya321 on Wed, 02 April 2014
4 287 Thu, 03 April 2014 00:55
By: aaditya321
  passing values from Refcursor into Object type
Oracle 9i
By: anoopmanagoli on Wed, 02 April 2014
1 162 Wed, 02 April 2014 23:29
By: BlackSwan
  Group Values by date/Pivot in PLSQL query
plsql
By: manishc1989 on Wed, 02 April 2014
1 232 Wed, 02 April 2014 10:51
By: Michel Cadot
  How to get when_no_data found exception messages using cursor for loop
By: mist598 on Tue, 01 April 2014
10 619 Wed, 02 April 2014 04:57
By: Michel Cadot
  Get value between two fields
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003
By: hissam78 on Tue, 01 April 2014
5 346 Wed, 02 April 2014 02:44
By: hissam78
  ROW_NUMBER() OVER( ORDER BY 2, 1 )
Oracle 11g Release 2
By: Manoj.Gupta.91 on Wed, 02 April 2014
3 348 Wed, 02 April 2014 02:31
By: Michel Cadot
  GRANTS to user to insert data in table with procedure
By: Alexey.Samoilov on Wed, 02 April 2014
2 225 Wed, 02 April 2014 02:27
By: Alexey.Samoilov
  Change by query widt
Change by query without group operation
By: Alexey.Samoilov on Tue, 01 April 2014
2 218 Wed, 02 April 2014 01:45
By: Alexey.Samoilov
  Grant Create Table On few tables
Oracle 11g Release 2
By: azeem87 on Tue, 01 April 2014
4 248 Tue, 01 April 2014 18:29
By: EdStevens
  Query that will compare two tables row by row and returns distinct rows from both tables
By: Alexey.Samoilov on Tue, 01 April 2014
4 337 Tue, 01 April 2014 15:00
By: Solomon Yakobson
  raise error propagation
oracle 11g2, windows os
By: anncao on Tue, 01 April 2014
1 145 Tue, 01 April 2014 12:07
By: BlackSwan
  VIEW with Global Variables - help needed
By: oralover2006 on Tue, 01 April 2014
2 277 Tue, 01 April 2014 07:04
By: oralover2006
  creating oracle tablespace and quotasize dynamically
ORACLE 11g
By: santhosha4db on Tue, 01 April 2014
17 800 Tue, 01 April 2014 04:59
By: Michel Cadot
  Longest word PL SQL
By: Ben892 on Mon, 31 March 2014
3 338 Tue, 01 April 2014 01:16
By: John Watson
  30 minute Time Interval
By: ertweety11 on Wed, 26 March 2014
17 987 Mon, 31 March 2014 05:37
By: oralover2006
  Case statement with null in where clause
oracle 10g, Toad, xp
By: Crimzon on Sun, 30 March 2014
2 399 Sun, 30 March 2014 12:07
By: Solomon Yakobson
  How to store GMT timestamp in Database from SQL Developer import excelsheet
Oracle 11g R2
By: cpadesur on Sun, 30 March 2014
3 420 Sun, 30 March 2014 07:45
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: Wed Aug 27 20:09:36 CDT 2014

Total time taken to generate the page: 0.06127 seconds