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 :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Update statement where update exists. Oracle 12.1.0.1.0 Window By: tmcallister on Thu, 01 May 2014	6	2389	Fri, 21 August 2015 10:37 By: Michel Cadot
Returning a sys_refcursor from an explicit cursor 11.2 By: tmcallister on Mon, 15 December 2014	2	2016	Fri, 21 August 2015 10:36 By: Michel Cadot
Creating String Oracle 11g By: Xandot on Fri, 31 July 2015	21	5222	Thu, 20 August 2015 04:16 By: Lalit Kumar B
PL/SQL: ORA-00911: invalid character Oracle 10g By: P1Oracle on Sat, 18 July 2015	5	3747	Thu, 20 August 2015 03:06 By: Michel Cadot
Merge String Oracle 11g By: Xandot on Thu, 20 August 2015	4	2264	Thu, 20 August 2015 02:12 By: Lalit Kumar B
How to implement Materialized view in PL/SQL using Collections Oracle Database 11g Release 11.2.0.3.0 - Production PL/SQL Release 11.2.0.3.0 - Production "CORE 11.2.0.3.0 Production" TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3 By: Lingaraju H C on Wed, 19 August 2015	10	2399	Wed, 19 August 2015 21:42 By: John Watson
check the column is numeric or data oracle 9i By: arun888 on Mon, 10 August 2015	35	5121	Wed, 19 August 2015 08:23 By: Bill B
Challenging Query Oracle 11g , Windows 8 By: rakeshramm on Tue, 18 August 2015	5	1581	Tue, 18 August 2015 06:44 By: Michel Cadot
Hierarchy flattening and repetition By: loosecontrol on Tue, 18 August 2015	3	2051	Tue, 18 August 2015 05:23 By: Michel Cadot
Exact String Match in Instr Oracle 11g By: Xandot on Sun, 16 August 2015	21	8362	Tue, 18 August 2015 00:30 By: Michel Cadot
Need a Stored Procedure ( 1 2 3) By: vasudevaviswa on Wed, 05 August 2015	86	12498	Mon, 17 August 2015 11:07 By: vasudevaviswa
Need a Query to transpose rows to columns dynamically By: yashaswini.gopalan on Wed, 12 August 2015	20	4568	Mon, 17 August 2015 01:26 By: Michel Cadot
Need a Help on SQL query By: ajay696 on Fri, 14 August 2015	7	2071	Sat, 15 August 2015 09:37 By: EdStevens
LEFT & Right functions to carve out data from a field By: Johnseito on Tue, 11 August 2015	15	4159	Fri, 14 August 2015 15:17 By: Bill B
rownum and order by Oracle 12 By: mats-larsson@iname.com on Thu, 13 August 2015	5	2306	Fri, 14 August 2015 10:24 By: Michel Cadot
Execute stored procedure after interval Oracle 11g By: christian.delbianco on Fri, 14 August 2015	1	1261	Fri, 14 August 2015 02:43 By: Michel Cadot
"Merge" Values in one field with case? Oracle 11.2 on Windows 2008R2 By: forumwurm on Thu, 13 August 2015	9	2315	Thu, 13 August 2015 07:36 By: cookiemonster
insert incremented value plsql By: sanodani on Thu, 13 August 2015	4	1689	Thu, 13 August 2015 06:34 By: sanodani
Cursor Query help Oracle By: GeetikaLearn on Mon, 10 August 2015	6	2492	Wed, 12 August 2015 12:24 By: GeetikaLearn
SQL join By: sanodani on Tue, 11 August 2015	5	1870	Wed, 12 August 2015 04:59 By: Lalit Kumar B
Transpose of rows to Columns & Dynamically Adding the Columns (merged) By: Harsha20 on Tue, 11 August 2015	2	1523	Tue, 11 August 2015 10:04 By: Michel Cadot
union sql By: palpali on Tue, 11 August 2015	5	1814	Tue, 11 August 2015 07:06 By: pablolee
Oracle analytic query help Oracle 10g R10.0.2 By: parmarjm on Mon, 10 August 2015	3	1534	Mon, 10 August 2015 13:56 By: pablolee
Need PL/SQL Script 12.1.3 By: vharish006 on Mon, 10 August 2015	5	2766	Mon, 10 August 2015 13:56 By: vharish006
calulating target and actual hrs sql By: palpali on Tue, 04 August 2015	16	3346	Mon, 10 August 2015 00:32 By: palpali
How to get value of table oracle 11g By: realbassist on Thu, 06 August 2015	18	5436	Fri, 07 August 2015 04:02 By: Lalit Kumar B
Filtering data by aggregated columns calculated in a subquery. By: mcrum1 on Thu, 06 August 2015	2	1420	Fri, 07 August 2015 01:21 By: Littlefoot
help with pattern match REGEXP etc Oracle 11, 12 By: namitanamburi on Wed, 05 August 2015	4	1416	Thu, 06 August 2015 19:09 By: namitanamburi
Update multiple columns in Case Oracle 11g By: Xandot on Thu, 06 August 2015	2	1826	Thu, 06 August 2015 11:39 By: cookiemonster
Convert rows into columns oracle 10g By: nciteamo on Thu, 06 August 2015	2	1364	Thu, 06 August 2015 05:27 By: nciteamo
Merge on tables 11.2.0.3 By: vasudevaviswa on Tue, 04 August 2015	13	2606	Wed, 05 August 2015 14:28 By: vasudevaviswa
Need modification in Stored Procedure. 11.2.0.3 By: vasudevaviswa on Tue, 04 August 2015	19	4516	Wed, 05 August 2015 10:26 By: Michel Cadot
update century in timestamp column in table (topics merged) oracle 10g By: kadhirvel.k on Sat, 01 August 2015	24	6092	Wed, 05 August 2015 09:14 By: Bill B
sql replacement price 11gr2 By: hudo on Wed, 05 August 2015	5	1689	Wed, 05 August 2015 06:24 By: hudo
only show the duplicated records By: ajen7118 on Tue, 04 August 2015	4	1620	Tue, 04 August 2015 15:53 By: BlackSwan
Create a temporary/transient table within a SELECT Oracle Enterprise 11g 11.2.0.4.0 By: johnjacobt on Tue, 04 August 2015	3	1835	Tue, 04 August 2015 06:17 By: Michel Cadot
Generating group of sets from table 10g By: m.abdulhaq on Sun, 02 August 2015	8	2455	Mon, 03 August 2015 13:55 By: m.abdulhaq
Update table procedure through pl sql using double loop Oracle By: freestyle on Wed, 29 July 2015	11	3730	Mon, 03 August 2015 12:38 By: freestyle
SQL Query Oracle 11g By: kr1347 on Sun, 02 August 2015	9	2392	Mon, 03 August 2015 09:32 By: bugfox
problem in record type oracle 11g By: somu1984 on Tue, 28 July 2015	6	2595	Fri, 31 July 2015 08:36 By: Lalit Kumar B