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
  Error SQL: ORA-02270: no matching unique or primary key for this column-list
Oracle 11g
By: Cirov on Fri, 12 May 2017
3 6578 Fri, 12 May 2017 10:51
By: Michel Cadot
icon5.gif Instead of Trigger
Oracle 11g R2, pl/sql
By: kaos.tissue on Sat, 06 May 2017
23 29452 Fri, 12 May 2017 10:13
By: Michel Cadot
icon5.gif Trigger to join and insert data into table.
Oracle 11g R2, pl/sql
By: kaos.tissue on Thu, 11 May 2017
39 11561 Fri, 12 May 2017 07:17
By: EdStevens
  Pass two or more value
Microsoft Visual Studio
By: jen888 on Wed, 10 May 2017
3 2607 Fri, 12 May 2017 06:40
By: cookiemonster
  Using REGEXP_LIKE
Oracle 12c
By: GusGF on Fri, 12 May 2017
1 2297 Fri, 12 May 2017 05:48
By: flyboy
  Loop SP out cursor inside a stored procedure
11.0.2.10
By: OraFerro on Wed, 10 May 2017
9 6114 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 3523 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 4119 Wed, 10 May 2017 06:52
By: spd800c
  problem with FLOOR function
oracle
By: omidsm on Wed, 10 May 2017
4 3635 Wed, 10 May 2017 03:38
By: omidsm
  Decode and To_date
By: SamP17 on Mon, 08 May 2017
13 7655 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 4959 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 2984 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 47792 Tue, 09 May 2017 10:37
By: Olivier Comte
  Outer Join on Table
Forms 6i
By: syedferhat on Mon, 08 May 2017
8 3623 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 6285 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 2478 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 3040 Sat, 06 May 2017 07:20
By: Solomon Yakobson
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 4157 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 5958 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 2730 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 8606 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 3716 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 2206 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 8768 Wed, 26 April 2017 10:47
By: Bill B
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 3310 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 7130 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 39695 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 2707 Mon, 24 April 2017 10:50
By: Michel Cadot
  Taking Sum of Similar Tables
Oracle 11g
By: gobi21 on Sun, 23 April 2017
13 5583 Mon, 24 April 2017 07:45
By: gobi21
  Pivot result using "Pivot" keyword
11.2
By: lott42_gmail on Thu, 20 April 2017
4 2558 Fri, 21 April 2017 12:22
By: lott42_gmail
  LIKE vs NOT LIKE operator
Oracle 12c
By: srinivas.k2005 on Fri, 21 April 2017
4 2245 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 5605 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 3461 Thu, 20 April 2017 14:30
By: Barbara Boehmer
  merge issue
By: JEWEL78 on Tue, 18 April 2017
11 4863 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 2793 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 2247 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 2798 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 2473 Sat, 15 April 2017 12:59
By: shrinika
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 2046 Fri, 14 April 2017 15:49
By: Bill B
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 1987 Tue, 11 April 2017 12:56
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: Thu Mar 28 17:59:01 CDT 2024