OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
SP2-0552: Bind variable "LIMIT" not declared. Oracle database 11.2.04 on Linux By: youngb912 on Wed, 10 May 2017	2	594	Wed, 10 May 2017 19:24 By: youngb912
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	1742	Wed, 10 May 2017 06:52 By: spd800c
problem with FLOOR function oracle By: omidsm on Wed, 10 May 2017	4	1935	Wed, 10 May 2017 03:38 By: omidsm
Decode and To_date By: SamP17 on Mon, 08 May 2017	13	2269	Wed, 10 May 2017 03:24 By: cookiemonster
invalid file operation Oracle 12C , IBM AIX By: Durai_1 on Tue, 09 May 2017	5	2547	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	1451	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	38980	Tue, 09 May 2017 10:37 By: Olivier Comte
Outer Join on Table Forms 6i By: syedferhat on Mon, 08 May 2017	8	835	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	1056	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	530	Mon, 08 May 2017 10:50 By: mpniel
Adding missing values in external table Oracle 11g R2, pl/sql By: kaos.tissue on Fri, 05 May 2017	7	787	Sat, 06 May 2017 07:20 By: Solomon Yakobson
Get Return Value from Function without SELECT By: whdyck on Thu, 04 May 2017	8	768	Fri, 05 May 2017 12:00 By: Michel Cadot
Using Virtual Column Oracle 11g R2, pl/sql By: kaos.tissue on Fri, 05 May 2017	18	908	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	623	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	1512	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	1010	Mon, 01 May 2017 03:05 By: arpit0508
COnditional change Serial Oracle 11G, Windows 2003 By: mmohsinaziz on Thu, 27 April 2017	2	612	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	1707	Wed, 26 April 2017 10:47 By: Bill B
Issue with DATE By: rajkumar561991 on Tue, 25 April 2017	5	992	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	1277	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	20271	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	749	Mon, 24 April 2017 10:50 By: Michel Cadot
Taking Sum of Similar Tables Oracle 11g By: gobi21 on Sun, 23 April 2017	13	881	Mon, 24 April 2017 07:45 By: gobi21
Pivot result using "Pivot" keyword 11.2 By: lott42 on Thu, 20 April 2017	4	614	Fri, 21 April 2017 12:22 By: lott42
LIKE vs NOT LIKE operator Oracle 12c By: srinivas.k2005 on Fri, 21 April 2017	4	562	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	474	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	658	Thu, 20 April 2017 14:30 By: Barbara Boehmer
merge issue By: JEWEL78 on Tue, 18 April 2017	11	809	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	678	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	433	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	643	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	551	Sat, 15 April 2017 12:59 By: shrinika
cursors windows By: jay12 on Tue, 04 April 2017	3	483	Fri, 14 April 2017 15:49 By: Bill B
testing rollback 12.1.0.1 By: jinga on Fri, 07 April 2017	2	547	Tue, 11 April 2017 12:56 By: Bill B
Hierarchical Queries Oracle 11.2.0.3 By: pointers on Thu, 06 April 2017	2	729	Sat, 08 April 2017 07:42 By: pointers
UNION and dependent LOV Oracle R12 By: umamagi on Fri, 07 April 2017	3	631	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	858	Thu, 06 April 2017 21:09 By: pointers
Avoid Distinct Oracle 11g By: manikandan23 on Wed, 05 April 2017	6	677	Thu, 06 April 2017 03:33 By: cookiemonster
package By: jay12 on Wed, 05 April 2017	3	514	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	583	Tue, 04 April 2017 10:30 By: Roots_ct5