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 calculate time variation between same day times.
Oracle 10g R2, Windows Server 2008 64 bit
By: mdsirajoddin on Wed, 15 October 2014
6 605 Sat, 18 October 2014 13:43
By: Lalit Kumar B
  Generating Numbers between given ranges
Oracle
By: manubatham20 on Fri, 17 October 2014
8 583 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 451 Fri, 17 October 2014 08:54
By: Bill B
  How to calculate age between timestamp ?
By: tondapi on Fri, 17 October 2014
3 385 Fri, 17 October 2014 06:57
By: Michel Cadot
  substring instr query
SQL Oracle
By: incrediblek on Fri, 17 October 2014
2 407 Fri, 17 October 2014 04:46
By: Lalit Kumar B
  oracle
By: shwetha naren on Thu, 16 October 2014
1 311 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 330 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 391 Thu, 16 October 2014 05:24
By: javed.khan
  Merge collections ?
By: lijjumathew on Wed, 15 October 2014
2 305 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 649 Wed, 15 October 2014 15:28
By: BlackSwan
  complex view
oracle
By: mukulpratap43 on Wed, 15 October 2014
1 398 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 539 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 787 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 527 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 761 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 555 Tue, 14 October 2014 03:43
By: cookiemonster
  The optimal approach to this search
By: hahaie on Tue, 14 October 2014
3 390 Tue, 14 October 2014 02:26
By: hahaie
  Select distinct rows before special character
Oracle 11g
By: abhayman on Mon, 13 October 2014
4 361 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 797 Mon, 13 October 2014 11:51
By: Member2014
  query to quit after repeating values
By: chatwidravi on Sun, 12 October 2014
3 399 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 403 Sun, 12 October 2014 08:59
By: John Watson
  CASE STATEMENT IN DDL
Oracle 11g
By: kiwinz on Tue, 23 September 2014
10 680 Sun, 12 October 2014 04:02
By: kiwinz
  Analytic Function
11g
By: kiwinz on Sun, 12 October 2014
5 410 Sun, 12 October 2014 02:38
By: Michel Cadot
  ORDER BY 'constant' oracle partition
By: kiwinz on Thu, 25 September 2014
8 571 Sun, 12 October 2014 02:13
By: kiwinz
  PL/SQL home test
11g
By: dailyumm on Fri, 10 October 2014
3 444 Fri, 10 October 2014 10:08
By: EdStevens
  replace a letter '
Oracle 11g
By: rohan10k on Wed, 08 October 2014
9 489 Wed, 08 October 2014 09:17
By: Lalit Kumar B
  FORALL BULK COLLECT
Oracle 10g
By: ORAGENASHOK on Wed, 08 October 2014
21 652 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 378 Wed, 08 October 2014 05:26
By: waheguru
  Session specific data using gtt
Oracle 10g
By: ind!@2020 on Sat, 04 October 2014
13 734 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 1072 Tue, 07 October 2014 04:24
By: Lalit Kumar B
  Outer Join on Values
By: Mayur Shinde on Tue, 23 September 2014
8 591 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 716 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 1100 Mon, 06 October 2014 09:44
By: Lalit Kumar B
  XML to Oracle data import
By: babar82 on Mon, 06 October 2014
1 377 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 804 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 564 Mon, 06 October 2014 03:41
By: Michel Cadot
  Question on LONG datatype
11g
By: andrewscharles89 on Sat, 04 October 2014
10 568 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 497 Fri, 03 October 2014 07:40
By: EdStevens
  Re: Update trigger
Form 6i window 7 ultimate(32)
By: kilimanjaro on Wed, 01 October 2014
3 504 Thu, 02 October 2014 08:49
By: CraigB
  table Data
6i
By: shahzad-ul-hasan on Tue, 30 September 2014
8 514 Wed, 01 October 2014 22:25
By: shahzad-ul-hasan
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 Apr 01 10:13:28 CDT 2015

Total time taken to generate the page: 0.09911 seconds