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
Merge String Oracle 11g By: Xandot on Thu, 20 August 2015	4	3556	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	4160	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	11103	Wed, 19 August 2015 08:23 By: Bill B
Challenging Query Oracle 11g , Windows 8 By: rakeshramm on Tue, 18 August 2015	5	2672	Tue, 18 August 2015 06:44 By: Michel Cadot
Hierarchy flattening and repetition By: loosecontrol on Tue, 18 August 2015	3	2961	Tue, 18 August 2015 05:23 By: Michel Cadot
Exact String Match in Instr Oracle 11g By: Xandot on Sun, 16 August 2015	21	12442	Tue, 18 August 2015 00:30 By: Michel Cadot
Need a Stored Procedure ( 1 2 3) By: vasudevaviswa on Wed, 05 August 2015	86	25363	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	7863	Mon, 17 August 2015 01:26 By: Michel Cadot
Need a Help on SQL query By: ajay696 on Fri, 14 August 2015	7	3730	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	6855	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	3582	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	1909	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	3978	Thu, 13 August 2015 07:36 By: cookiemonster
insert incremented value plsql By: sanodani on Thu, 13 August 2015	4	2815	Thu, 13 August 2015 06:34 By: sanodani
Cursor Query help Oracle By: GeetikaLearn on Mon, 10 August 2015	6	3797	Wed, 12 August 2015 12:24 By: GeetikaLearn
SQL join By: sanodani on Tue, 11 August 2015	5	3078	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	2285	Tue, 11 August 2015 10:04 By: Michel Cadot
union sql By: palpali on Tue, 11 August 2015	5	2967	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	2490	Mon, 10 August 2015 13:56 By: pablolee
Need PL/SQL Script 12.1.3 By: vharish006 on Mon, 10 August 2015	5	4225	Mon, 10 August 2015 13:56 By: vharish006
calulating target and actual hrs sql By: palpali on Tue, 04 August 2015	16	5882	Mon, 10 August 2015 00:32 By: palpali
How to get value of table oracle 11g By: realbassist on Thu, 06 August 2015	18	8266	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	2209	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	2354	Thu, 06 August 2015 19:09 By: namitanamburi
Update multiple columns in Case Oracle 11g By: Xandot on Thu, 06 August 2015	2	2685	Thu, 06 August 2015 11:39 By: cookiemonster
Convert rows into columns oracle 10g By: nciteamo on Thu, 06 August 2015	2	2150	Thu, 06 August 2015 05:27 By: nciteamo
Merge on tables 11.2.0.3 By: vasudevaviswa on Tue, 04 August 2015	13	4890	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	7825	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	10271	Wed, 05 August 2015 09:14 By: Bill B
sql replacement price 11gr2 By: hudo on Wed, 05 August 2015	5	3008	Wed, 05 August 2015 06:24 By: hudo
only show the duplicated records By: ajen7118 on Tue, 04 August 2015	4	2649	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	2780	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	4104	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	6075	Mon, 03 August 2015 12:38 By: freestyle
SQL Query Oracle 11g By: kr1347 on Sun, 02 August 2015	9	4288	Mon, 03 August 2015 09:32 By: bugfox
problem in record type oracle 11g By: somu1984 on Tue, 28 July 2015	6	4149	Fri, 31 July 2015 08:36 By: Lalit Kumar B
Joining Two View Oracle 11G By: samyms on Thu, 30 July 2015	19	7258	Fri, 31 July 2015 07:15 By: cookiemonster
Union Join By: ajen7118 on Thu, 30 July 2015	3	2652	Fri, 31 July 2015 02:55 By: cookiemonster
i want to find the string 'EMP1' which procedures have that string under the package oracle 11 By: eswararaodba@gmail.com on Thu, 30 July 2015	3	2352	Fri, 31 July 2015 02:51 By: cookiemonster
Time period condition By: patneel on Thu, 30 July 2015	8	3824	Fri, 31 July 2015 01:29 By: Michel Cadot