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
Count number of elements in an array. PLSQL By: vicktorz on Wed, 13 March 2013	6	507	Thu, 14 March 2013 02:30 By: vicktorz
Creating a New Session Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit,OS: XP Window By: chandan.rattan on Thu, 14 March 2013	3	426	Thu, 14 March 2013 01:52 By: Michel Cadot
error when create a view By: man silence on Tue, 12 March 2013	7	448	Wed, 13 March 2013 18:54 By: man silence
how to get the latest record in an embeded select statement Oracle 10g, Windows xp By: aaichah on Tue, 12 March 2013	10	479	Wed, 13 March 2013 15:20 By: Michel Cadot
How to handle a file with UTL_FILE (several merged) Oracle 10g By: vino06cse57 on Mon, 11 March 2013	31	1171	Wed, 13 March 2013 09:02 By: vino06cse57
Running Percentage Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Wed, 13 March 2013	6	340	Wed, 13 March 2013 08:15 By: mmohsinaziz
finding MAX & MIN value from varchar datatype field Oracle 10g, Win7 By: nischalinn on Wed, 13 March 2013	2	323	Wed, 13 March 2013 05:46 By: Michel Cadot
Unexpected Resulted,Trigger Miss firing oracle 10g By: jay_cooldude on Tue, 12 March 2013	6	399	Wed, 13 March 2013 01:59 By: Michel Cadot
How can i get Serial number 10g By: mamalik on Tue, 12 March 2013	7	595	Wed, 13 March 2013 01:57 By: Michel Cadot
Help with reporting Oracle Reports By: m0kchya on Tue, 12 March 2013	4	289	Wed, 13 March 2013 01:53 By: Michel Cadot
UTL_FILE : Getting ORA-29283: invalid file operation error after performing all pre-requisties Oracle 11g By: Lazydba on Tue, 12 March 2013	11	812	Wed, 13 March 2013 00:32 By: BlackSwan
merge - update when id column is matched, but one of others columns not Oracle 11g By: ecivgamer on Tue, 12 March 2013	2	211	Tue, 12 March 2013 14:37 By: ecivgamer
Order By Clause Oracle 11g By: mohanapd on Tue, 12 March 2013	2	234	Tue, 12 March 2013 12:52 By: Michel Cadot
Display tens of millions of data in oracle 11g oracle 11g in windows 7 profesional By: mei tambunan on Tue, 12 March 2013	9	520	Tue, 12 March 2013 05:59 By: Michel Cadot
Reg_Exp Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Mon, 11 March 2013	6	376	Tue, 12 March 2013 04:42 By: mmohsinaziz
seeing the data as values of a table oracle 10g By: sss111ind on Tue, 12 March 2013	17	658	Tue, 12 March 2013 04:32 By: delna.sexy
data recovery HELP NEEDED By: sql_begina on Mon, 11 March 2013	13	611	Tue, 12 March 2013 01:43 By: delna.sexy
Doctors & patients design question By: man silence on Sat, 09 March 2013	4	423	Mon, 11 March 2013 20:52 By: man silence
update previous row based on next row & update duplicate record (merged) 10.2.1.0 By: pratik4891 on Wed, 06 March 2013	10	635	Mon, 11 March 2013 14:13 By: Solomon Yakobson
REGEXP_SUBSTR matching question Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit By: lgiguere on Tue, 15 January 2013	11	1218	Mon, 11 March 2013 13:58 By: lgiguere
Performance Tuning for Oracle tables 11g By: avrillavinge on Mon, 11 March 2013	2	305	Mon, 11 March 2013 08:35 By: Michel Cadot
TRIGGER FIRED BUT IRRELAVENT MESSAGE ORACLE 9i By: jay_cooldude on Fri, 08 March 2013	13	638	Mon, 11 March 2013 07:33 By: cookiemonster
Calculate difference between multiple numbers 11.1.0.6.0 By: RickyC on Thu, 28 February 2013	6	511	Mon, 11 March 2013 07:07 By: RickyC
how can i insert .pdf into oracle database oracle 10.2.0.4 By: x-oracle on Fri, 08 March 2013	24	1029	Mon, 11 March 2013 03:04 By: Michel Cadot
Many information with one row Oracle 9iR2 By: Amine on Sun, 10 March 2013	2	241	Sun, 10 March 2013 14:05 By: Amine
select_minimum_value_from_a_comma_separated_list oracle 11g By: shehpar on Sat, 09 March 2013	2	285	Sat, 09 March 2013 01:54 By: shehpar
Passing values from Oracle Object type to PLSQL Type Oracle 9.2 By: raghx on Fri, 08 March 2013	2	331	Sat, 09 March 2013 00:49 By: Michel Cadot
avoiding different errors oracle 10g,toad, windows By: shankar680 on Fri, 08 March 2013	1	242	Fri, 08 March 2013 13:51 By: Michel Cadot
How can I split a multi-delimited field into several rows, and add new fields? Oracle 11g By: darkgilead on Thu, 07 March 2013	13	592	Fri, 08 March 2013 13:49 By: Michel Cadot
Reset Row Number 10g By: mamalik on Fri, 01 March 2013	7	568	Fri, 08 March 2013 08:48 By: joy_division
Inserting a number of records loaded into the log table Oracle 10g By: vino06cse57 on Fri, 08 March 2013	7	287	Fri, 08 March 2013 07:34 By: Solomon Yakobson
Utl_package Oracle 10g By: vino06cse57 on Thu, 07 March 2013	32	847	Fri, 08 March 2013 05:08 By: vino06cse57
Select INTO By: ramashankar on Fri, 08 March 2013	8	303	Fri, 08 March 2013 04:06 By: ramashankar
DBMS_METADATA.SET_TRANSFORM_PARAM 11g R2 Windows xp By: cvbharathi89 on Fri, 08 March 2013	4	312	Fri, 08 March 2013 01:21 By: cvbharathi89
Error using dbms_lob Oracle 11g By: hishin on Wed, 06 March 2013	9	482	Fri, 08 March 2013 00:34 By: Michel Cadot
help with group by for getting count oracle 11 g By: miroconnect@yahoo.com on Thu, 07 March 2013	2	262	Fri, 08 March 2013 00:28 By: Michel Cadot
showing monthly data Oracle 10g By: sss111ind on Wed, 06 March 2013	20	807	Thu, 07 March 2013 23:51 By: sss111ind
sql query oracle database 11g By: garry143 on Tue, 05 March 2013	11	626	Thu, 07 March 2013 11:32 By: garry143
Checking if month and year is greater or equal to current month By: jensh89 on Thu, 07 March 2013	3	297	Thu, 07 March 2013 10:06 By: Michel Cadot
alias error By: ramashankar on Thu, 07 March 2013	2	269	Thu, 07 March 2013 08:58 By: ramashankar