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 add to the right side of my table, the colums and data of 2 other tables .
Oracle 12c
By: mpniel on Mon, 08 May 2017
5 662 Mon, 08 May 2017 10:50
By: mpniel
icon5.gif Adding missing values in external table
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 05 May 2017
7 972 Sat, 06 May 2017 07:20
By: Solomon Yakobson
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 1184 Fri, 05 May 2017 12:00
By: Michel Cadot
icon5.gif Using Virtual Column
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 05 May 2017
18 1491 Fri, 05 May 2017 05:06
By: kaos.tissue
  ORA-14097
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: scottwmackey on Thu, 04 May 2017
2 788 Thu, 04 May 2017 15:53
By: scottwmackey
  Inserting data in multiple tables
Oracle 11g R2, pl/sql
By: kaos.tissue on Tue, 02 May 2017
27 2148 Thu, 04 May 2017 08:34
By: Bill B
  Need to get the top 3 employees whose salary increased in three consecutive year
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Product ,window
By: arpit0508 on Thu, 27 April 2017
6 1191 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 717 Thu, 27 April 2017 02:23
By: mmohsinaziz
  NOT LIKE operation on the numbers columns
Oracle 12c
By: ora_newbie111 on Sun, 16 April 2017
20 2468 Wed, 26 April 2017 10:47
By: Bill B
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 1137 Wed, 26 April 2017 06:49
By: EdStevens
  SQL Tunning - Please Help Me
Oracle 10g
By: parthaspaul@gmail.com on Mon, 17 April 2017
21 1827 Mon, 24 April 2017 18:21
By: mikek
  PLS-00497: cannot mix between single row and multi-row (BULK) in
oracle 10.2.0.4.0 - 64bi linux
By: sundarfaq on Thu, 08 March 2012
6 21357 Mon, 24 April 2017 15:40
By: Barbara Boehmer
  ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT
By: mskphani on Mon, 24 April 2017
4 889 Mon, 24 April 2017 10:50
By: Michel Cadot
  Taking Sum of Similar Tables
Oracle 11g
By: gobi21 on Sun, 23 April 2017
13 1316 Mon, 24 April 2017 07:45
By: gobi21
  Pivot result using "Pivot" keyword
11.2
By: lott42 on Thu, 20 April 2017
4 764 Fri, 21 April 2017 12:22
By: lott42
  LIKE vs NOT LIKE operator
Oracle 12c
By: srinivas.k2005 on Fri, 21 April 2017
4 699 Fri, 21 April 2017 08:47
By: srinivas.k2005
  DEFINE_COLUMN in DBMS_SQL
Oracle 11.2.0.3
By: pointers on Thu, 20 April 2017
2 602 Fri, 21 April 2017 02:09
By: pointers
  Need help to form Query to split count into multiple rows
By: rakesh281214 on Wed, 19 April 2017
5 842 Thu, 20 April 2017 14:30
By: Barbara Boehmer
  merge issue
By: JEWEL78 on Tue, 18 April 2017
11 1280 Thu, 20 April 2017 03:55
By: cookiemonster
  Regexp magic ! (I hope)
11.2.0.3.0
By: Amine on Fri, 14 April 2017
6 825 Wed, 19 April 2017 01:47
By: Michel Cadot
  pl/sql procedure using cursors
oracle 11g
By: POGAKU_SANTHOSH on Mon, 17 April 2017
3 565 Mon, 17 April 2017 16:03
By: BlackSwan
  Help required in SQL Analytic Function lag()
Oracle 11gR2 11.2.0.1.0
By: jimit_shaili on Sat, 15 April 2017
5 796 Mon, 17 April 2017 12:31
By: Michel Cadot
  Partition tablespace name does not change after moving subpartition
oracle12c
By: shrinika on Sat, 15 April 2017
2 742 Sat, 15 April 2017 12:59
By: shrinika
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 614 Fri, 14 April 2017 15:49
By: Bill B
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 654 Tue, 11 April 2017 12:56
By: Bill B
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 881 Sat, 08 April 2017 07:42
By: pointers
  UNION and dependent LOV
Oracle R12
By: umamagi on Fri, 07 April 2017
3 785 Sat, 08 April 2017 03:20
By: Littlefoot
  Pre Insert logic in Trigger
Oracle 11.2.0.3
By: pointers on Wed, 05 April 2017
10 1092 Thu, 06 April 2017 21:09
By: pointers
  Avoid Distinct
Oracle 11g
By: manikandan23 on Wed, 05 April 2017
6 863 Thu, 06 April 2017 03:33
By: cookiemonster
  package
By: jay12 on Wed, 05 April 2017
3 646 Thu, 06 April 2017 03:30
By: cookiemonster
  Split clob data and store in table
Oracle 11g
By: Roots_ct5 on Tue, 04 April 2017
3 760 Tue, 04 April 2017 10:30
By: Roots_ct5
  Need a help with SQL
Oracle 12C
By: mangeshbhasme on Sun, 02 April 2017
10 1087 Tue, 04 April 2017 06:59
By: EdStevens
  how to send tablespace mail alerts with PL/SQL
By: diomahardhika on Mon, 13 March 2017
24 2422 Tue, 04 April 2017 03:56
By: cookiemonster
  How can I convert a SQL command to MySql
By: vinodkalpaka on Mon, 03 April 2017
24 2401 Tue, 04 April 2017 03:28
By: vinodkalpaka
  Need help with SQL
Oracle 12c
By: jvanh on Fri, 31 March 2017
11 1336 Mon, 03 April 2017 07:05
By: John Watson
  Converting comma separated value in different rows
Oracle 10g R2
By: amarbose on Sun, 02 April 2017
5 782 Mon, 03 April 2017 01:34
By: Michel Cadot
  Can we replace any sub query using join
By: asliyanage on Wed, 22 March 2017
3 749 Sat, 01 April 2017 02:59
By: Michel Cadot
  oracle-dbms-fga-dynamically-create-an-audit-trail-or-policy (3 threads merged by bb)
By: jokrasa on Wed, 22 March 2017
9 1296 Fri, 31 March 2017 11:45
By: Bill B
  Re: ToDate function (split from hijacked thread http://www.orafaq.com/forum/t/56308/ by bb)
By: hyder on Thu, 30 March 2017
2 600 Fri, 31 March 2017 11:41
By: Bill B
  UTL_FILE_DIR
Oracle 10gR2/ Solaris 10
By: reym21 on Wed, 29 March 2017
13 1362 Thu, 30 March 2017 07:22
By: Bill 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: Sat Jul 21 17:46:00 CDT 2018