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
	sticky: How to use code tags and make your code easier to read By: Littlefoot on Mon, 05 September 2011	0	6182	Mon, 05 September 2011 02:20 By: Littlefoot
Oracle SQL 1Z0-071 has been moved to Training & Certification by the moderator.
	Should I Clean Up My Collections? 11g By: whdyck on Thu, 17 August 2017	6	117	Thu, 17 August 2017 13:12 By: whdyck
	Need to get the comma separated value By: rajeshsvnr on Mon, 14 August 2017	4	308	Thu, 17 August 2017 12:05 By: rajeshsvnr
	Determine filePath/Name from UTL_FILE.FILE_TYPE? Oracle 11g By: bkuhn on Wed, 16 August 2017	4	184	Thu, 17 August 2017 09:20 By: bkuhn
	Setting Edition // Remote Database Oracle 11.2.0.4 By: suddhasatwa_oracle on Mon, 07 August 2017	12	556	Thu, 17 August 2017 01:39 By: fixxxer
	qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/) By: mlashin on Tue, 08 August 2017	6	423	Wed, 16 August 2017 20:47 By: Barbara Boehmer
	Triggers on editioning views inheriting trigger events from NEWER editions Oracle Database - Enterprise Edition Product Version 12.1.0.2 Linux x86-64 OS Version Red Hat Enterprise 6 By: fixxxer on Wed, 16 August 2017	2	206	Wed, 16 August 2017 10:18 By: fixxxer
	Help with PL SQL query - Analytical Function or group by 12c By: namitanamburi on Tue, 15 August 2017	1	243	Tue, 15 August 2017 14:00 By: Michel Cadot
	MISSING DATE oracle 11g , database 11g, windows 7 By: hisham99 on Tue, 15 August 2017	6	350	Tue, 15 August 2017 07:37 By: John Watson
	member procedure execution oracle 11g By: ynkr999 on Tue, 25 July 2017	3	283	Tue, 15 August 2017 00:16 By: Barbara Boehmer
	Code Help: Inserting Records based on records in another table meeting certain parameters Oracle SQL Developer By: cem616 on Wed, 09 August 2017	6	534	Mon, 14 August 2017 14:07 By: buggleboy007
	Rectify the code By: salam_shah on Tue, 08 August 2017	9	641	Mon, 14 August 2017 06:49 By: Bill B
	help with sql grouping By: ramkumar10 on Thu, 10 August 2017	5	630	Fri, 11 August 2017 01:19 By: Michel Cadot
	extract portion of strings 12c By: m.abdulhaq on Sat, 05 August 2017	6	804	Tue, 08 August 2017 23:09 By: m.abdulhaq
	SQL QUERY oracle 11g 32-bit, windows7 By: shawaj on Fri, 04 August 2017	5	800	Tue, 08 August 2017 21:28 By: shawaj
	LPX-00230: invalid character 0 (U+0000) found in a Name or Nmtoken Oracle 10g By: sss111ind on Mon, 07 August 2017	1	213	Mon, 07 August 2017 08:09 By: BlackSwan
	ORA-29279: SMTP permanent error: Unable to relay Oracle 10g By: sarfarazahmedv on Tue, 16 August 2011	12	41182	Fri, 04 August 2017 19:16 By: BlackSwan
	string operations oracle 11g By: POGAKU_SANTHOSH on Tue, 01 August 2017	9	1082	Wed, 02 August 2017 06:36 By: Bill B
	Regular Expression : Find and Replace Specific String Oracle 11g By: lokimisc on Fri, 28 July 2017	17	1724	Tue, 01 August 2017 13:38 By: Solomon Yakobson
	string aggregation 10g By: praf1981 on Thu, 27 July 2017	2	888	Sun, 30 July 2017 23:42 By: Barbara Boehmer
	Convert Columns to Rows By: SwathiKarre on Tue, 25 July 2017	6	1089	Sun, 30 July 2017 07:48 By: Solomon Yakobson
	Count , Per Week Group by By: azeem87 on Mon, 24 July 2017	5	662	Fri, 28 July 2017 07:31 By: Bill B
	Help with sql code 10 G By: ramkumar10 on Wed, 26 July 2017	4	584	Thu, 27 July 2017 22:45 By: ramkumar10
	String manipulation By: praf1981 on Mon, 10 July 2017	3	402	Thu, 27 July 2017 05:57 By: praf1981
	PLS-00201: identifier 'UTL_MAIL' must be declared 11.2.0.4 By: grpatwari on Wed, 05 July 2017	5	426	Wed, 26 July 2017 08:32 By: Bill B
	How to find out Last Modification Time of a database? Oracle 12c By: muniraj_tomar on Mon, 17 July 2017	13	626	Wed, 26 July 2017 07:03 By: BlackSwan
	Ref cursor results to CSV? By: hmoulding on Fri, 09 June 2006	14	3843	Mon, 24 July 2017 12:42 By: hmoulding
	Weeks, Quarters, and Counts 11g By: jmltinc on Mon, 24 July 2017	5	210	Mon, 24 July 2017 11:22 By: jmltinc
	Mutating error Oracle 12.1 By: arifmd1705 on Sat, 22 July 2017	9	339	Mon, 24 July 2017 08:12 By: Bill B
	foreign key conflict issue Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production. By: orcl2ram on Sat, 22 July 2017	9	321	Mon, 24 July 2017 07:54 By: joy_division
	oracle external table load oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	2	207	Sun, 23 July 2017 19:09 By: Barbara Boehmer
	Solution for ora-00020 maximum number of processes oracle database 8i By: amjad_alahdal on Thu, 20 July 2017	16	512	Fri, 21 July 2017 15:36 By: BlackSwan
	utl_file issue oracle 11g By: POGAKU_SANTHOSH on Fri, 21 July 2017	2	189	Fri, 21 July 2017 15:16 By: Bill B
	Repeat Cursor 12.1.0.2.0 By: SteveShephard on Thu, 20 July 2017	10	300	Fri, 21 July 2017 14:20 By: Barbara Boehmer
	How do we implement NVL() in XSLT? Oracle R12 By: ajayhareesh on Fri, 21 July 2017	4	273	Fri, 21 July 2017 10:38 By: Michel Cadot
	xml question oracle 11g By: deb171100 on Thu, 20 July 2017	4	198	Fri, 21 July 2017 06:34 By: Bill B
	select from two tables By: amjad_alahdal on Thu, 30 April 2015	6	968	Thu, 20 July 2017 05:48 By: amjad_alahdal
	ORA-1555 during pl/sql pocedure PL/SQL Release 11.2.0.3.0 - Production,windows 10 By: priya_t on Wed, 19 July 2017	6	294	Thu, 20 July 2017 03:19 By: cookiemonster
	DBMS_JOB (NEXT_DATE / INTERVAL) Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production By: chat2raj.s on Wed, 19 July 2017	7	309	Wed, 19 July 2017 12:23 By: EdStevens