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
Operating with columns within a table Oracle 11g 11.2.0.2.0 By: Cirov on Sun, 14 May 2017	27	620	Thu, 18 May 2017 06:41 By: EdStevens
snapshot too old PLSQL 11g By: kmnainani on Thu, 11 May 2017	22	806	Wed, 17 May 2017 07:02 By: cookiemonster
ListAgg results 11.2 By: lott42 on Fri, 12 May 2017	9	452	Mon, 15 May 2017 11:41 By: lott42
Loading Data into multiple tables Oracle 11g R2, pl/sql By: kaos.tissue on Fri, 12 May 2017	18	609	Mon, 15 May 2017 06:56 By: EdStevens
filesystem_like_logging is not in ddl of table oracle 12.1.0.2,Windows Server 2014 By: chad_2000 on Mon, 15 May 2017	5	411	Mon, 15 May 2017 06:48 By: chad_2000
Taking time from current day/month/year 06:00:00 to sysdate(Current Time) Oracle 10 g By: baranwalb on Sat, 13 May 2017	3	212	Sat, 13 May 2017 06:38 By: Michel Cadot
Multiple values in one-many relationship Oracle 11g R2, pl/sql By: kaos.tissue on Sat, 13 May 2017	2	233	Sat, 13 May 2017 02:51 By: kaos.tissue
Error SQL: ORA-02270: no matching unique or primary key for this column-list Oracle 11g By: Cirov on Fri, 12 May 2017	3	172	Fri, 12 May 2017 10:51 By: Michel Cadot
Instead of Trigger Oracle 11g R2, pl/sql By: kaos.tissue on Sat, 06 May 2017	23	21548	Fri, 12 May 2017 10:13 By: Michel Cadot
Trigger to join and insert data into table. Oracle 11g R2, pl/sql By: kaos.tissue on Thu, 11 May 2017	39	904	Fri, 12 May 2017 07:17 By: EdStevens
Pass two or more value Microsoft Visual Studio By: jen888 on Wed, 10 May 2017	3	243	Fri, 12 May 2017 06:40 By: cookiemonster
Using REGEXP_LIKE Oracle 12c By: GusGF on Fri, 12 May 2017	1	159	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	222	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	1486	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	253	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	1454	Wed, 10 May 2017 06:52 By: spd800c
problem with FLOOR function oracle By: omidsm on Wed, 10 May 2017	4	1580	Wed, 10 May 2017 03:38 By: omidsm
Decode and To_date By: SamP17 on Mon, 08 May 2017	13	1669	Wed, 10 May 2017 03:24 By: cookiemonster
invalid file operation Oracle 12C , IBM AIX By: Durai_1 on Tue, 09 May 2017	5	1836	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	1184	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	10173	Tue, 09 May 2017 10:37 By: Olivier Comte
Outer Join on Table Forms 6i By: syedferhat on Mon, 08 May 2017	8	316	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	519	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	193	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	336	Sat, 06 May 2017 07:20 By: Solomon Yakobson
Get Return Value from Function without SELECT By: whdyck on Thu, 04 May 2017	8	309	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	318	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	211	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	632	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	589	Mon, 01 May 2017 03:05 By: arpit0508
COnditional change Serial Oracle 11G, Windows 2003 By: mmohsinaziz on Thu, 27 April 2017	2	356	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	969	Wed, 26 April 2017 10:47 By: Bill B
Issue with DATE By: rajkumar561991 on Tue, 25 April 2017	5	510	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	621	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	17504	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	217	Mon, 24 April 2017 10:50 By: Michel Cadot
Taking Sum of Similar Tables Oracle 11g By: gobi21 on Sun, 23 April 2017	13	405	Mon, 24 April 2017 07:45 By: gobi21
Pivot result using "Pivot" keyword 11.2 By: lott42 on Thu, 20 April 2017	4	313	Fri, 21 April 2017 12:22 By: lott42
LIKE vs NOT LIKE operator Oracle 12c By: srinivas.k2005 on Fri, 21 April 2017	4	243	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	172	Fri, 21 April 2017 02:09 By: pointers