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
Create Gap in Series Oracle 10G, Windows 2003 By: mmohsinaziz on Wed, 16 January 2013	15	650	Thu, 17 January 2013 00:51 By: Michel Cadot
Total Recors Count Calculation 10.2.0.4 By: tigsav on Mon, 14 January 2013	8	570	Wed, 16 January 2013 22:57 By: tigsav
need to find out db name for the indexes Oracle 11g By: ajdba on Tue, 15 January 2013	11	457	Wed, 16 January 2013 13:59 By: Michel Cadot
Query to find relevant Table name Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit,OS: XP Window By: chandan.rattan on Wed, 16 January 2013	10	786	Wed, 16 January 2013 08:37 By: Michel Cadot
Sql for previous day/ day before previous day Oracle, 8.1.7.0.0, Windows Server 2007. By: kumarvk on Tue, 15 January 2013	15	732	Wed, 16 January 2013 01:27 By: Michel Cadot
Problem with performance oracle 11g By: aditya_4136 on Tue, 15 January 2013	4	445	Wed, 16 January 2013 00:23 By: Michel Cadot
XML : Union of 2 Select queries By: rtutus on Tue, 15 January 2013	4	472	Wed, 16 January 2013 00:18 By: Michel Cadot
Facing problem with a Query Oracle 10g By: akull on Tue, 15 January 2013	3	361	Tue, 15 January 2013 15:44 By: joy_division
Native Dynamic Sql Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: sgollapudi on Tue, 15 January 2013	3	272	Tue, 15 January 2013 08:11 By: Michel Cadot
dates question By: ora1980 on Mon, 14 January 2013	16	1004	Tue, 15 January 2013 06:38 By: cookiemonster
how to convert varchar2 to number By: anniepeteroracle on Tue, 15 January 2013	9	560	Tue, 15 January 2013 06:37 By: Solomon Yakobson
update statement help oracle 11g By: swas_recall on Mon, 14 January 2013	1	428	Tue, 15 January 2013 01:06 By: Michel Cadot
Binary tree in Pl/sql By: suni786 on Mon, 14 January 2013	4	490	Mon, 14 January 2013 22:02 By: BlackSwan
Bulk collect and for loop iteration error Oracle 11g By: swas_recall on Sat, 12 January 2013	5	739	Mon, 14 January 2013 16:40 By: swas_recall
can we tune this query without creating any objects like indexes etc. Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: msol25 on Mon, 14 January 2013	11	595	Mon, 14 January 2013 14:04 By: xtender
how to handle null in date time By: anniepeteroracle on Sun, 13 January 2013	9	600	Mon, 14 January 2013 01:59 By: Michel Cadot
Your kindly help in this query (pivot) Oracle 8.1.7.0.0, Wuindos 2007 By: kumarvk on Sun, 13 January 2013	2	464	Mon, 14 January 2013 01:09 By: Michel Cadot
Problem with comparing collections By: annaBaum on Sat, 12 January 2013	2	457	Sun, 13 January 2013 08:40 By: Solomon Yakobson
How to find tables which does not have specific columns Oracle 11g By: gentleman777us on Fri, 11 January 2013	8	768	Sat, 12 January 2013 14:28 By: Michel Cadot
calling a if block based on parameter Oracle 10g By: sss111ind on Fri, 11 January 2013	7	578	Sat, 12 January 2013 10:20 By: Michel Cadot
Import excel file to table Oracle 10g By: arif_md2009 on Thu, 10 January 2013	8	1221	Sat, 12 January 2013 06:20 By: arif_md2009
Adding an IF Statement to a Trigger? Oracle SQL Developer By: deadanyway on Tue, 08 January 2013	4	498	Fri, 11 January 2013 14:44 By: Michel Cadot
UTL_RAW.CAST_TO_NUMBER PL/SQL: numeric or value error Oracle 10G windows By: skumari on Thu, 03 January 2013	12	914	Fri, 11 January 2013 14:04 By: Michel Cadot
Error "ORA-00904" while using subquery. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: Manoj.Gupta.91 on Tue, 08 January 2013	8	861	Fri, 11 January 2013 05:09 By: Michel Cadot
array value in single quote By: ora1980 on Wed, 09 January 2013	3	466	Thu, 10 January 2013 15:31 By: xtender
Multiple Values in Column Oracle 11gR2 By: goody on Thu, 10 January 2013	5	571	Thu, 10 January 2013 12:45 By: goody
Index usage 10g By: saipradyumn on Thu, 10 January 2013	3	388	Thu, 10 January 2013 11:46 By: Solomon Yakobson
Going through record set in oracle and doing calculations Oracle By: danuxz on Thu, 10 January 2013	7	508	Thu, 10 January 2013 08:04 By: Michel Cadot
Extracting part of a string By: spandey on Wed, 09 January 2013	24	814	Thu, 10 January 2013 07:56 By: Michel Cadot
How can i use Substr to get required result Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: mamalik on Mon, 07 January 2013	9	678	Thu, 10 January 2013 07:11 By: sss111ind
Generic application error oracle 10g By: patneel on Thu, 10 January 2013	5	589	Thu, 10 January 2013 04:17 By: Michel Cadot
Filter Special Characters By: Thriller on Tue, 08 January 2013	9	797	Thu, 10 January 2013 01:34 By: Michel Cadot
SQL%ROWCOUNT USing in INSERT or update trigger Oracle 10G windows By: skumari on Wed, 09 January 2013	2	878	Thu, 10 January 2013 01:32 By: Michel Cadot
Query help 11.0.1 By: deepa_balu on Wed, 09 January 2013	4	469	Thu, 10 January 2013 01:18 By: Littlefoot
Delete records from child and parent table [merged 2 by jd] Oracle 11g By: ajaykumarkona on Wed, 02 January 2013	21	1267	Thu, 10 January 2013 00:00 By: Littlefoot
Extract date from string Oracle 10g By: arif_md2009 on Tue, 08 January 2013	15	756	Wed, 09 January 2013 23:22 By: delna.sexy
How to Export Package Body using Spool Command Oracle 9i, SQLPLUS By: bsm.java on Tue, 08 January 2013	7	944	Wed, 09 January 2013 21:07 By: bsm.java
query fine tune Oracle Database 10g Release 10.2.0.1.0 By: Shaam on Mon, 07 January 2013	8	554	Wed, 09 January 2013 04:14 By: Shaam
Max Length for a column Oracle11 By: bella13 on Tue, 08 January 2013	1	359	Tue, 08 January 2013 09:01 By: BlackSwan
why does SELECT DISTINCT return different rows when used with ORDER BY? 11g By: horicel on Fri, 04 January 2013	11	914	Tue, 08 January 2013 07:18 By: cookiemonster