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
Variables sql By: M123 on Thu, 04 February 2016	4	437	Thu, 04 February 2016 19:17 By: M123
change permanently the value of the initialization parameter Oracle By: Nagaram on Thu, 04 February 2016	4	2242	Thu, 04 February 2016 16:30 By: Barbara Boehmer
Comma separated column values matching 10.0.0.1 By: pratik4891 on Thu, 04 February 2016	20	830	Thu, 04 February 2016 16:25 By: Barbara Boehmer
How to use DISTINCT for CLOB data type? Oracle 11g By: Oracle_Walker on Thu, 28 January 2016	4	1094	Thu, 04 February 2016 10:34 By: Oracle_Walker
Updating duplicate records with different data Oracle 11g By: bhush5bhai on Mon, 01 February 2016	8	3752	Tue, 02 February 2016 11:11 By: Solomon Yakobson
Missing Day data Oracle SQl By: razasheikh on Mon, 01 February 2016	6	2763	Tue, 02 February 2016 04:18 By: Michel Cadot
Regarding row lock oracle 12c By: gorants on Tue, 26 January 2016	21	1543	Sun, 31 January 2016 19:21 By: gorants
UTL_FILE Writeing in multiple text files Oracle SQL Developer By: thsankar on Tue, 26 January 2016	21	938	Fri, 29 January 2016 21:49 By: thsankar
How can I pass UserId/Password securely as a parameter using UTL_HTTP Oracle 11G Enterprise 11.2.0.4.0 - 64bit By: kjcook on Tue, 26 January 2016	10	782	Fri, 29 January 2016 16:04 By: Bill B
How to capture particular column from select statement inside a package body in oracle pl sql oracle pl sql By: adfire on Fri, 15 January 2016	13	1086	Wed, 27 January 2016 16:16 By: Barbara Boehmer
Determine Missing Route_Seq Numbers Oracle 11g By: stun66 on Tue, 26 January 2016	5	1130	Wed, 27 January 2016 05:55 By: Solomon Yakobson
SQL QUERY HELP By: arifs3738 on Wed, 27 January 2016	2	1002	Wed, 27 January 2016 03:24 By: John Watson
How to get the first less date than agiven date in sql By: blyzz on Tue, 26 January 2016	2	348	Tue, 26 January 2016 12:04 By: Barbara Boehmer
Corrections with overlapping time frames (SOLVED) Oracle 11 By: quirks on Wed, 20 January 2016	8	808	Mon, 25 January 2016 07:04 By: quirks
help to make sql query sql By: deepak416 on Sun, 24 January 2016	3	633	Sun, 24 January 2016 07:54 By: Solomon Yakobson
Interval Partitioning and local index By: menoarc on Sat, 23 January 2016	6	494	Sun, 24 January 2016 04:47 By: menoarc
INSERT into a Partition By: tony_soprano786 on Fri, 22 January 2016	3	449	Fri, 22 January 2016 09:32 By: Michel Cadot
separate string by comma Oracle 11g By: mape on Wed, 20 January 2016	4	638	Thu, 21 January 2016 16:28 By: Bill B
Unable to pass 1st value into the query Oracle, 11.2.0.4.0, Windows 7 Professional 64 bit By: buggleboy007 on Tue, 19 January 2016	8	554	Wed, 20 January 2016 22:07 By: buggleboy007
How To Get JV/34 as JV/0034 or JV/034 as JV/0034 or JV/0034 as JV/0034 using regular expression By: jainarayan5484 on Wed, 20 January 2016	3	436	Wed, 20 January 2016 09:15 By: Solomon Yakobson
db link between 10g and 12c 10g 12c By: mshrkshl on Tue, 19 January 2016	4	564	Wed, 20 January 2016 04:25 By: Littlefoot
Use cursor output in the IN CLAUSE 11.2.1.0 By: OraFerro on Tue, 19 January 2016	4	449	Tue, 19 January 2016 13:48 By: Barbara Boehmer
ora-12096 Oracle 11.2.0.4, Windows 2008 R2 By: sant_new1 on Mon, 18 January 2016	22	746	Tue, 19 January 2016 13:32 By: sant_new1
How do I find a value anywhere in a Oracle schema ? 12c By: gorants on Mon, 18 January 2016	15	4737	Tue, 19 January 2016 10:08 By: gorants
VARCHAR2 Convert to H:MI:SS tt (merged 2) Windows server 2008r2 By: farrukh786 on Mon, 18 January 2016	28	732	Tue, 19 January 2016 03:11 By: Michel Cadot
CHAR ' ORACLE 6i By: NNAAEE on Thu, 14 January 2016	11	599	Mon, 18 January 2016 08:38 By: EdStevens
SQL Query Oracle 10g By: swapnil_naik on Mon, 18 January 2016	6	386	Mon, 18 January 2016 04:24 By: Michel Cadot
ANSI SQL STATEMENTS By: Danny Freeman on Fri, 15 January 2016	3	652	Sun, 17 January 2016 08:26 By: Solomon Yakobson
How to use minus, union for CLOB datatype column in Oracle? Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: Oracle_Walker on Thu, 14 January 2016	12	951	Sat, 16 January 2016 06:56 By: Solomon Yakobson
interview question oracle 10g By: san-deep on Fri, 15 January 2016	5	645	Fri, 15 January 2016 12:43 By: pablolee
Odd case of removing duplicates within a set. Oracle, 11.2.0.4.0, Windows 7 By: tmcallister on Fri, 08 January 2016	6	724	Thu, 14 January 2016 08:53 By: Solomon Yakobson
how to write below procedure By: ram7aj1a0235 on Tue, 12 January 2016	8	664	Wed, 13 January 2016 04:00 By: pablolee
To Log DBMS in a file from procedure By: rohit_shinez on Thu, 07 January 2016	9	827	Tue, 12 January 2016 12:00 By: Bill B
Not able to create the Materialized view 11.2.0.4 By: grpatwari on Mon, 04 January 2016	7	807	Tue, 12 January 2016 01:00 By: Michel Cadot
Not able to insert with returning option on view with instead of trigger 11g By: saini006 on Mon, 11 January 2016	3	454	Mon, 11 January 2016 22:33 By: Kevin Meade
Pull 20 records for each time Oracle Pl/sql By: itnagaraj on Mon, 11 January 2016	8	550	Mon, 11 January 2016 08:46 By: cookiemonster
calculate working days not beween date ( 1 2) By: shahzad-ul-hasan on Tue, 10 November 2015	67	2524	Fri, 08 January 2016 09:43 By: BlackSwan
Generate unique combinations Oracle 11g By: Xandot on Fri, 08 January 2016	2	381	Fri, 08 January 2016 08:15 By: Xandot
Case statement for multiple options By: blyzz on Thu, 07 January 2016	3	466	Fri, 08 January 2016 02:54 By: cookiemonster
Joining on optional TABLE OF NUMBER parameters Oracle 11G By: Sam D. on Mon, 28 December 2015	17	927	Thu, 07 January 2016 13:21 By: Sam D.