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 find last updated date
By: preethia on Fri, 17 January 2014
9 748 Fri, 17 January 2014 11:40
By: Michel Cadot
  update with aggregate value
11.2.0.2.0
By: yuko on Thu, 16 January 2014
8 551 Fri, 17 January 2014 09:35
By: ThomasG
  Is this possible to drop the virtual column from table
Oracle 11g
By: na.dharma@gmail.com on Fri, 17 January 2014
3 382 Fri, 17 January 2014 06:44
By: pablolee
  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 819 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 331 Fri, 17 January 2014 01:15
By: evivek
  cursor loop
oracle 11 g
By: simplesanju on Wed, 15 January 2014
2 352 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 322 Thu, 16 January 2014 01:16
By: Michel Cadot
  why would this query return three rows?
By: nataliafoster26 on Wed, 15 January 2014
2 312 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 803 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 1035 Tue, 14 January 2014 09:44
By: cookiemonster
  ORA-01481: invalid number format model
By: jackxu on Tue, 14 January 2014
4 881 Tue, 14 January 2014 09:43
By: BlackSwan
  How to find last sunday of month
By: aaditya321 on Tue, 14 January 2014
5 445 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 920 Tue, 14 January 2014 04:03
By: ThomasG
  Search String
oracle 10g,win xp
By: Xandot on Tue, 14 January 2014
2 323 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 294 Tue, 14 January 2014 00:15
By: Michel Cadot
  Can someone help me with this
By: pingiliarjun on Thu, 09 January 2014
6 427 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 281 Mon, 13 January 2014 04:45
By: KimberlyDeborah
  correct week number
oracle 11g
By: guddu_12 on Fri, 10 January 2014
5 455 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 298 Sun, 12 January 2014 11:50
By: Xandot
  Permutation combination
ORACLE PL/SQL
By: banyan_sg on Wed, 08 January 2014
18 1076 Sun, 12 January 2014 04:34
By: Solomon Yakobson
  Case statement not working
Oracle 11g
By: kumaran22 on Fri, 10 January 2014
2 253 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 555 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 734 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 580 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 202 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 363 Thu, 09 January 2014 22:17
By: BlackSwan
  Loops
Oracle 11g, XP
By: rajivn786 on Wed, 08 January 2014
4 421 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 1028 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 571 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 1875 Wed, 08 January 2014 18:33
By: BlackSwan
  UPDATE only rows which match another table
By: alexandercioby on Tue, 07 January 2014
7 692 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 503 Wed, 08 January 2014 13:54
By: hissam78
  compare null in decode
By: mist598 on Wed, 08 January 2014
7 486 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 157 Wed, 08 January 2014 10:10
By: BlackSwan
  sql code error meaning
Oracle 11g, Win7
By: nischalinn on Wed, 08 January 2014
10 483 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 411 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 319 Tue, 07 January 2014 14:14
By: Michel Cadot
  duplicate column
By: nataliafoster26 on Mon, 06 January 2014
9 597 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 234 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 395 Tue, 07 January 2014 03:28
By: dariyoosh
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 Jul 30 11:21:28 CDT 2014

Total time taken to generate the page: 0.07059 seconds