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
  Generating Numbers between given ranges
Oracle
By: manubatham20 on Fri, 17 October 2014
8 389 Fri, 17 October 2014 15:05
By: BlackSwan
  Need query
Oracle Database 11g Enterprise Edition Release
By: akash.nathile on Thu, 16 October 2014
7 412 Fri, 17 October 2014 08:54
By: Bill B
  How to calculate age between timestamp ?
By: tondapi on Fri, 17 October 2014
3 314 Fri, 17 October 2014 06:57
By: Michel Cadot
  substring instr query
SQL Oracle
By: incrediblek on Fri, 17 October 2014
2 338 Fri, 17 October 2014 04:46
By: Lalit Kumar B
  oracle
By: shwetha naren on Thu, 16 October 2014
1 235 Thu, 16 October 2014 15:00
By: Michel Cadot
icon1.gif Need a hand finding the script
Oracle 9i
By: dmellobruce1987 on Thu, 16 October 2014
2 253 Thu, 16 October 2014 13:12
By: Michel Cadot
  Replace every even number occurance of comma with # in a String
Oracle 11g R2
By: javed.khan on Thu, 16 October 2014
5 338 Thu, 16 October 2014 05:24
By: javed.khan
  Merge collections ?
By: lijjumathew on Wed, 15 October 2014
2 230 Wed, 15 October 2014 22:50
By: Lalit Kumar B
  DBMS_SCHEDULER and perl script
Oracle 11.2, linux
By: rrk1 on Wed, 15 October 2014
9 527 Wed, 15 October 2014 15:28
By: BlackSwan
  complex view
oracle
By: mukulpratap43 on Wed, 15 October 2014
1 366 Wed, 15 October 2014 08:13
By: Michel Cadot
icon4.gif Please help in this problem
TOAD
By: praveen9728 on Wed, 15 October 2014
7 451 Wed, 15 October 2014 03:18
By: Lalit Kumar B
  DBMS_SCHEDULER.Create_Job related Error
Oracle 11g, Linux
By: expertsudhir on Tue, 14 October 2014
4 477 Wed, 15 October 2014 02:30
By: John Watson
  dbms_stats and bind variables
enterprise 11.2.0.4 pl/sql
By: projob66 on Mon, 13 October 2014
6 435 Tue, 14 October 2014 07:41
By: John Watson
icon4.gif PLS-00497:cannot mix between single row and multi-row (BULK) in INTO LIST
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: jhonnappier2007 on Mon, 13 October 2014
6 468 Tue, 14 October 2014 03:46
By: jhonnappier2007
  Convert a string to a date using TO_DATE Function in after insert trigger?
By: mattfriend on Mon, 13 October 2014
11 462 Tue, 14 October 2014 03:43
By: cookiemonster
  The optimal approach to this search
By: hahaie on Tue, 14 October 2014
3 324 Tue, 14 October 2014 02:26
By: hahaie
  Select distinct rows before special character
Oracle 11g
By: abhayman on Mon, 13 October 2014
4 298 Mon, 13 October 2014 13:53
By: Michel Cadot
  Merge data to a table based on criteria
Oracle 11
By: Member2014 on Thu, 18 September 2014
13 705 Mon, 13 October 2014 11:51
By: Member2014
  query to quit after repeating values
By: chatwidravi on Sun, 12 October 2014
3 334 Sun, 12 October 2014 14:14
By: Solomon Yakobson
  ORA-02291: how to assign value to varchar2 variable depending on specific input?
By: Silently_Quiet_Logic on Sun, 12 October 2014
2 333 Sun, 12 October 2014 08:59
By: John Watson
  CASE STATEMENT IN DDL
Oracle 11g
By: kiwinz on Tue, 23 September 2014
10 585 Sun, 12 October 2014 04:02
By: kiwinz
  Analytic Function
11g
By: kiwinz on Sun, 12 October 2014
5 353 Sun, 12 October 2014 02:38
By: Michel Cadot
  ORDER BY 'constant' oracle partition
By: kiwinz on Thu, 25 September 2014
8 467 Sun, 12 October 2014 02:13
By: kiwinz
  PL/SQL home test
11g
By: dailyumm on Fri, 10 October 2014
3 384 Fri, 10 October 2014 10:08
By: EdStevens
  replace a letter '
Oracle 11g
By: rohan10k on Wed, 08 October 2014
9 428 Wed, 08 October 2014 09:17
By: Lalit Kumar B
  FORALL BULK COLLECT
Oracle 10g
By: ORAGENASHOK on Wed, 08 October 2014
21 501 Wed, 08 October 2014 08:25
By: joy_division
  Send email from DB server to mail server.
Postgresql
By: waheguru on Wed, 08 October 2014
4 315 Wed, 08 October 2014 05:26
By: waheguru
  Session specific data using gtt
Oracle 10g
By: ind!@2020 on Sat, 04 October 2014
13 609 Tue, 07 October 2014 04:29
By: cookiemonster
  How to avoid OR condition in the below scenario, how we can write in different ways
Oracle 11g
By: na.dharma@gmail.com on Fri, 03 October 2014
23 985 Tue, 07 October 2014 04:24
By: Lalit Kumar B
  Outer Join on Values
By: Mayur Shinde on Tue, 23 September 2014
8 515 Mon, 06 October 2014 22:49
By: Mayur Shinde
  how can i secure some row from my table
oracle database 10g, windows 7
By: x-oracle on Wed, 24 September 2014
16 631 Mon, 06 October 2014 11:46
By: Lalit Kumar B
  Please tell me use of DBMS_SCHEDULER ( 1 2)
By: aaditya321 on Tue, 23 September 2014
41 983 Mon, 06 October 2014 09:44
By: Lalit Kumar B
  XML to Oracle data import
By: babar82 on Mon, 06 October 2014
1 314 Mon, 06 October 2014 06:15
By: pablolee
  Strange Error 04021 timeout occurred while waiting to lock object <DIRECTORY>
Oracle 10g
By: donato on Wed, 01 October 2014
9 647 Mon, 06 October 2014 05:14
By: Michel Cadot
  Include row with out group by
Oracle 10g
By: ind!@2020 on Sat, 04 October 2014
5 470 Mon, 06 October 2014 03:41
By: Michel Cadot
  Question on LONG datatype
11g
By: andrewscharles89 on Sat, 04 October 2014
10 461 Sun, 05 October 2014 06:42
By: Solomon Yakobson
  New developer and facing trouble with a store procedure
Oracle 11g
By: new_techie_14 on Thu, 02 October 2014
7 444 Fri, 03 October 2014 07:40
By: EdStevens
  Re: Update trigger
Form 6i window 7 ultimate(32)
By: milikiel on Wed, 01 October 2014
3 433 Thu, 02 October 2014 08:49
By: CraigB
  table Data
6i
By: shahzad-ul-hasan on Tue, 30 September 2014
8 437 Wed, 01 October 2014 22:25
By: shahzad-ul-hasan
  SQL Query
Oracle 11g
By: srinivas.k2005 on Wed, 01 October 2014
7 408 Wed, 01 October 2014 10:59
By: Lalit Kumar B
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 Dec 22 07:37:46 CST 2014

Total time taken to generate the page: 0.11600 seconds