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
  Add a new column on first position of table in existing table.
Oracle 11g
By: na.dharma@gmail.com on Thu, 16 January 2014
8 670 Fri, 17 January 2014 01:18
By: Michel Cadot
  Primary Key in another Index
Oracle 11g, 11.2.0.2 Linux 64b
By: sujitm30 on Thu, 16 January 2014
3 284 Fri, 17 January 2014 01:15
By: evivek
  cursor loop
oracle 11 g
By: simplesanju on Wed, 15 January 2014
2 315 Thu, 16 January 2014 03:35
By: simplesanju
  Time out error in JAVA application when backend package is calling
By: na.dharma@gmail.com on Thu, 16 January 2014
5 274 Thu, 16 January 2014 01:16
By: Michel Cadot
  why would this query return three rows?
By: nataliafoster26 on Wed, 15 January 2014
2 265 Wed, 15 January 2014 15:11
By: Michel Cadot
  SQL to generate sequential numbers for each repeating row and reset upon new key
Oracle 9i R2
By: yasar2002 on Wed, 11 December 2013
4 712 Wed, 15 January 2014 08:01
By: Michel Cadot
  Want to use date variable value in select query
11g
By: cplusplus1 on Tue, 14 January 2014
7 928 Tue, 14 January 2014 09:44
By: cookiemonster
  ORA-01481: invalid number format model
By: jackxu on Tue, 14 January 2014
4 548 Tue, 14 January 2014 09:43
By: BlackSwan
  How to find last sunday of month
By: aaditya321 on Tue, 14 January 2014
5 316 Tue, 14 January 2014 07:52
By: Solomon Yakobson
  ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired while gathering stats
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: athensromania on Mon, 13 January 2014
8 772 Tue, 14 January 2014 04:03
By: ThomasG
  Search String
oracle 10g,win xp
By: Xandot on Tue, 14 January 2014
2 296 Tue, 14 January 2014 02:47
By: Xandot
  Syntax for similar Pattern between the tables
Oracle 10 and 11g
By: imransi17@gmail.com on Mon, 13 January 2014
2 252 Tue, 14 January 2014 00:15
By: Michel Cadot
  Can someone help me with this
By: pingiliarjun on Thu, 09 January 2014
6 364 Mon, 13 January 2014 15:56
By: Bill B
  Re: XML issue (split from hijacked thread http://www.orafaq.com/forum/t/189540/)
By: KimberlyDeborah on Sat, 11 January 2014
2 236 Mon, 13 January 2014 04:45
By: KimberlyDeborah
  correct week number
oracle 11g
By: guddu_12 on Fri, 10 January 2014
5 383 Mon, 13 January 2014 04:38
By: guddu_12
  Find the last process in string
oracle 10g,win xp
By: Xandot on Fri, 10 January 2014
2 252 Sun, 12 January 2014 11:50
By: Xandot
  Permutation combination
ORACLE PL/SQL
By: banyan_sg on Wed, 08 January 2014
18 888 Sun, 12 January 2014 04:34
By: Solomon Yakobson
  Case statement not working
Oracle 11g
By: kumaran22 on Fri, 10 January 2014
2 198 Fri, 10 January 2014 15:23
By: Michel Cadot
  i wanto to return One single row into column.
Oracle 11g
By: na.dharma@gmail.com on Fri, 10 January 2014
5 486 Fri, 10 January 2014 12:54
By: pablolee
  How to display the letter starting with "B" followed by number only.
Oracle 11g
By: ajaykumarkona on Thu, 09 January 2014
13 670 Fri, 10 January 2014 05:22
By: gazzag
  How to find total no of employee and no of employee in given years
By: aaditya321 on Tue, 07 January 2014
8 498 Fri, 10 January 2014 04:14
By: cookiemonster
  User who executed the Job
oracle 10.1.0.2.0
By: pstanand on Fri, 10 January 2014
1 167 Fri, 10 January 2014 01:38
By: Michel Cadot
  Please provide equivalent update for this merge query.
Oracle 11g
By: ajaykumarkona on Thu, 09 January 2014
5 293 Thu, 09 January 2014 22:17
By: BlackSwan
  Loops
Oracle 11g, XP
By: rajivn786 on Wed, 08 January 2014
4 330 Thu, 09 January 2014 13:08
By: rajivn786
  To display count for each day in a month
10g
By: 367364 on Mon, 06 January 2014
21 933 Thu, 09 January 2014 12:43
By: Solomon Yakobson
  How to read UNCOMMITED data in Oracle?
Oracle 11g Enterprise Edition 11.2.0.1.0 - Linux 2.6
By: usaha1 on Thu, 09 January 2014
12 523 Thu, 09 January 2014 05:46
By: usaha1
  SELECT * FROM OPENQUERY([127.0.0.1],'@cmd') (merged)
By: phuong on Mon, 21 May 2007
7 1700 Wed, 08 January 2014 18:33
By: BlackSwan
  UPDATE only rows which match another table
By: alexandercioby on Tue, 07 January 2014
7 597 Wed, 08 January 2014 15:19
By: joy_division
  weighted average or moving average calculation for stock
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
By: hissam78 on Sat, 04 January 2014
3 391 Wed, 08 January 2014 13:54
By: hissam78
  compare null in decode
By: mist598 on Wed, 08 January 2014
7 446 Wed, 08 January 2014 12:19
By: Solomon Yakobson
  Group the same values and show the ascending order.
Oracle 11g
By: na.dharma@gmail.com on Wed, 08 January 2014
2 126 Wed, 08 January 2014 10:10
By: BlackSwan
  sql code error meaning
Oracle 11g, Win7
By: nischalinn on Wed, 08 January 2014
10 418 Wed, 08 January 2014 06:11
By: pablolee
  Read a .csv file which has more than 45000 Characters
By: sivakarthick on Wed, 08 January 2014
7 335 Wed, 08 January 2014 04:31
By: gazzag
  can a string be used with IN within a query?
11g
By: VAC357 on Tue, 07 January 2014
5 260 Tue, 07 January 2014 14:14
By: Michel Cadot
  duplicate column
By: nataliafoster26 on Mon, 06 January 2014
9 541 Tue, 07 January 2014 07:12
By: gazzag
  DML written on a script autocommits after a DDL in the same script without any commit statements?
oracle,10g,xp
By: evivek on Tue, 07 January 2014
3 188 Tue, 07 January 2014 05:07
By: evivek
  Dynamic Column List in Select query
oracle 11g linux
By: deepa_balu on Mon, 06 January 2014
5 343 Tue, 07 January 2014 03:28
By: dariyoosh
  Can a procedure have multiple OUT sy_refcursor
oracle 11g
By: gentleman777us on Mon, 06 January 2014
4 272 Tue, 07 January 2014 02:13
By: Michel Cadot
  How to Display Multiple rows in a single row but in different columns
Oracle 11.2
By: deepugun on Mon, 06 January 2014
6 462 Tue, 07 January 2014 01:57
By: Lalit Kumar B
  Decode explanation
By: mist598 on Mon, 06 January 2014
2 230 Tue, 07 January 2014 00:03
By: mist598
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 Apr 21 01:19:48 CDT 2014

Total time taken to generate the page: 0.23592 seconds