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
Help with top query Oracle 11g,Windows 2003, Toad for Oracle 11 By: jxh461 on Fri, 22 March 2013	6	424	Thu, 11 April 2013 17:35 By: jxh461
Rows not in Inner Select Oracle 11.2 By: feroze on Thu, 11 April 2013	2	148	Thu, 11 April 2013 14:14 By: cookiemonster
how to write text at specified posititon in file...... Oracle PL/SQL ,11gR2,Win XP By: shailesh1989 on Thu, 11 April 2013	3	192	Thu, 11 April 2013 11:23 By: Solomon Yakobson
Row level and statement level Oracle 11g By: ashwani0301 on Thu, 11 April 2013	2	177	Thu, 11 April 2013 07:12 By: ashwani0301
verifying database connection from an external java process oracle 11i By: agidatorafaq on Thu, 11 April 2013	5	114	Thu, 11 April 2013 05:23 By: Michel Cadot
Fetch module ,concuurent program parameter name format By: bhawnakaamra on Thu, 11 April 2013	1	123	Thu, 11 April 2013 05:14 By: Michel Cadot
Group by with Substr on a one date colum oracle 9i By: abhijeet.jain on Wed, 10 April 2013	24	584	Thu, 11 April 2013 02:13 By: Littlefoot
error while using cursor oracle 11g By: swapnabpnn on Wed, 10 April 2013	3	266	Wed, 10 April 2013 16:10 By: LKBrwn_DBA
Using greater than, less than in left join Oracle 11 By: urbanmojo on Tue, 09 April 2013	4	457	Wed, 10 April 2013 10:24 By: urbanmojo
SQL oracle10g By: poojamunj on Tue, 09 April 2013	7	333	Wed, 10 April 2013 05:01 By: Michel Cadot
Update table removing first 2 digits from a column Oracle 11g By: apenkov on Wed, 10 April 2013	5	363	Wed, 10 April 2013 03:49 By: apenkov
oracle developer oracle developer 11g By: tahsan007 on Tue, 09 April 2013	3	290	Wed, 10 April 2013 01:26 By: Michel Cadot
regexp_replace multiple replace - at the end of the string Windows 2003, 10g Enterprise Edition Release 10.2.0.4.0 By: rahul1982 on Wed, 10 April 2013	2	367	Wed, 10 April 2013 01:06 By: rahul1982
Using Sequence.NEXTVAL from DUAL versus in INSERT statment By: newbiefm2012 on Mon, 08 April 2013	9	566	Wed, 10 April 2013 00:19 By: Michel Cadot
insert Rupee(currency) symbol oracle,1og,windows By: thelearner on Mon, 08 April 2013	2	291	Tue, 09 April 2013 19:07 By: Barbara Boehmer
Generate command to Rename log file from ASM to non-ASM Oracle 11.2.0.3 on RedHat By: Lucky A on Tue, 09 April 2013	7	191	Tue, 09 April 2013 15:11 By: Lucky A
Outer inner loop PL/SQL TOAD By: bws93222 on Tue, 09 April 2013	12	356	Tue, 09 April 2013 13:14 By: bws93222
Selecting fields containing both text and characters Oracle SQL By: SteveShephard on Tue, 09 April 2013	7	193	Tue, 09 April 2013 10:52 By: SteveShephard
Nested Blocks Logic Question Oracle 11G, Windows XP By: abnk on Tue, 09 April 2013	8	211	Tue, 09 April 2013 09:43 By: Michel Cadot
remove special chars using regular expression Windows -2003, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 By: rahul1982 on Tue, 09 April 2013	4	221	Tue, 09 April 2013 05:55 By: rahul1982
New table creation from different databases. By: ramanaapps on Tue, 09 April 2013	6	186	Tue, 09 April 2013 05:29 By: Michel Cadot
Diff B/w PROCEDURE AND CREATE OR REPLACE PROCEDURE By: ramanaapps on Tue, 09 April 2013	2	116	Tue, 09 April 2013 04:53 By: ramanaapps
How to count rows of partition table oracle 11g, windows By: mei tambunan on Tue, 09 April 2013	3	239	Tue, 09 April 2013 02:27 By: Michel Cadot
Need Code to connect external database Oracle 10g By: vicktorz on Mon, 08 April 2013	4	348	Tue, 09 April 2013 02:19 By: Bill B
Number to Minutes Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Tue, 09 April 2013	8	224	Tue, 09 April 2013 02:08 By: mmohsinaziz
Compare Columns of two table Oracle 10g, windows 7 By: vicktorz on Fri, 05 April 2013	17	790	Tue, 09 April 2013 01:58 By: John Watson
Quarterly data shown oracle 10g By: swapnil_naik on Mon, 08 April 2013	2	228	Mon, 08 April 2013 15:33 By: joy_division
Query to generate SET NEWNAME command Oracle 11.2.0.3 on RedHat Linux By: Lucky A on Sun, 07 April 2013	7	285	Sun, 07 April 2013 19:46 By: Lucky A
[ASK]Handle 0RA 23539 Oracle 11g in windows By: mei tambunan on Sat, 06 April 2013	6	261	Sat, 06 April 2013 09:46 By: mei tambunan
Displaying a single row into column Oracle 10g By: sss111ind on Tue, 26 March 2013	13	792	Sat, 06 April 2013 09:04 By: Michel Cadot
delete rows returned by complex join query 10g, vista By: rzkhan on Fri, 05 April 2013	6	271	Fri, 05 April 2013 07:16 By: cookiemonster
XML file creation oracle 10g,Windows By: pstanand on Thu, 04 April 2013	13	510	Fri, 05 April 2013 03:08 By: Michel Cadot
How to transfer data from non-partitioning table to partitioning table(2 Merged) oracle 11g in windows 7 profesional By: mei tambunan on Thu, 04 April 2013	10	265	Fri, 05 April 2013 01:25 By: Littlefoot
decode function TOAD 8.5.3.4 By: bhawnakaamra on Thu, 04 April 2013	3	360	Fri, 05 April 2013 00:04 By: bhawnakaamra
Please help me to build the query. oracle 10g By: ajaykumarkona on Thu, 28 March 2013	8	608	Wed, 03 April 2013 14:11 By: Bill B
multiple outer join oracle 11g By: miroconnect@yahoo.com on Wed, 03 April 2013	8	312	Wed, 03 April 2013 13:52 By: Michel Cadot
Query result more row return in oracle By: irfankundi786@yahoo.com on Wed, 03 April 2013	5	452	Wed, 03 April 2013 12:54 By: BlackSwan
partition of table - error in materialized view 10g, 10.2.0.4, windows Xp By: ishika_20 on Wed, 03 April 2013	2	375	Wed, 03 April 2013 06:19 By: ishika_20
How to find Currently running jobs? Oracle 9i By: bsm.java on Wed, 03 April 2013	8	559	Wed, 03 April 2013 06:13 By: delna.sexy
ReDefintion Oracle 11G By: elaiyavel on Wed, 03 April 2013	2	285	Wed, 03 April 2013 03:29 By: Michel Cadot