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	3683	Mon, 05 September 2011 02:20 By: Littlefoot
	How to get rolling week count By: jaggy on Fri, 30 September 2016	6	218	Fri, 30 September 2016 21:52 By: Michel Cadot
	EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data API Error Oracle R12 By: ajayhareesh on Fri, 30 September 2016	6	200	Fri, 30 September 2016 17:06 By: ajayhareesh
	HTTPS Webservices Issue though PL/SQL 12.1.0.2 By: jeganr on Fri, 30 September 2016	3	164	Fri, 30 September 2016 12:55 By: John Watson
Difference between DATETIME and TIMESTANP has been moved to MySQL by the moderator.
	Multiple inline query Oracle 11g By: Xandot on Mon, 26 September 2016	9	532	Wed, 28 September 2016 09:49 By: Michel Cadot
	Distinct Comma Separated Values Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: Xandot on Tue, 05 July 2016	9	935	Wed, 28 September 2016 06:15 By: Xandot
	Fixed Width Flat file via Oracle table 11g,win 7 By: shumail on Thu, 15 September 2016	7	469	Tue, 27 September 2016 15:42 By: Bill B
	Column Data Modification Oracle Database 11g Release 2: 11.2.0.1–11.2.0.4 By: LRB495 on Mon, 26 September 2016	2	210	Tue, 27 September 2016 00:42 By: Michel Cadot
	Date Time problem in sql server Oracle 10g By: sss111ind on Fri, 23 September 2016	13	710	Mon, 26 September 2016 10:07 By: sss111ind
	Nested Query- Result Achieved. Performance improvement ? 10.2.0.1.0 By: bluetooth420 on Thu, 22 September 2016	19	710	Sun, 25 September 2016 12:22 By: BlackSwan
	Count Adult Age in Range Time in 2016 Windows By: blogbeka on Wed, 21 September 2016	11	371	Thu, 22 September 2016 04:22 By: cookiemonster
	Missing Record in running Total 10.2.0 By: bluetooth420 on Sat, 17 September 2016	23	720	Wed, 21 September 2016 02:13 By: bluetooth420
	PL/SQL Function fails without an exception Oracle 12c By: moverdear on Mon, 19 September 2016	3	198	Mon, 19 September 2016 17:27 By: Barbara Boehmer
	Materialised views not refreshing Oracle 11g Release 11.2.0.4.0 By: brown_zzz on Thu, 15 September 2016	2	346	Mon, 19 September 2016 11:47 By: Michel Cadot
	DECLARE a FUNCTION By: derrellgore on Thu, 15 September 2016	6	337	Mon, 19 September 2016 08:59 By: Bill B
	SQL%ROWCOUNT SQL*Plus: Release 12.1.0.1.0, Linux x86 64-bit By: anders_e on Fri, 16 September 2016	4	343	Mon, 19 September 2016 07:27 By: anders_e
	Dynamic SQL : ORA-01006: bind variable does not exist (merged) Oracle R12 By: ajayhareesh on Sun, 18 September 2016	12	313	Sun, 18 September 2016 14:01 By: ajayhareesh
	ORA-01847: day of month must be between 1 and last day of month 01847. 00000 - "day of month must b Oracle By: ROHIN on Fri, 16 September 2016	4	258	Fri, 16 September 2016 10:12 By: BlackSwan
	Enforce blank record Oracle 11G By: OlafCologne on Thu, 15 September 2016	3	210	Thu, 15 September 2016 12:49 By: Michel Cadot
	Global Temporary Tables By: derrellgore on Tue, 13 September 2016	12	531	Thu, 15 September 2016 03:19 By: cookiemonster
	Data grouping Oracle 11g By: srinivas.k2005 on Wed, 14 September 2016	7	432	Thu, 15 September 2016 02:17 By: srinivas.k2005
	Invalid Chars notify differently in different file editors 11G By: harshadsp on Tue, 13 September 2016	6	329	Tue, 13 September 2016 02:46 By: Michel Cadot
	When we get the "Outbound Variable" Error in PLSQL When we get the "Outbound Variable" Error in PLSQL By: msyogi on Mon, 12 September 2016	2	268	Mon, 12 September 2016 19:45 By: BlackSwan
	Group by Multiple Values Oracle 11.2.0.3 Windows By: Duane on Mon, 12 September 2016	1	414	Mon, 12 September 2016 19:08 By: Solomon Yakobson
	Improve nested Query, if possible 10.2.0 By: bluetooth420 on Sun, 11 September 2016	6	438	Mon, 12 September 2016 06:59 By: Flyby
	Problems converting String to data By: RubenDC on Mon, 12 September 2016	5	233	Mon, 12 September 2016 06:43 By: RubenDC
	Unique Constraint With DEFERRABLE INITIALLY DEFERRED NOVALIDATE Oracle 11g 11.2.0.4.0 By: fixxxer on Fri, 09 September 2016	17	677	Sun, 11 September 2016 00:48 By: Michel Cadot
	Format result set of a union DB 10g By: adfnewbie on Mon, 29 August 2016	24	725	Wed, 07 September 2016 03:56 By: sandeep_orafaq
	Select columns based on first record (Header from flat file) Oracle 11g, Windows 2012 R2 By: rahul1982 on Tue, 06 September 2016	20	1024	Wed, 07 September 2016 03:25 By: Michel Cadot
	Unpivot or Connect by Oracle 11.2.0.3 Windows By: Duane on Tue, 06 September 2016	2	171	Tue, 06 September 2016 14:31 By: Michel Cadot
	Selecting the columns Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Tue, 06 September 2016	6	282	Tue, 06 September 2016 08:16 By: BlackSwan
	select statement to split string as per the content and show it oracle 11g, windows By: chinmay89 on Wed, 31 August 2016	5	363	Mon, 05 September 2016 04:20 By: sandeep_orafaq
	Hierarchy view Oracle Database 12c Standard Edition Release 12.1.0.2.0 By: steveshephard87 on Sat, 03 September 2016	2	295	Sat, 03 September 2016 17:52 By: Barbara Boehmer
	Mail Notification By: udaykuditipudi on Fri, 02 September 2016	4	321	Fri, 02 September 2016 07:22 By: EdStevens
	Query to find special alphabets Oracle 11g Release 2, Linux By: anil_mk on Wed, 31 August 2016	5	273	Thu, 01 September 2016 06:33 By: Michel Cadot
	QUERY HELP ORACLE 11G By: DivP on Wed, 31 August 2016	4	278	Wed, 31 August 2016 15:16 By: DivP
	finding previous quarter end date By: lappi on Tue, 30 August 2016	13	515	Wed, 31 August 2016 08:22 By: Michel Cadot
	Help required in SQL Analytic Funciton Oracle 11g 11.2.0.1.0 By: jimit_shaili on Wed, 31 August 2016	2	224	Wed, 31 August 2016 06:55 By: Michel Cadot
	Insert data into SYSTEM partitioned table using DB link Oracle 11g Release 2, Linux By: anil_mk on Tue, 30 August 2016	4	333	Wed, 31 August 2016 05:34 By: anil_mk