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
icon5.gif Trigger to join and insert data into table.
Oracle 11g R2, pl/sql
By: kaos.tissue on Thu, 11 May 2017
39 1861 Fri, 12 May 2017 07:17
By: EdStevens
  Pass two or more value
Microsoft Visual Studio
By: jen888 on Wed, 10 May 2017
3 532 Fri, 12 May 2017 06:40
By: cookiemonster
  Using REGEXP_LIKE
Oracle 12c
By: GusGF on Fri, 12 May 2017
1 447 Fri, 12 May 2017 05:48
By: flyboy
  PL/SQL: ORA-04053: error occurred when validating remote object
oracle12c
By: shrinika on Thu, 11 May 2017
1 783 Thu, 11 May 2017 15:11
By: Michel Cadot
  Loop SP out cursor inside a stored procedure
11.0.2.10
By: OraFerro on Wed, 10 May 2017
9 2019 Thu, 11 May 2017 07:43
By: Michel Cadot
  SP2-0552: Bind variable "LIMIT" not declared.
Oracle database 11.2.04 on Linux
By: youngb912 on Wed, 10 May 2017
2 601 Wed, 10 May 2017 19:24
By: youngb912
icon5.gif Using CHECK constraint to validate two types of telephone formatted insert data
Oracle 11g Enterprise Ed. Release 11.2.0.1.0 - 64bit, Win 10 Home 64 bit Ed
By: spd800c on Wed, 10 May 2017
4 1748 Wed, 10 May 2017 06:52
By: spd800c
  problem with FLOOR function
oracle
By: omidsm on Wed, 10 May 2017
4 1944 Wed, 10 May 2017 03:38
By: omidsm
  Decode and To_date
By: SamP17 on Mon, 08 May 2017
13 2277 Wed, 10 May 2017 03:24
By: cookiemonster
icon5.gif invalid file operation
Oracle 12C , IBM AIX
By: Durai_1 on Tue, 09 May 2017
5 2558 Tue, 09 May 2017 11:08
By: BlackSwan
  Produce output not having any or all inputs (products)
By: ganesh_jadhav0509 on Tue, 09 May 2017
1 1457 Tue, 09 May 2017 11:06
By: Michel Cadot
  Returning Old value during update
Oracle 10g
By: mani_rbs on Mon, 02 January 2012
12 39021 Tue, 09 May 2017 10:37
By: Olivier Comte
  Outer Join on Table
Forms 6i
By: syedferhat on Mon, 08 May 2017
8 847 Tue, 09 May 2017 03:27
By: cookiemonster
  Dynamic array as SP input
11.0.2.10
By: OraFerro on Sun, 23 April 2017
12 1088 Tue, 09 May 2017 01:58
By: OraFerro
  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 537 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 801 Sat, 06 May 2017 07:20
By: Solomon Yakobson
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 791 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 959 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 645 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 1541 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 1023 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 622 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 1756 Wed, 26 April 2017 10:47
By: Bill B
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 1004 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 1291 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 20331 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 757 Mon, 24 April 2017 10:50
By: Michel Cadot
  Taking Sum of Similar Tables
Oracle 11g
By: gobi21 on Sun, 23 April 2017
13 910 Mon, 24 April 2017 07:45
By: gobi21
  Pivot result using "Pivot" keyword
11.2
By: lott42 on Thu, 20 April 2017
4 622 Fri, 21 April 2017 12:22
By: lott42
  LIKE vs NOT LIKE operator
Oracle 12c
By: srinivas.k2005 on Fri, 21 April 2017
4 571 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 480 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 667 Thu, 20 April 2017 14:30
By: Barbara Boehmer
  merge issue
By: JEWEL78 on Tue, 18 April 2017
11 846 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 689 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 440 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 657 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 570 Sat, 15 April 2017 12:59
By: shrinika
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 498 Fri, 14 April 2017 15:49
By: Bill B
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 554 Tue, 11 April 2017 12:56
By: Bill B
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 743 Sat, 08 April 2017 07:42
By: pointers
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: Thu Apr 26 04:40:11 CDT 2018

Total time taken to generate the page: 0.01677 seconds