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
General question about temporary tables Oracle 11GR2, WIN Server 2008 By: OlafCologne on Wed, 24 February 2016	2	1143	Wed, 24 February 2016 06:43 By: Michel Cadot
Re: Return ColumnNames in lowercase. (split from highjacked thread http://www.orafaq.com/forum/t/175479/0/unread/#msg_648450 by bb) By: sss111ind on Tue, 23 February 2016	11	1913	Wed, 24 February 2016 02:52 By: sss111ind
ORA-00001: unique constraint (UNKNOWN.obj#=179690) violated Oracle11G EE By: famegaurav on Thu, 05 February 2015	7	8023	Wed, 24 February 2016 01:00 By: Michel Cadot
Ref cursor ? 4.1.3 sql developer By: M123 on Mon, 22 February 2016	3	1728	Tue, 23 February 2016 17:57 By: M123
quoting string in multiple lines Oracle 11.2.0.3 By: pointers on Fri, 19 February 2016	5	21333	Tue, 23 February 2016 01:58 By: pointers
Join 2 select statements Oracle 11203, Windows By: kar116 on Tue, 23 February 2016	1	1375	Tue, 23 February 2016 00:58 By: Michel Cadot
Indexing advice 11g R2 By: geordibbk on Fri, 19 February 2016	6	1819	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	1780	Mon, 22 February 2016 12:55 By: Michel Cadot
initialize a nested table Oracle11gR2, windows 7 By: live4learn on Sat, 20 February 2016	3	1981	Mon, 22 February 2016 00:57 By: _jum
data view sql+ By: vishnuy on Sun, 21 February 2016	2	1198	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	1918	Sat, 20 February 2016 13:27 By: Michel Cadot
Query 11g By: glmjoy on Fri, 19 February 2016	5	1921	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	2271	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	1677	Fri, 19 February 2016 06:49 By: pointers
Sql Query between String By: sumit.cse07 on Thu, 18 February 2016	3	1288	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	2424	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	13247	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	3622	Thu, 18 February 2016 06:09 By: sss111ind
Minus query with string values (merged) By: Devmunat on Tue, 16 February 2016	3	1741	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	1241	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	2018	Wed, 17 February 2016 15:54 By: Bill B
View tailoring By: geordibbk on Thu, 07 January 2016	7	2284	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	2053	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	2732	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	1385	Mon, 15 February 2016 14:56 By: Bill B
truncating a empty table 11g By: arudesai on Tue, 09 February 2016	19	8859	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	1234	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	1577	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	1259	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	9012	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	1575	Wed, 10 February 2016 15:33 By: BlackSwan
SQL query help Oracle 11g By: nsankineni on Tue, 09 February 2016	3	2057	Wed, 10 February 2016 02:48 By: cookiemonster
Row lock without blocker By: gajini on Tue, 09 February 2016	9	2667	Tue, 09 February 2016 11:59 By: Bill B
Insertion error forms6i, oracle 10g By: snsiddiqui on Mon, 08 February 2016	6	2011	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	2566	Mon, 08 February 2016 08:01 By: Bill B
Data Chucking based on Timewindow By: razasheikh on Sat, 06 February 2016	10	2353	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	3300	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	1645	Sun, 07 February 2016 09:46 By: BlackSwan
help with a query Oracle sql By: zoe2003 on Sun, 07 February 2016	1	1165	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	3800	Sat, 06 February 2016 16:04 By: EdStevens