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
Grouping Query Oracle 11g By: sasisan09 on Thu, 09 April 2015	5	3802	Wed, 09 March 2016 14:04 By: Solomon Yakobson
Understanding locking 12c By: gorants on Sun, 06 March 2016	18	6966	Wed, 09 March 2016 11:55 By: Michel Cadot
Outer query Oracle11g By: ssyr22 on Wed, 09 March 2016	8	3348	Wed, 09 March 2016 10:57 By: gazzag
dependency question By: desmond30 on Wed, 09 March 2016	1	1799	Wed, 09 March 2016 10:43 By: BlackSwan
UTL_FILE Oracle 10g By: mano11022 on Wed, 09 March 2016	1	1857	Wed, 09 March 2016 03:03 By: John Watson
MultiSet Operations on PL/SQL Tables Oracle 10g2, Linux By: mjm22 on Fri, 04 March 2016	5	3557	Tue, 08 March 2016 10:29 By: mjm22
Oracle SQL 11G Express Edition By: mcdinesh.200@gmail.com on Fri, 04 March 2016	4	2683	Tue, 08 March 2016 07:48 By: Bill B
row to column plsql By: poppop on Sun, 06 March 2016	8	3818	Mon, 07 March 2016 16:21 By: Bill B
Issue with Sys_context Oracle 11g, windows By: Vijay55 on Mon, 07 March 2016	14	4966	Mon, 07 March 2016 16:10 By: Bill B
How to use function to extract 1 or 2 digit number from a string By: blyzz on Fri, 04 March 2016	4	4005	Mon, 07 March 2016 16:07 By: Bill B
Compile an object by oracle command for first time Oracle 11g, windows By: Vijay55 on Fri, 04 March 2016	4	2832	Fri, 04 March 2016 08:18 By: cookiemonster
Response in JSON format Oracle , 12C, windowns By: sunilreddy on Thu, 03 March 2016	3	6887	Thu, 03 March 2016 06:24 By: BlackSwan
Print 1 .. 100 numbers using Dual table in SQL statement Any Oracle Database version By: 9390512774 on Fri, 19 February 2016	3	2905	Thu, 03 March 2016 06:11 By: Michel Cadot
v$session Oracle Database 12c 12.1.0.2.0 - 64bit By: brown_zzz on Wed, 02 March 2016	4	4994	Thu, 03 March 2016 06:10 By: Michel Cadot
Too many results By: pretoriaan1971 on Thu, 03 March 2016	1	1938	Thu, 03 March 2016 04:48 By: Michel Cadot
end-of-file on communication channel 11.2.0.1.0 By: pointers on Thu, 03 March 2016	1	1998	Thu, 03 March 2016 02:12 By: Michel Cadot
ORA-02292: integrity constraint error oracle 12c By: gorants on Wed, 02 March 2016	2	2351	Wed, 02 March 2016 21:04 By: Barbara Boehmer
"ORA-01722: invalid number" errors after upgrade 12c Oracle Database 12c (12.1.0.2.0) By: brown_zzz on Wed, 24 February 2016	10	7855	Tue, 01 March 2016 11:15 By: Solomon Yakobson
Select only One Case results Oralcle SQL By: vradhak7 on Mon, 29 February 2016	2	2352	Mon, 29 February 2016 09:05 By: Michel Cadot
Account Lock ~ OS user 12c By: deepakdot on Tue, 23 February 2016	8	3580	Mon, 29 February 2016 07:14 By: deepakdot
Not exists with union query-Help Oracle 11G By: Ratika on Mon, 22 February 2016	14	5424	Mon, 29 February 2016 05:37 By: Michel Cadot
html character to unicode 11g By: mshrkshl on Mon, 29 February 2016	2	2433	Mon, 29 February 2016 03:43 By: mshrkshl
Finding the source of the Company By: hypesslearner on Sat, 27 February 2016	11	5333	Mon, 29 February 2016 00:04 By: Littlefoot
String Printing by PL/SQL code? 10g By: P1Oracle on Sat, 27 February 2016	6	3556	Sat, 27 February 2016 14:35 By: Michel Cadot
Volume Apportioned to right volumen bands Oracle 11g By: razasheikh on Thu, 25 February 2016	6	3635	Sat, 27 February 2016 12:31 By: BlackSwan
character string buffer too small error in function oracle 10g,windows 8 By: amar.podaralla@gmail.com on Sat, 27 February 2016	6	4790	Sat, 27 February 2016 09:39 By: BlackSwan
Setting LIMIT value while using Bulk Collect Oracle 11gR2 By: raj_te on Thu, 25 February 2016	6	3338	Fri, 26 February 2016 03:49 By: cookiemonster
retrieve first changed row By: suji6281 on Mon, 15 February 2016	35	9831	Fri, 26 February 2016 01:48 By: varlamovvp
composite data type 4.1.3 sql developer By: M123 on Thu, 25 February 2016	7	4123	Fri, 26 February 2016 01:11 By: Michel Cadot
Query to find all records with either same value or null value By: ranugupta3 on Thu, 25 February 2016	5	2987	Thu, 25 February 2016 08:36 By: varlamovvp
update statement using from clause 11.2.0.4, Windows 64-bit By: MurraySobol on Thu, 18 February 2016	14	5333	Thu, 25 February 2016 04:31 By: varlamovvp
External table error By: techgirl123 on Wed, 24 February 2016	2	2660	Wed, 24 February 2016 12:43 By: Barbara Boehmer
Why this happens with Recyclebin in Oracle Oracle DB, 10g R2, Windows server 2008 R2 By: mdsirajoddin on Wed, 24 February 2016	7	4213	Wed, 24 February 2016 11:20 By: Michel Cadot
ORA-00600: internal error code forms 6i and database 10g win xp By: alshadbik on Tue, 23 February 2016	7	3282	Wed, 24 February 2016 07:59 By: Littlefoot
General question about temporary tables Oracle 11GR2, WIN Server 2008 By: OlafCologne on Wed, 24 February 2016	2	1977	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	3501	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	9948	Wed, 24 February 2016 01:00 By: Michel Cadot
Ref cursor ? 4.1.3 sql developer By: M123 on Mon, 22 February 2016	3	2699	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	25358	Tue, 23 February 2016 01:58 By: pointers
Join 2 select statements Oracle 11203, Windows By: kar116 on Tue, 23 February 2016	1	2065	Tue, 23 February 2016 00:58 By: Michel Cadot