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
	Announcement: How to use [code] tags and make your code easier to read? Oother people will appreciate it By: Littlefoot on Mon, 05 September 2011	0	21434	Mon, 05 September 2011 02:20 By: Littlefoot
	load data to file 10.2.0.5 By: guddu_12 on Thu, 24 May 2012	5	94	Thu, 24 May 2012 08:52 By: Michel Cadot
	Linking Table challenge - Showing a value only once not for each match (Merged:RL) Oracle 11g By: gogogogo on Wed, 23 May 2012	4	98	Thu, 24 May 2012 08:19 By: rleishman
	How to find nearest integer, where mod returns 0 Oracle 11gR2, 11.2.0.1.0, RHEL 5.4 By: jimit_shaili on Thu, 24 May 2012	13	150	Thu, 24 May 2012 07:15 By: jimit_shaili
	Function to select column values separated by coma Oracle db 11.1.0.7 By: ridhi_sundar on Wed, 23 May 2012	10	190	Thu, 24 May 2012 04:34 By: Michel Cadot
	Double Cursor Oracle 11g, SAS Data Integration Studion By: Patrick D. on Wed, 23 May 2012	3	134	Thu, 24 May 2012 04:33 By: Patrick D.
	A question at Oracle article : Part Number B14223-02 oracle 10G , Win2008 By: JADYCHEN on Thu, 24 May 2012	5	98	Thu, 24 May 2012 03:57 By: Michel Cadot
	problem to decrease size of number datatype column. By: neetesh87 on Thu, 24 May 2012	3	84	Thu, 24 May 2012 03:08 By: Michel Cadot
	MV refresh error Oracle 10g By: ajaykumarkona on Mon, 21 May 2012	17	324	Thu, 24 May 2012 02:28 By: Littlefoot
	How to calculate time difference. By: Numan Khalid on Sun, 10 August 2003	4	612	Thu, 24 May 2012 01:47 By: _jum
	PLS-00382: expression is of wrong type By: scottwmackey on Wed, 23 May 2012	8	204	Thu, 24 May 2012 01:07 By: scottwmackey
	Join running for ever By: maheep72 on Wed, 23 May 2012	1	91	Wed, 23 May 2012 12:17 By: BlackSwan
	pls help in the question (2 Merged) By: vinothjanarthanan on Wed, 23 May 2012	3	137	Wed, 23 May 2012 11:10 By: syakobson
	use laxical parameter in stored procedure 10g By: annu-agi on Wed, 23 May 2012	1	102	Wed, 23 May 2012 06:25 By: cookiemonster
	getting PLS-00201 error. Oracle 10g By: sss111ind on Mon, 21 May 2012	4	168	Wed, 23 May 2012 04:51 By: sss111ind
	Delete - Parent/Child relationship 10.2 By: lott42 on Tue, 22 May 2012	10	172	Tue, 22 May 2012 16:28 By: lott42
	Select In Select Query Help 11g2 By: mistermsk on Tue, 22 May 2012	5	176	Tue, 22 May 2012 13:09 By: Barbara Boehmer
Problem With Java Stored Procedure invoking Windows runtime process has been moved to JDeveloper, Java & XML by the moderator.
	Query Help - "2012-05-21 15:05:31-04" date format By: QuietRiot on Mon, 21 May 2012	4	219	Tue, 22 May 2012 10:25 By: Michel Cadot
	Analyze partition table 11.1.0.6.0 By: muralikri on Tue, 22 May 2012	12	133	Tue, 22 May 2012 08:48 By: BlackSwan
	Need help with Queries ( 1 2) By: supiash on Sat, 19 May 2012	66	675	Tue, 22 May 2012 05:51 By: supiash
	Sysdate problem Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 By: petec on Sun, 20 May 2012	3	204	Mon, 21 May 2012 17:56 By: petec
	SQL Sub Query Problem (4 Merged) By: daveg33 on Mon, 21 May 2012	5	177	Mon, 21 May 2012 17:26 By: Barbara Boehmer
	DML Sentences role in Data Dictionary By: Student-09 on Mon, 21 May 2012	7	165	Mon, 21 May 2012 17:01 By: Barbara Boehmer
	Enforce Comma separated column values Oracle 10g By: ozzy80 on Mon, 21 May 2012	3	105	Mon, 21 May 2012 11:56 By: Michel Cadot
	Implementing Uniqueness Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Sat, 19 May 2012	13	280	Mon, 21 May 2012 10:42 By: manubatham20
	Datapump field length 10.2 By: Rolic on Mon, 21 May 2012	17	180	Mon, 21 May 2012 07:04 By: Michel Cadot
	"!=", "<>" and "^=": why 3 not equals Oracle SQL operators? Difference? (merged) Oracle 11g By: oranooob on Mon, 21 May 2012	5	173	Mon, 21 May 2012 03:50 By: Barbara Boehmer
	Segment entry missing Orac le 10g By: morad_dba on Sun, 20 May 2012	8	213	Mon, 21 May 2012 02:09 By: morad_dba
	problem with CONNECT BY and START WITH clauses By: chaituu on Mon, 21 May 2012	3	121	Mon, 21 May 2012 01:57 By: Michel Cadot
	log file in oracle oracle 10g By: umeshchandraseth on Mon, 21 May 2012	1	110	Mon, 21 May 2012 01:03 By: BlackSwan
	Text mining with Oracle SQL Developer 3.1.07 By: Hedi on Sat, 19 May 2012	2	127	Sat, 19 May 2012 11:03 By: Michel Cadot
	Query Help Oracle 10.2.0.5, AIX 5.3 By: sminnakanti on Fri, 18 May 2012	3	164	Fri, 18 May 2012 14:29 By: sminnakanti
	Please help me on this query Oracle 9i By: ajaykumarkona on Fri, 18 May 2012	7	225	Fri, 18 May 2012 09:56 By: Michel Cadot
	DELETE not working --ORA-00942: table or view does not exist Oracle Database 11g - 11.2.0.2.0 - 64bit- Linux By: anil_mk on Tue, 06 March 2012	15	485	Fri, 18 May 2012 07:57 By: joy_division
	ORA-14257: cannot move partition Oracle Database 11g - 11.2.0.2.0 - 64bit- Linux By: anil_mk on Fri, 18 May 2012	1	141	Fri, 18 May 2012 07:45 By: Michel Cadot
	Create partitioned table with tablespace Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Thu, 17 May 2012	11	183	Fri, 18 May 2012 04:50 By: manubatham20
	Update Query Oracle 10g Release 10.2.0.4.0, Windows By: yuko on Thu, 17 May 2012	8	238	Fri, 18 May 2012 01:07 By: yuko
	process fails due to ORA:-01410 INVALID ROWID error Oracle Database 10g Enterprise Edition Release, 10.2.0.3.0, 64bit By: vigneshbemba on Mon, 14 May 2012	16	409	Fri, 18 May 2012 00:35 By: Michel Cadot
	The use of SYS_GUID() for Primary Key 11.2.0.1.0 By: OraFerro on Tue, 15 May 2012	21	375	Fri, 18 May 2012 00:30 By: Michel Cadot