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
Calling other procedures from autonomous procedure Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: manubatham20 on Tue, 26 February 2013	8	476	Wed, 27 February 2013 05:02 By: manubatham20
Handle exception Invalid identifier 11.2.0.3.0 By: rishwinger on Wed, 27 February 2013	3	326	Wed, 27 February 2013 02:11 By: rishwinger
Auto generation Number Oracle 10G By: ORA_KRISH on Wed, 27 February 2013	1	195	Wed, 27 February 2013 01:26 By: Michel Cadot
ref cursor By: neetesh87 on Mon, 25 February 2013	7	484	Tue, 26 February 2013 23:55 By: sss111ind
Sequence Trigger Oracle 10 G Version By: rasi_85 on Mon, 25 February 2013	6	612	Tue, 26 February 2013 09:55 By: Michel Cadot
error in creating DBMS_SCHEDULER job Oracle 11g By: ajaykumarkona on Mon, 25 February 2013	5	340	Tue, 26 February 2013 07:29 By: Michel Cadot
ORA-01830: date format picture ends before converting entire input string oracle 10 g By: deepak416 on Tue, 26 February 2013	1	447	Tue, 26 February 2013 07:05 By: cookiemonster
find difference in two schemas oracle 11 g By: miroconnect@yahoo.com on Mon, 25 February 2013	2	362	Tue, 26 February 2013 04:25 By: rishwinger
How we can declare a global Variable in Package Body(Not Spec) Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit,OS: XP Window By: chandan.rattan on Tue, 26 February 2013	11	671	Tue, 26 February 2013 03:08 By: flyboy
Is employee is manager? SQL By: ksiva on Tue, 26 February 2013	2	384	Tue, 26 February 2013 00:39 By: Michel Cadot
DBMS_SQL usages Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: manubatham20 on Mon, 25 February 2013	12	411	Mon, 25 February 2013 13:04 By: manubatham20
Difference between variables declared under Begin and Declare Oracle 10g By: amireee on Sun, 24 February 2013	4	497	Mon, 25 February 2013 01:01 By: Michel Cadot
sql (merged) By: Nirai Raja on Fri, 22 February 2013	7	606	Sun, 24 February 2013 13:23 By: Michel Cadot
Decrease precision or scale error 11g By: ashishpatel1992 on Sun, 24 February 2013	14	407	Sun, 24 February 2013 09:34 By: Michel Cadot
How to Undo a drop table operation? 11g By: ashishpatel1992 on Sun, 24 February 2013	12	373	Sun, 24 February 2013 08:30 By: Michel Cadot
How to check table properties? (desc only shows if it is null) 11g By: ashishpatel1992 on Sun, 24 February 2013	2	282	Sun, 24 February 2013 08:12 By: ashishpatel1992
Need Sql Query By: mvrkr44 on Sat, 23 February 2013	3	346	Sun, 24 February 2013 06:22 By: Solomon Yakobson
Need query By: mvrkr44 on Sat, 23 February 2013	3	260	Sun, 24 February 2013 06:22 By: Michel Cadot
How is naming Integrity Constants helpful? 11g By: ashishpatel1992 on Sun, 24 February 2013	6	305	Sun, 24 February 2013 04:52 By: ashishpatel1992
FIND INVOICE NOS AGAINST BALANCE VALUE Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Fri, 22 February 2013	8	620	Sat, 23 February 2013 01:38 By: Michel Cadot
SQL_QUERY 10g By: tabj on Fri, 22 February 2013	5	524	Fri, 22 February 2013 10:44 By: Michel Cadot
Inserting data using DBLINK Oracle 11g By: ajaykumarkona on Thu, 21 February 2013	16	962	Fri, 22 February 2013 06:13 By: cookiemonster
record event if no rows are returned between two timestamp By: ruchimca1 on Thu, 21 February 2013	7	533	Fri, 22 February 2013 02:41 By: cookiemonster
How to use default value 11.2.0.3.0 By: rishwinger on Thu, 21 February 2013	4	608	Fri, 22 February 2013 02:36 By: cookiemonster
CASE STMT VS DECODE ORACLE 10G By: faijurias@gmail.com on Fri, 22 February 2013	1	423	Fri, 22 February 2013 01:37 By: Michel Cadot
Count data 10.2 By: lott42 on Thu, 21 February 2013	5	457	Thu, 21 February 2013 15:19 By: Michel Cadot
Need equivalent DECODE for CASE statement Oracle8i Enterprise Edition Release 8.1.7.2.0 By: apricot on Thu, 21 February 2013	10	516	Thu, 21 February 2013 10:22 By: Michel Cadot
split long string sql 11g By: mahnazzz on Tue, 19 February 2013	12	1005	Thu, 21 February 2013 10:15 By: Michel Cadot
same sequence number for repeating data oracle 10 By: guddu_12 on Thu, 21 February 2013	12	478	Thu, 21 February 2013 07:57 By: joy_division
Merge with returning Clause 11G By: saipradyumn on Thu, 21 February 2013	3	321	Thu, 21 February 2013 06:48 By: cookiemonster
Splitting the Give string into multiple sub strings Oracle 11g By: saipradyumn on Mon, 18 February 2013	3	543	Thu, 21 February 2013 05:48 By: saipradyumn
Problem moving files after using UTL_FILE package P/SQL, Oracle 8i By: dev_777 on Thu, 21 February 2013	5	371	Thu, 21 February 2013 05:17 By: dev_777
Help me on Basics in PL/SQL By: vasu bhattiprolu on Thu, 21 February 2013	2	302	Thu, 21 February 2013 03:09 By: Michel Cadot
how to get col info from ref cursor oracle 10g,linux,windows By: lzfhope on Wed, 20 February 2013	4	393	Thu, 21 February 2013 01:52 By: lzfhope
Data_Validation_In_Pl/SQL Oracle 10g By: tabj on Tue, 19 February 2013	4	478	Wed, 20 February 2013 21:26 By: xpact83
job runs every 2 minutes, procedure works about 1,5 minutes Oracle 11g By: ecivgamer on Mon, 18 February 2013	4	685	Wed, 20 February 2013 15:28 By: Bill B
oracle pl/sql By: azpl/sql on Mon, 18 February 2013	3	617	Wed, 20 February 2013 10:25 By: Bill B
Removing Leading single quote in excel file PLSQL,Windows XP By: visuora@yahoo.com on Wed, 20 February 2013	6	650	Wed, 20 February 2013 08:39 By: joy_division
Audit Table with Primary keys Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Tue, 19 February 2013	10	860	Wed, 20 February 2013 06:18 By: mmohsinaziz
How to handle NULL while inserting records in a table in PL/SQL? 11.6 By: oraclethebest on Wed, 20 February 2013	4	569	Wed, 20 February 2013 03:34 By: Michel Cadot