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
Join 2 select statements Oracle 11203, Windows By: kar116 on Tue, 23 February 2016	1	2189	Tue, 23 February 2016 00:58 By: Michel Cadot
Indexing advice 11g R2 By: geordibbk on Fri, 19 February 2016	6	3214	Mon, 22 February 2016 13:10 By: Bill B
How to use LAG function in oracle pl sql until non zero value is reached? oracle pl sql By: adfire on Sat, 20 February 2016	4	2816	Mon, 22 February 2016 12:55 By: Michel Cadot
initialize a nested table Oracle11gR2, windows 7 By: live4learn on Sat, 20 February 2016	3	3084	Mon, 22 February 2016 00:57 By: _jum
data view sql+ By: vishnuy on Sun, 21 February 2016	2	2029	Sun, 21 February 2016 14:04 By: cookiemonster
filtering in a table by ignoring the records those are unnecessary anymore oracle sql developer 4.1.3.20 By: gujarati on Sat, 20 February 2016	6	3400	Sat, 20 February 2016 13:27 By: Michel Cadot
Query 11g By: glmjoy on Fri, 19 February 2016	5	3031	Sat, 20 February 2016 06:32 By: Solomon Yakobson
Oracle Dates query ORACLE, 12.1.0.2.0, WINDOWS 10 By: anil_mk on Fri, 19 February 2016	12	4325	Fri, 19 February 2016 11:54 By: Michel Cadot
Access variables from different script Oracle 11.2.0.2 By: pointers on Fri, 19 February 2016	2	2534	Fri, 19 February 2016 06:49 By: pointers
Sql Query between String By: sumit.cse07 on Thu, 18 February 2016	3	2173	Thu, 18 February 2016 11:04 By: Michel Cadot
Retrieve specified characters from LONG datatype Oracle 11.2.0.4, Windows x64 By: MurraySobol on Tue, 16 February 2016	4	3499	Thu, 18 February 2016 09:52 By: Michel Cadot
update using with statement Oracle 11.2 on Windows 8.1 By: fhsmagna on Tue, 09 February 2016	8	16146	Thu, 18 February 2016 07:48 By: gazzag
Scheduling job at 6 am and 7.30 pm Oracle 10g By: sss111ind on Wed, 17 February 2016	7	5417	Thu, 18 February 2016 06:09 By: sss111ind
Minus query with string values (merged) By: Devmunat on Tue, 16 February 2016	3	2801	Thu, 18 February 2016 02:11 By: Devmunat
unrelated procedure goes invalid Oracle 11.2.0.2.0, Solaris By: uman2631 on Wed, 17 February 2016	1	2092	Wed, 17 February 2016 16:06 By: BlackSwan
query start_date and end_Date windows Server 2008 r2 By: Dips99 on Sun, 14 February 2016	6	3418	Wed, 17 February 2016 15:54 By: Bill B
View tailoring By: geordibbk on Thu, 07 January 2016	7	3643	Wed, 17 February 2016 15:39 By: Bill B
Getting Desire Data According to the interval... Oracle 11g, Windows 2008 R2.... By: Dips99 on Tue, 16 February 2016	5	3304	Wed, 17 February 2016 03:05 By: Michel Cadot
using index and cursor 4.1.3 sql developer By: M123 on Mon, 15 February 2016	11	4678	Wed, 17 February 2016 02:12 By: JNagtzaam
Queries for User and Password Policy Oracle DB 11g By: fanigadu20 on Mon, 15 February 2016	3	2500	Mon, 15 February 2016 14:56 By: Bill B
truncating a empty table 11g By: arudesai on Tue, 09 February 2016	19	12274	Mon, 15 February 2016 02:07 By: Roachcoach
What is the switching context with FORALL? Oracle 11gr2 By: Ikebukuro on Sun, 14 February 2016	1	2081	Sun, 14 February 2016 11:08 By: BlackSwan
Can any one help to remove duplicate rows in a table 11.1.0.7 By: kerneltraining on Thu, 11 February 2016	3	2539	Fri, 12 February 2016 07:22 By: Bill B
Materialised view refresh on commit Oracle 10.2.0.4.0 By: brown_zzz on Thu, 11 February 2016	1	1889	Thu, 11 February 2016 07:48 By: John Watson
using case when ..need suggestion 4.1.3 sql developer By: M123 on Tue, 09 February 2016	26	13239	Wed, 10 February 2016 17:23 By: M123
Not Exists vs Left Outer Join with NULL Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: manubatham20 on Wed, 10 February 2016	1	2245	Wed, 10 February 2016 15:33 By: BlackSwan
SQL query help Oracle 11g By: nsankineni on Tue, 09 February 2016	3	3119	Wed, 10 February 2016 02:48 By: cookiemonster
Row lock without blocker By: gajini on Tue, 09 February 2016	9	4517	Tue, 09 February 2016 11:59 By: Bill B
Insertion error forms6i, oracle 10g By: snsiddiqui on Mon, 08 February 2016	6	3366	Tue, 09 February 2016 02:40 By: Michel Cadot
wrong argument passed any suggestion 4.1.3 sql developer By: M123 on Sat, 06 February 2016	9	4346	Mon, 08 February 2016 08:01 By: Bill B
Data Chucking based on Timewindow By: razasheikh on Sat, 06 February 2016	10	4043	Mon, 08 February 2016 04:09 By: razasheikh
Triggers based Q....ion 4.1.3 sql developer By: M123 on Fri, 05 February 2016	16	5458	Sun, 07 February 2016 19:31 By: EdStevens
diffrence between stored procedure and package preocdures oracle plsql By: kasi7890 on Sun, 07 February 2016	4	2570	Sun, 07 February 2016 09:46 By: BlackSwan
help with a query Oracle sql By: zoe2003 on Sun, 07 February 2016	1	1802	Sun, 07 February 2016 08:34 By: John Watson
Need to convert into date for differernt kind of formates Oracle 11g By: saipradyumn on Mon, 25 January 2016	13	5953	Sat, 06 February 2016 16:04 By: EdStevens
Variables sql By: M123 on Thu, 04 February 2016	4	2684	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	5585	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	6189	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	8150	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	6760	Tue, 02 February 2016 11:11 By: Solomon Yakobson