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
Query Generate an Error Pls Guide me Where I am Wrong Windows server 2003 By: qanita786 on Mon, 07 January 2013	9	300	Mon, 07 January 2013 01:57 By: Littlefoot
difference between oracle procedure & package By: mvrkr44 on Mon, 07 January 2013	1	431	Mon, 07 January 2013 01:33 By: Michel Cadot
Calculating the difference of timestamps in seconds Oracle 11g, 11.2.0.1.0, Windows Server 2008 By: marcopo on Wed, 02 January 2013	16	1341	Sun, 06 January 2013 09:31 By: marcopo
Please Make Query By: qanita786 on Sat, 05 January 2013	2	387	Sat, 05 January 2013 14:17 By: BlackSwan
Facing issue related to single quote('), in sql query. By: NiteshKumar on Sat, 05 January 2013	4	754	Sat, 05 January 2013 13:40 By: Littlefoot
Check for create table permission By: sanushks on Fri, 04 January 2013	2	724	Sat, 05 January 2013 01:54 By: Michel Cadot
Insert into target table and delete from source Oracle 11g By: ajaykumarkona on Wed, 02 January 2013	2	571	Fri, 04 January 2013 13:14 By: spacebar
Add Range Subpartition to a hash Parition table 11g By: pzlj6x on Wed, 02 January 2013	8	444	Fri, 04 January 2013 13:08 By: pzlj6x
Number conversion Ora 11 By: bella13 on Fri, 04 January 2013	1	257	Fri, 04 January 2013 12:28 By: Michel Cadot
How to add Oracle constraint to below tables By: ravi_oracle_1413 on Fri, 04 January 2013	5	389	Fri, 04 January 2013 10:04 By: Michel Cadot
LISTAGG 11g By: tgreen1 on Thu, 03 January 2013	10	1016	Fri, 04 January 2013 09:34 By: tgreen1
Update query using case when exists 11 By: cplusplus1 on Fri, 04 January 2013	1	444	Fri, 04 January 2013 05:44 By: Michel Cadot
PDF to Oracle table Oracle db 11.2.0.2 By: ridhi_sundar on Wed, 02 January 2013	3	723	Fri, 04 January 2013 02:32 By: Michel Cadot
Need equivalent Decode for this Case 11 By: cplusplus1 on Thu, 03 January 2013	4	370	Thu, 03 January 2013 11:24 By: Michel Cadot
ORA-06508: PL/SQL: could not find program unit being called: oracle By: partha.bhunia on Wed, 02 January 2013	13	1234	Thu, 03 January 2013 09:01 By: BlackSwan
execute immediate vs ref cursor Oracle 10g By: sss111ind on Thu, 03 January 2013	2	460	Thu, 03 January 2013 08:59 By: BlackSwan
DBMS_PARALLEL_EXECUTE help needed. Oracle 11.2g By: napster on Thu, 27 December 2012	11	845	Thu, 03 January 2013 08:43 By: Michel Cadot
Procedure changes oracle 10g By: rajmighty972 on Wed, 02 January 2013	5	403	Thu, 03 January 2013 02:54 By: rajmighty972
how to insert data multiple bases using the multiple database links? windows xp By: nvsr on Wed, 02 January 2013	4	313	Thu, 03 January 2013 01:04 By: Littlefoot
Calculate Working Day Oracle 10G, Windows 2003 By: mmohsinaziz on Tue, 01 January 2013	10	758	Thu, 03 January 2013 01:03 By: mmohsinaziz
Update collections using TABLE operator Oracle 11.2.0.2.0 Solaris By: uman2631 on Wed, 02 January 2013	2	333	Wed, 02 January 2013 12:13 By: Solomon Yakobson
Error handling inside Cursor 10G By: sqlsatya on Mon, 31 December 2012	6	605	Wed, 02 January 2013 08:15 By: sqlsatya
Backward accessing super type's attributes from sub type body in oracle collection (Types) Oracle 10g By: prabakaran.sr on Wed, 02 January 2013	3	345	Wed, 02 January 2013 04:58 By: Michel Cadot
Oracle query error oracle 11g By: JSKOBS on Mon, 31 December 2012	8	413	Mon, 31 December 2012 09:36 By: flyboy
REGEXP 11.1.0.6.0 ( 1 2) By: muralikri on Fri, 11 November 2011	40	5686	Mon, 31 December 2012 08:19 By: ind9
Need a little help in deriving the logic Oracle 10.2.0.4 By: tigsav on Mon, 31 December 2012	1	281	Mon, 31 December 2012 06:42 By: Michel Cadot
How to convert a string into numeric other than to_number 11 By: cplusplus1 on Sun, 30 December 2012	2	420	Sun, 30 December 2012 09:43 By: flyboy
Extract Absent days from the month Oracle 10g By: arif_md2009 on Sat, 29 December 2012	16	870	Sun, 30 December 2012 02:18 By: arif_md2009
Converting number column to date column By: BeefStu on Tue, 25 December 2012	12	785	Sat, 29 December 2012 13:50 By: cookiemonster
ORA-29283: invalid file operation Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: gp185007 on Sat, 29 December 2012	1	499	Sat, 29 December 2012 09:08 By: Michel Cadot
Please help me on how to pass date condition Dynamically. Oracle 11g By: ajaykumarkona on Thu, 27 December 2012	12	632	Sat, 29 December 2012 07:35 By: flyboy
Associative array - no data found By: satajju on Fri, 28 December 2012	3	475	Sat, 29 December 2012 07:33 By: flyboy
How we can run pl/sql procedure in parallel Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: msol25 on Fri, 28 December 2012	11	631	Fri, 28 December 2012 12:10 By: msol25
Join tables on Date with MAX Oracle 10g 10.2.0.4.0 By: isri on Tue, 18 December 2012	6	717	Fri, 28 December 2012 05:08 By: Michel Cadot
Exception query Oracle 10g By: Bagheera on Thu, 27 December 2012	3	388	Fri, 28 December 2012 05:01 By: Michel Cadot
Passing input parameter to a like variable in procedure Oracle 11g By: gentleman777us on Thu, 27 December 2012	3	506	Fri, 28 December 2012 04:09 By: Littlefoot
Refcursor question By: ora1980 on Thu, 27 December 2012	4	377	Thu, 27 December 2012 13:09 By: Michel Cadot
DBMS_CRYPTO hash a BLOB in a union over dblink By: ocdeveloper on Thu, 27 December 2012	1	331	Thu, 27 December 2012 10:31 By: Michel Cadot
Problem with cursor Oracle 9i By: akull on Wed, 26 December 2012	9	405	Thu, 27 December 2012 09:38 By: akull
Document contains too many nodes error message select query search all columns for a string 11 By: cplusplus1 on Thu, 27 December 2012	1	388	Thu, 27 December 2012 07:53 By: Michel Cadot