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? Other people will appreciate it By: Littlefoot on Mon, 05 September 2011	0	29973	Mon, 05 September 2011 02:20 By: Littlefoot
	Order by in Date Column Oracle 116 By: feroze on Mon, 20 May 2013	2	25	Mon, 20 May 2013 14:39 By: feroze
	Retrieve view definiton Oracle 9.2.0.8, Win2003 server By: Amine on Mon, 20 May 2013	22	147	Mon, 20 May 2013 14:10 By: Michel Cadot
	Tablespace Monitoring scrip oracle 10g By: x-oracle on Mon, 20 May 2013	2	72	Mon, 20 May 2013 09:03 By: BlackSwan
	Please help me to implement this. Oracle 11g By: ajaykumarkona on Mon, 20 May 2013	1	62	Mon, 20 May 2013 08:03 By: Michel Cadot
	PL/SQL function with calling java class oracle 11g r2 By: Maslakos on Mon, 20 May 2013	1	49	Mon, 20 May 2013 07:59 By: Michel Cadot
error regarding oracle connection has been moved to Windows by the moderator.
	Join in Insert By: Taha on Mon, 20 May 2013	2	74	Mon, 20 May 2013 07:09 By: Solomon Yakobson
	Understanding Primary Key/Composite Key By: Taha on Fri, 17 May 2013	12	174	Mon, 20 May 2013 06:55 By: Taha
	Truncate Master Table Issue General - All By: Wah_has on Fri, 17 May 2013	15	655	Mon, 20 May 2013 03:46 By: Michel Cadot
update record has been moved to Forms by the moderator.
	SQL Query Help PL/SQL By: jweingarth1 on Fri, 17 May 2013	3	549	Fri, 17 May 2013 12:06 By: jweingarth1
	VARRAY Issue Oracle Database 11g 11.2.0.2.0 - 64bit, Unix By: sap_arul on Wed, 15 May 2013	12	442	Fri, 17 May 2013 08:18 By: mnitu
	Need help on SQL join. Oracle 11gR2 By: gokul_ifs on Tue, 14 May 2013	8	460	Fri, 17 May 2013 07:11 By: Kevin Meade
	Ref cursor use Oracle 11g By: ajaykumarkona on Fri, 17 May 2013	1	193	Fri, 17 May 2013 05:36 By: Michel Cadot
	REPLACE not replacing By: scottwmackey on Thu, 16 May 2013	5	337	Fri, 17 May 2013 00:59 By: Michel Cadot
	DBLINK, DBMS_AQADM, STOP/START QUEUE Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production By: johnaparker on Thu, 16 May 2013	2	195	Thu, 16 May 2013 14:54 By: johnaparker
	How to use window functions in where clause without inline view By: vikram1780 on Thu, 16 May 2013	1	181	Thu, 16 May 2013 13:37 By: Michel Cadot
	Please provide real time scenario for when we use object type in PL/SQL block Oracle 11g By: ajaykumarkona on Thu, 16 May 2013	1	245	Thu, 16 May 2013 07:03 By: Michel Cadot
	Want to display the data from two tables in SQL 11g R2.0 By: srirams007 on Mon, 13 May 2013	13	848	Thu, 16 May 2013 05:12 By: srirams007
	substr of clob oracle database 11g By: mahnazzz on Tue, 14 May 2013	11	469	Wed, 15 May 2013 21:52 By: mahnazzz
	Help in SQL oracle 11g By: rocky_007 on Sat, 11 May 2013	15	1134	Wed, 15 May 2013 14:22 By: pointers
	DDL Trigger not working Oracle 11.1.0.7 By: deepa_balu on Tue, 14 May 2013	2	224	Wed, 15 May 2013 13:38 By: LKBrwn_DBA
	Funzione Sha-256 By: iperoto on Wed, 15 May 2013	1	217	Wed, 15 May 2013 10:46 By: Michel Cadot
	BST timezone query error By: HemaV on Wed, 15 May 2013	4	181	Wed, 15 May 2013 10:36 By: Michel Cadot
	Using Bind Variable 10G By: yuvraaj on Tue, 14 May 2013	2	223	Wed, 15 May 2013 03:22 By: sss111ind
	ERROR : ORA-06512: at "NECDEMO.GETUESLIDREGTIME", line 25 ORACLE10 g By: deepak416 on Tue, 14 May 2013	12	368	Wed, 15 May 2013 02:37 By: cookiemonster
	PL/SQL: numeric or value error(How to use date as an date as input parameter) oracle 9i By: ashwanth77 on Mon, 13 May 2013	3	530	Wed, 15 May 2013 01:47 By: Michel Cadot
	utl_file error oracle 9i By: umesh seth on Tue, 14 May 2013	8	184	Wed, 15 May 2013 01:39 By: Michel Cadot
	Query for below scenario using analytical functions By: vikram1780 on Tue, 14 May 2013	4	176	Wed, 15 May 2013 00:47 By: Littlefoot
	How to find table name and column name Oracle 11.2.0.3.0 , Linux By: suhasdba on Tue, 14 May 2013	3	343	Tue, 14 May 2013 11:14 By: andrew again
	SQL Update statement for OLTP table ORACLE 11G By: realspirituals on Tue, 14 May 2013	4	341	Tue, 14 May 2013 09:02 By: realspirituals
	convert time part into second oracle 10g r2 By: guddu_12 on Fri, 10 May 2013	14	650	Tue, 14 May 2013 05:26 By: Solomon Yakobson
	SQL Logic 11.2.0.2.0 - 64 bit Production By: sulabhagra on Mon, 13 May 2013	2	441	Tue, 14 May 2013 01:49 By: rajiv.v
	Error in Execute Immediate Oracle 10G By: gurusuryas on Fri, 10 May 2013	4	399	Mon, 13 May 2013 10:38 By: pointers
	Help required for .dat file generated Oracle 11g,unix By: rajiv.v on Mon, 13 May 2013	14	382	Mon, 13 May 2013 07:58 By: Roachcoach
	What happens in Background Oracle 10g By: sss111ind on Mon, 13 May 2013	1	296	Mon, 13 May 2013 07:00 By: Michel Cadot
	SQL HELP 10.1.0.3.0 By: yuvraaj on Sun, 12 May 2013	5	694	Sun, 12 May 2013 10:56 By: Michel Cadot
	Query help - Alpha characters Oracle 10 g By: babhuko on Sat, 11 May 2013	1	359	Sat, 11 May 2013 05:47 By: dariyoosh
	Continuos job Oracle 11 By: webluca on Fri, 10 May 2013	3	398	Sat, 11 May 2013 01:06 By: Michel Cadot