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
Dynamic SQL in cursor By: phiroc on Mon, 14 September 2015	21	7627	Tue, 15 September 2015 11:05 By: cookiemonster
Using constants By: phiroc on Mon, 14 September 2015	5	3143	Tue, 15 September 2015 10:40 By: phiroc
except duplicate record By: Nasir.azeem on Fri, 11 September 2015	9	3809	Mon, 14 September 2015 07:25 By: cookiemonster
Display the range wise column names 11.2.0.3 By: grpatwari on Fri, 21 August 2015	14	5315	Mon, 14 September 2015 07:16 By: cookiemonster
String Comparasition By: steek12 on Sun, 13 September 2015	3	2605	Mon, 14 September 2015 03:42 By: steek12
how to write this unpivot query oracle 12c. By: zeninblue on Fri, 11 September 2015	3	4449	Fri, 11 September 2015 19:18 By: BlackSwan
String longer than 4000 chars inside cursor-for loop Oracle 11g, Oracle SQL Developer 3.2.10.09 By: yepp on Thu, 10 September 2015	10	21105	Fri, 11 September 2015 11:12 By: jois
Count records from two tables RDBMS 11G, EBS 11i By: oteixeira on Fri, 11 September 2015	4	4488	Fri, 11 September 2015 09:21 By: oteixeira
Consolidated output from a LOOP Oracle 12c, windows 2012 By: muktha_22 on Thu, 10 September 2015	11	11092	Fri, 11 September 2015 02:49 By: cookiemonster
Search Oracle table and only list data depending on rows Oracle 11 By: aft5425@anthem.com on Thu, 10 September 2015	4	4529	Fri, 11 September 2015 00:14 By: Littlefoot
Compare 2 encrypted values Oralce 12c - Release 12.1.0.2.0 By: raskotha on Thu, 10 September 2015	3	3647	Thu, 10 September 2015 14:10 By: Michel Cadot
hierarchial query oracle 10g By: kadhirvel.k on Thu, 10 September 2015	2	2032	Thu, 10 September 2015 00:49 By: Michel Cadot
How to display employee table information based on salary in different ranges Oracle 11g, windows By: nbarun07 on Wed, 09 September 2015	9	4722	Wed, 09 September 2015 10:07 By: sandeep_orafaq
Different way of writing OR condition Oralce 11 g By: na.dharma@gmail.com on Tue, 08 September 2015	2	1965	Tue, 08 September 2015 05:06 By: Flyby
Data Function help By: samyms on Fri, 04 September 2015	3	2645	Tue, 08 September 2015 02:39 By: sandeep_orafaq
PLSQL - providing values to Bind variables appearing multiple times in USING clause Oracle 11g, Linux By: danand77 on Sun, 06 September 2015	6	3492	Mon, 07 September 2015 07:52 By: Michel Cadot
Remove Second Occurrence of a word in String oracle form 10G By: malya on Fri, 04 September 2015	18	7210	Sat, 05 September 2015 07:15 By: Solomon Yakobson
ora-00900 invalid sql statement while using open cursor for variable By: bhardkap on Fri, 28 August 2015	14	8807	Fri, 04 September 2015 10:07 By: Michel Cadot
Table Lock Oracle 11g By: stsivaraj on Tue, 01 September 2015	5	3163	Fri, 04 September 2015 00:53 By: Michel Cadot
to derive previous dates and ignore first date Oracle 11g ( 1 2) By: rohit_shinez on Fri, 14 August 2015	63	17570	Thu, 03 September 2015 23:04 By: BlackSwan
Constraint problem for flag Oracle 11 By: brown_zzz on Thu, 03 September 2015	5	2694	Thu, 03 September 2015 09:10 By: brown_zzz
Top 2 Salary from Each Dept without using Analytic Function Oracle 11g,windows 7 By: aspire on Wed, 02 September 2015	14	6289	Thu, 03 September 2015 00:51 By: Michel Cadot
migrate View from SQL to Oracle 11.g By: oracle1987 on Wed, 02 September 2015	7	3998	Wed, 02 September 2015 08:35 By: Michel Cadot
Data migration fromOracle to SFDC By: vasudevaviswa on Tue, 01 September 2015	3	3217	Tue, 01 September 2015 18:20 By: BlackSwan
innerjoin on variable date range By: mattz on Mon, 31 August 2015	3	2799	Tue, 01 September 2015 06:39 By: pablolee
Order by in Listagg Oracle 11g By: Xandot on Tue, 01 September 2015	3	2297	Tue, 01 September 2015 04:13 By: Xandot
Struggling with Query holding temp space Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: manubatham20 on Mon, 31 August 2015	1	1826	Mon, 31 August 2015 10:30 By: BlackSwan
MERGE db 12.1.0.2 By: John Watson on Fri, 28 August 2015	2	2105	Fri, 28 August 2015 13:59 By: John Watson
Need data beween date range Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: sathishh.mk@gmail.com on Thu, 27 August 2015	9	3877	Fri, 28 August 2015 04:16 By: sandeep_orafaq
procedure to give ALTER USER to another Oracle RDBMS 11G and above By: wolffjw on Thu, 27 August 2015	6	3639	Thu, 27 August 2015 15:03 By: Michel Cadot
Finding matching values Oracle 11.2.0.4 By: manubatham20 on Wed, 19 August 2015	12	5720	Thu, 27 August 2015 09:35 By: manubatham20
Query 9i By: glmjoy on Wed, 26 August 2015	4	2919	Wed, 26 August 2015 09:03 By: CraigB
Add +1 to Date Field (Newbie to SQL and Oracle) Oracle By: bseismic on Tue, 25 August 2015	4	2943	Wed, 26 August 2015 06:20 By: EdStevens
Table partition oracle By: sanodani on Mon, 24 August 2015	23	6921	Wed, 26 August 2015 02:31 By: cookiemonster
compare column value to a column value in next row Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 By: rkhatiwala on Fri, 21 August 2015	2	2667	Mon, 24 August 2015 08:53 By: rkhatiwala
Oracle Hierarchical Query max_level/connect_by_is_root Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: tmcallister on Thu, 20 August 2015	4	3451	Fri, 21 August 2015 10:46 By: tmcallister
Update statement where update exists. Oracle 12.1.0.1.0 Window By: tmcallister on Thu, 01 May 2014	6	3880	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	2789	Fri, 21 August 2015 10:36 By: Michel Cadot
Creating String Oracle 11g By: Xandot on Fri, 31 July 2015	21	8792	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	4889	Thu, 20 August 2015 03:06 By: Michel Cadot