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
  Sequence ora-8002 error for every connection.
Oracle 12, Linux
By: pradies on Tue, 28 October 2014
2 272 Tue, 28 October 2014 03:32
By: Michel Cadot
  SQL Query Optimization
Oracle 11g
By: raj_te on Fri, 17 October 2014
27 947 Mon, 27 October 2014 10:46
By: raj_te
  Merging Data from three sources and identifying duplicates
PL/SQL
By: mohammed.mca09@gmail.com on Sun, 26 October 2014
6 536 Sun, 26 October 2014 22:03
By: Barbara Boehmer
  Merging two tables based on child table FK
11.2.0.1.0
By: OraFerro on Sun, 26 October 2014
1 273 Sun, 26 October 2014 05:34
By: Solomon Yakobson
  REMOVE DUPLICATES IN ROWS TO COLUMN
Oracle 10G r2
By: mmohsinaziz on Thu, 23 October 2014
11 524 Sat, 25 October 2014 10:35
By: Lalit Kumar B
  how to write return in the function
By: mist598 on Fri, 24 October 2014
7 358 Fri, 24 October 2014 09:45
By: Michel Cadot
icon8.gif Insert Hangs
Oracle 10.0.2
By: nnr420 on Thu, 09 October 2014
24 853 Fri, 24 October 2014 03:11
By: Michel Cadot
  SET Autocommit XXXX
oracle 11g Release 2, Linux
By: azeem87 on Wed, 22 October 2014
2 267 Wed, 22 October 2014 14:50
By: azeem87
  FractionalAgents
Oracle 11G
By: samrams on Wed, 22 October 2014
3 266 Wed, 22 October 2014 12:35
By: Bill B
  need sql query
11g
By: mvrkr44 on Wed, 22 October 2014
3 327 Wed, 22 October 2014 10:31
By: John Watson
  problem with case statement
Oracle 10g
By: bobghw on Mon, 20 October 2014
15 574 Tue, 21 October 2014 14:42
By: Michel Cadot
  CREATE TABLE AS vs CREATE TABLE then INSERT
PL/SQL Developer 10.0.5.1710
By: techiesue83 on Mon, 20 October 2014
13 631 Tue, 21 October 2014 13:30
By: knw15pwr
  What is wrong with this trigger?
Oracle, 10g, windows
By: wzfoto on Fri, 17 October 2014
4 438 Mon, 20 October 2014 08:50
By: wzfoto
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
By: mist598 on Wed, 15 October 2014
13 852 Mon, 20 October 2014 00:05
By: Michel Cadot
  How to Find Duplicate Groups (group of records) in Oracle
Oracle 11g
By: dhakanes@gmail.com on Fri, 26 September 2014
30 1488 Sun, 19 October 2014 19:14
By: Solomon Yakobson
  to_date error
By: irfankundi786@yahoo.com on Sat, 18 October 2014
4 640 Sun, 19 October 2014 07:39
By: Lalit Kumar B
  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 543 Sat, 18 October 2014 13:43
By: Lalit Kumar B
  Generating Numbers between given ranges
Oracle
By: manubatham20 on Fri, 17 October 2014
8 390 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 419 Fri, 17 October 2014 08:54
By: Bill B
  How to calculate age between timestamp ?
By: tondapi on Fri, 17 October 2014
3 318 Fri, 17 October 2014 06:57
By: Michel Cadot
  substring instr query
SQL Oracle
By: incrediblek on Fri, 17 October 2014
2 341 Fri, 17 October 2014 04:46
By: Lalit Kumar B
  oracle
By: shwetha naren on Thu, 16 October 2014
1 240 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 257 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 351 Thu, 16 October 2014 05:24
By: javed.khan
  Merge collections ?
By: lijjumathew on Wed, 15 October 2014
2 235 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 535 Wed, 15 October 2014 15:28
By: BlackSwan
  complex view
oracle
By: mukulpratap43 on Wed, 15 October 2014
1 367 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 455 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 494 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 441 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 479 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 467 Tue, 14 October 2014 03:43
By: cookiemonster
  The optimal approach to this search
By: hahaie on Tue, 14 October 2014
3 329 Tue, 14 October 2014 02:26
By: hahaie
  Select distinct rows before special character
Oracle 11g
By: abhayman on Mon, 13 October 2014
4 303 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 713 Mon, 13 October 2014 11:51
By: Member2014
  query to quit after repeating values
By: chatwidravi on Sun, 12 October 2014
3 337 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 339 Sun, 12 October 2014 08:59
By: John Watson
  CASE STATEMENT IN DDL
Oracle 11g
By: kiwinz on Tue, 23 September 2014
10 593 Sun, 12 October 2014 04:02
By: kiwinz
  Analytic Function
11g
By: kiwinz on Sun, 12 October 2014
5 357 Sun, 12 October 2014 02:38
By: Michel Cadot
  ORDER BY 'constant' oracle partition
By: kiwinz on Thu, 25 September 2014
8 481 Sun, 12 October 2014 02:13
By: kiwinz
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: Fri Dec 26 19:47:08 CST 2014

Total time taken to generate the page: 0.39110 seconds