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
Pivot By: tunny2014 on Thu, 17 September 2015	8	2987	Thu, 17 September 2015 09:03 By: BlackSwan
Query running fine in TOAD and SQL developer but very slow in Server ( oracle DB) [merged 2] By: saurabh.sha on Fri, 11 September 2015	20	10401	Thu, 17 September 2015 07:04 By: cookiemonster
Table patition and aautomate sub partition. By: raopatwariyahoocom on Tue, 15 September 2015	9	7750	Wed, 16 September 2015 11:49 By: BlackSwan
Options for definitions of INDEXES used by CONSTRAINTS By: mjm22 on Tue, 15 September 2015	2	2717	Wed, 16 September 2015 01:56 By: John Watson
Dynamic SQL in cursor By: phiroc on Mon, 14 September 2015	21	4406	Tue, 15 September 2015 11:05 By: cookiemonster
Using constants By: phiroc on Mon, 14 September 2015	5	1840	Tue, 15 September 2015 10:40 By: phiroc
except duplicate record By: Nasir.azeem on Fri, 11 September 2015	9	2132	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	2858	Mon, 14 September 2015 07:16 By: cookiemonster
String Comparasition By: steek12 on Sun, 13 September 2015	3	1612	Mon, 14 September 2015 03:42 By: steek12
how to write this unpivot query oracle 12c. By: zeninblue on Fri, 11 September 2015	3	3484	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	18699	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	3578	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	9205	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	3630	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	2716	Thu, 10 September 2015 14:10 By: Michel Cadot
hierarchial query oracle 10g By: kadhirvel.k on Thu, 10 September 2015	2	1204	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	2938	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	1231	Tue, 08 September 2015 05:06 By: Flyby
Data Function help By: samyms on Fri, 04 September 2015	3	1658	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	1877	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	3856	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	5536	Fri, 04 September 2015 10:07 By: Michel Cadot
Table Lock Oracle 11g By: stsivaraj on Tue, 01 September 2015	5	1931	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	8688	Thu, 03 September 2015 23:04 By: BlackSwan
Constraint problem for flag Oracle 11 By: brown_zzz on Thu, 03 September 2015	5	1518	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	3907	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	2196	Wed, 02 September 2015 08:35 By: Michel Cadot
Data migration fromOracle to SFDC By: vasudevaviswa on Tue, 01 September 2015	3	1979	Tue, 01 September 2015 18:20 By: BlackSwan
innerjoin on variable date range By: mattz on Mon, 31 August 2015	3	1749	Tue, 01 September 2015 06:39 By: pablolee
Order by in Listagg Oracle 11g By: Xandot on Tue, 01 September 2015	3	1329	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	1185	Mon, 31 August 2015 10:30 By: BlackSwan
MERGE db 12.1.0.2 By: John Watson on Fri, 28 August 2015	2	1317	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	2086	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	1956	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	3669	Thu, 27 August 2015 09:35 By: manubatham20
Query 9i By: glmjoy on Wed, 26 August 2015	4	1639	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	1810	Wed, 26 August 2015 06:20 By: EdStevens
Table partition oracle By: sanodani on Mon, 24 August 2015	23	3537	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	1621	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	2258	Fri, 21 August 2015 10:46 By: tmcallister