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
DECODE Oracle,8.1.7.0.0,Windows 2003 Server By: kumarvk on Thu, 13 March 2014	5	428	Fri, 14 March 2014 08:22 By: Bill B
store and read xml file in an oracle table oracle11g , r2 , unix By: rrnsamy@gmail.com on Fri, 14 March 2014	5	313	Fri, 14 March 2014 03:02 By: balaji123
how to call package using persistant package variable By: prasad2979 on Fri, 07 March 2014	8	517	Thu, 13 March 2014 23:49 By: vslabs
Calc elapsed time within a group of data 10.2 By: lott42 on Thu, 13 March 2014	3	265	Thu, 13 March 2014 15:14 By: lott42
rewrite sql query By: mohan1760 on Mon, 10 March 2014	4	345	Thu, 13 March 2014 13:00 By: Solomon Yakobson
Regular expression Windows 7, Oracle 11g By: rajivn786 on Wed, 12 March 2014	2	174	Thu, 13 March 2014 12:54 By: Solomon Yakobson
Execute Immediate with DDL and Nested table Oracle 11g By: andreaplanet on Wed, 12 March 2014	2	208	Thu, 13 March 2014 12:44 By: Solomon Yakobson
Fatal SSL error calling secure web service from 11g Oracle 11.2 on Windows. By: chris_a on Wed, 09 October 2013	5	807	Thu, 13 March 2014 10:30 By: gusmenp
Retrieve All Columns With Specific Value By: aimy on Mon, 10 March 2014	10	741	Thu, 13 March 2014 07:13 By: Solomon Yakobson
ORA-01460: unimplemented or unreasonable conversion requested Oracle 10g By: sss111ind on Thu, 13 March 2014	14	711	Thu, 13 March 2014 06:43 By: mist598
How to identify special character Oracle 11g By: na.dharma@gmail.com on Thu, 13 March 2014	1	218	Thu, 13 March 2014 06:04 By: Michel Cadot
Oracle 11g R2 Red hat linux 6.4 By: oradba123 on Wed, 12 March 2014	4	344	Thu, 13 March 2014 04:07 By: Michel Cadot
ANY,ALL Operators By: mist598 on Thu, 13 March 2014	2	245	Thu, 13 March 2014 01:20 By: mist598
Oracle SQL 8i By: Hometown1 on Wed, 12 March 2014	10	358	Wed, 12 March 2014 13:12 By: Solomon Yakobson
Error ocurred calling a Web Service using UTL_HTTP Oracle Database, 10g Enterprise Edition Release 10.2.0.4.0, HP-UX By: gusmenp on Thu, 27 June 2013	5	1354	Wed, 12 March 2014 10:48 By: gusmenp
Initialisation of private variable By: ibergo on Tue, 11 March 2014	15	720	Wed, 12 March 2014 04:45 By: ibergo
How to mainatin history of table. By: na.dharma@gmail.com on Tue, 11 March 2014	6	453	Tue, 11 March 2014 09:55 By: John Watson
sending email outsude the domain via database 10g(10.2.0.5) on windows2008 operating system By: arhaan on Tue, 11 March 2014	6	424	Tue, 11 March 2014 07:30 By: Michel Cadot
How to avoid self join. Oracle 11g By: na.dharma@gmail.com on Tue, 11 March 2014	3	366	Tue, 11 March 2014 07:29 By: Michel Cadot
partition on oracle big size tables ? oracle 11g/r2/unix By: balaji123 on Fri, 07 March 2014	4	329	Tue, 11 March 2014 04:04 By: vslabs
How I can increase size of message UTL_MAIL I need to send more than 10,000 characters 10g(10.2.0.5) on windows2008 By: arhaan on Sun, 09 March 2014	5	428	Tue, 11 March 2014 03:43 By: vslabs
Excute procedure By: man silence on Mon, 10 March 2014	4	269	Mon, 10 March 2014 19:58 By: man silence
01843. 00000 - "not a valid month" sql developer, 11g By: meeplsql on Mon, 10 March 2014	13	577	Mon, 10 March 2014 18:11 By: Solomon Yakobson
Generating Random numbers query Oracle 11.2.0.3, Linux By: sspn2010 on Mon, 10 March 2014	4	328	Mon, 10 March 2014 15:15 By: sspn2010
clarification about selectivity Oracle Database 11.2.0.2.0, Windows XP SP3 By: Roger22 on Sun, 09 March 2014	4	312	Mon, 10 March 2014 03:54 By: Roger22
user parameters Oracle 10g By: m.abdulhaq on Thu, 06 March 2014	6	423	Sat, 08 March 2014 11:35 By: m.abdulhaq
Want to get first day of last month 11g By: cplusplus1 on Fri, 07 March 2014	3	276	Fri, 07 March 2014 14:39 By: John Watson
create new record from LAST record with SQL Oracle Database 11g By: oralover2006 on Thu, 06 March 2014	6	391	Fri, 07 March 2014 07:46 By: Michel Cadot
Simple Question By: Crimzon on Fri, 07 March 2014	4	199	Fri, 07 March 2014 06:00 By: Michel Cadot
unit calculation Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003 By: hissam78 on Thu, 06 March 2014	3	376	Fri, 07 March 2014 01:16 By: hissam78
Validate data Oracle 10g By: m.abdulhaq on Tue, 25 February 2014	9	592	Thu, 06 March 2014 20:44 By: m.abdulhaq
how to remove redundant data By: evivek on Thu, 06 March 2014	1	202	Thu, 06 March 2014 14:53 By: BlackSwan
Varchar2 Length By: OraFaq13 on Wed, 05 March 2014	3	295	Thu, 06 March 2014 11:46 By: OraFaq13
Delete thousends of tables per script (without undo) Unix, Oracle 9.x By: forumwurm on Thu, 06 March 2014	16	942	Thu, 06 March 2014 07:19 By: Solomon Yakobson
Need to retrieve records by getting columns from all_tab_columns By: HemaV on Thu, 06 March 2014	4	336	Thu, 06 March 2014 06:50 By: Michel Cadot
Sending UTL_SMTP mail with jpg picture as header inside an e-mail 11.2.0.3.0 By: sivakumar121 on Mon, 07 October 2013	12	1400	Thu, 06 March 2014 04:35 By: vslabs
ALL condition Oracle 8.1.7.0.0, Windows 2004 By: kumarvk on Tue, 04 March 2014	15	685	Thu, 06 March 2014 01:55 By: kumarvk
Sort data output to excel (owa_util) from 2 cursor By: aryanna on Wed, 05 March 2014	1	134	Wed, 05 March 2014 20:52 By: BlackSwan
PlSql open read cell in excel file!! Forms [32 Bit] Version 9.0.2.9.0 , oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), window , IE 8 By: meteo on Wed, 05 March 2014	8	479	Wed, 05 March 2014 15:14 By: meteo
SDO_GTYPE count and group by based on tables in all_tab_cols? By: psnepvangers on Tue, 04 March 2014	4	287	Wed, 05 March 2014 04:06 By: Michel Cadot