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 :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Missing Day data Oracle SQl By: razasheikh on Mon, 01 February 2016	6	5404	Tue, 02 February 2016 04:18 By: Michel Cadot
Regarding row lock oracle 12c By: gorants on Tue, 26 January 2016	21	7477	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	9056	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	10124	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	6600	Wed, 27 January 2016 16:16 By: Barbara Boehmer
Determine Missing Route_Seq Numbers Oracle 11g By: stun66 on Tue, 26 January 2016	5	3685	Wed, 27 January 2016 05:55 By: Solomon Yakobson
SQL QUERY HELP By: arifs3738 on Wed, 27 January 2016	2	2523	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	2236	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	4150	Mon, 25 January 2016 07:04 By: quirks
help to make sql query sql By: deepak416 on Sun, 24 January 2016	3	2972	Sun, 24 January 2016 07:54 By: Solomon Yakobson
Interval Partitioning and local index By: menoarc on Sat, 23 January 2016	6	3542	Sun, 24 January 2016 04:47 By: menoarc
INSERT into a Partition By: tony_soprano786 on Fri, 22 January 2016	3	2340	Fri, 22 January 2016 09:32 By: Michel Cadot
separate string by comma Oracle 11g By: mape on Wed, 20 January 2016	4	2847	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	3422	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	2488	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	7411	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	2649	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	29894	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	15566	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	8674	Tue, 19 January 2016 03:11 By: Michel Cadot
CHAR ' ORACLE 6i By: NNAAEE on Thu, 14 January 2016	11	4428	Mon, 18 January 2016 08:38 By: EdStevens
SQL Query Oracle 10g By: swapnil_naik on Mon, 18 January 2016	6	2718	Mon, 18 January 2016 04:24 By: Michel Cadot
ANSI SQL STATEMENTS By: Danny Freeman on Fri, 15 January 2016	3	3709	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	16865	Sat, 16 January 2016 06:56 By: Solomon Yakobson
interview question oracle 10g By: san-deep on Fri, 15 January 2016	5	3194	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	3733	Thu, 14 January 2016 08:53 By: Solomon Yakobson
how to write below procedure By: ram7aj1a0235 on Tue, 12 January 2016	8	4188	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	4670	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	6801	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	5207	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	3517	Mon, 11 January 2016 08:46 By: cookiemonster
Generate unique combinations Oracle 11g By: Xandot on Fri, 08 January 2016	2	2133	Fri, 08 January 2016 08:15 By: Xandot
Case statement for multiple options By: blyzz on Thu, 07 January 2016	3	2529	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	6915	Thu, 07 January 2016 13:21 By: Sam D.
Interesting problem with query Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: javon13 on Wed, 06 January 2016	10	5087	Thu, 07 January 2016 08:13 By: cookiemonster
repeat the previous value to next rows oracle 11g By: guddu_12 on Wed, 06 January 2016	1	2348	Wed, 06 January 2016 12:20 By: Michel Cadot
NVL Function By: johnsid on Tue, 05 January 2016	3	3021	Wed, 06 January 2016 07:23 By: javon13
Query is not running from 11.2.0.3 to 11.2.0.4 11.2.0.4 By: grpatwari on Mon, 04 January 2016	18	7891	Wed, 06 January 2016 03:35 By: cookiemonster
XML parsing error-ORA-06512 oracle 10g By: gobi21 on Tue, 05 January 2016	4	12089	Tue, 05 January 2016 21:50 By: gobi21
Collections- Associative arrays Oracle, 11.2.0.4.0, Windows 7 Professional By: buggleboy007 on Sun, 03 January 2016	14	5020	Mon, 04 January 2016 09:49 By: Michel Cadot