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
PL/SQl for multiple flat file formats By: hariharc on Wed, 30 January 2013	0	923	Wed, 30 January 2013 00:32 By: hariharc
Database link creation Oracle 11g r2 By: sarma.shp on Mon, 28 January 2013	13	665	Tue, 29 January 2013 11:27 By: BlackSwan
Help on creating master and detail relationship Oracle 11g By: ajaykumarkona on Tue, 29 January 2013	1	316	Tue, 29 January 2013 02:30 By: Michel Cadot
Unable to execute the procedure By: rashidlatif on Mon, 28 January 2013	14	613	Tue, 29 January 2013 01:23 By: flyboy
Procedure Working But Not Solving Mutating Table Oracle 11g By: lukedba on Mon, 28 January 2013	6	757	Mon, 28 January 2013 13:06 By: lukedba
Schema populate 11.2.0.3.0 By: rishwinger on Mon, 28 January 2013	13	530	Mon, 28 January 2013 06:02 By: cookiemonster
ult_http Oracle 11g R2 - Windows 7x64 By: limner on Thu, 24 January 2013	11	933	Mon, 28 January 2013 05:34 By: Michel Cadot
ORA-55617: Flashback Archive 11.2.0.3.0 By: rishwinger on Mon, 28 January 2013	1	424	Mon, 28 January 2013 05:32 By: Michel Cadot
BULK INSERT PERFORMANCE ORACLE 10G By: mvrkr44 on Sun, 27 January 2013	4	527	Mon, 28 January 2013 01:36 By: Michel Cadot
Quarter year oracle reports 5.0 By: muqtadeer on Sat, 26 January 2013	3	409	Sat, 26 January 2013 12:36 By: Michel Cadot
DBMS_JOBS failure check Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi By: s4.ora on Sat, 26 January 2013	1	500	Sat, 26 January 2013 03:26 By: Michel Cadot
Fetch records based on 2 status Oracle 10g By: ashagang on Fri, 25 January 2013	4	431	Fri, 25 January 2013 14:58 By: Michel Cadot
External Table for CSV delimited file skipping columns Oracle 11g By: vikram1780 on Thu, 24 January 2013	5	510	Fri, 25 January 2013 14:20 By: Barbara Boehmer
Using Nested Table (merged) Oracle 10g By: vnithya on Wed, 09 January 2013	9	925	Fri, 25 January 2013 07:56 By: Michel Cadot
Sequence creation Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Fri, 25 January 2013	5	336	Fri, 25 January 2013 05:43 By: Michel Cadot
forall update with bulk collect for multiple columns oracle 10g By: rajmighty972 on Fri, 25 January 2013	2	541	Fri, 25 January 2013 05:24 By: rajmighty972
Dynamic %rowtype Oracle 10g By: visitsenthil on Fri, 25 January 2013	2	289	Fri, 25 January 2013 04:54 By: Michel Cadot
how can we create table by using another table with some condition Oracle 10g By: umeshchandraseth on Fri, 25 January 2013	2	255	Fri, 25 January 2013 04:42 By: Michel Cadot
Table Partitioning Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Thu, 24 January 2013	7	547	Fri, 25 January 2013 03:16 By: saipradyumn
Delete even rows of a table By: mr_deb on Wed, 25 October 2006	31	2279	Fri, 25 January 2013 00:52 By: Michel Cadot
Export_Data_From_Table_To_Different_Excel 10 By: tabj on Thu, 24 January 2013	1	261	Thu, 24 January 2013 22:34 By: BlackSwan
Multiple versions of PL/SQL management By: lyangee on Thu, 24 January 2013	3	281	Thu, 24 January 2013 11:07 By: cookiemonster
online shopping catalogue system By: ade2013 on Thu, 24 January 2013	2	418	Thu, 24 January 2013 10:55 By: Michel Cadot
decode using multiple values 11 By: cplusplus1 on Wed, 23 January 2013	4	524	Thu, 24 January 2013 07:56 By: joy_division
taking latest current balance using analytical Query Oracle 10g By: jollyboy on Tue, 22 January 2013	9	428	Thu, 24 January 2013 03:25 By: Michel Cadot
ORA-29278: SMTP transient error: 421 Service not available By: musman on Tue, 06 May 2008	11	7854	Thu, 24 January 2013 02:05 By: Michel Cadot
difference between dates By: anilkln on Wed, 23 January 2013	9	526	Thu, 24 January 2013 01:35 By: Michel Cadot
complex query oracle By: hemagarg5@gmail.com on Thu, 24 January 2013	1	333	Thu, 24 January 2013 01:25 By: Michel Cadot
SQL- Outer join 3 tables Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi, Windows XP By: ao123 on Wed, 23 January 2013	19	722	Wed, 23 January 2013 21:05 By: flyboy
External table query (compare number records in file with external table) Oracle 11g By: scrapjack on Wed, 23 January 2013	5	403	Wed, 23 January 2013 14:09 By: scrapjack
Materialized view Refresh By: swapnalinagle on Thu, 30 June 2011	7	878	Wed, 23 January 2013 08:49 By: Michel Cadot
PL/SQL Anonymous block Oracle 10g By: vnithya on Wed, 23 January 2013	5	552	Wed, 23 January 2013 03:35 By: Michel Cadot
Is it possible to identify/Count records in ref cursor without actually fetching 9i By: anoopmanagoli on Tue, 22 January 2013	7	428	Wed, 23 January 2013 01:35 By: Michel Cadot
moving data to another table oracle 11g By: kamilp on Mon, 21 January 2013	6	433	Tue, 22 January 2013 16:03 By: BlackSwan
simple Shell Script - howto do the same in PL/SQL Database is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 on Solaris. By: oranooob on Tue, 22 January 2013	1	395	Tue, 22 January 2013 12:54 By: Michel Cadot
checking a record exists Oracle 10g By: sss111ind on Tue, 22 January 2013	7	375	Tue, 22 January 2013 09:20 By: sss111ind
Maintaining log table Oracle 11g By: ajaykumarkona on Tue, 22 January 2013	1	284	Tue, 22 January 2013 05:48 By: Michel Cadot
insert mp3 file into BLOB By: Rafeek on Sun, 17 February 2008	29	5592	Tue, 22 January 2013 05:45 By: Michel Cadot
RETRIEVE all the INFORMATION of DEPT ALONG with TWO EMPLOYEES of each DEPARTMENT By: sss111ind on Mon, 21 January 2013	6	301	Tue, 22 January 2013 04:17 By: sss111ind
External Tables (Oracle Loader) Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit,OS: XP Window By: chandan.rattan on Tue, 22 January 2013	3	383	Tue, 22 January 2013 03:32 By: chandan.rattan