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
Get all installments based on several plans (get unique values based on a single column) 11.2.0.10 By: OraFerro on Thu, 17 March 2016	4	1382	Sat, 19 March 2016 23:17 By: OraFerro
Inserting data into local partitioned index vs global partitioned index Oracle 11g By: sasisan09 on Wed, 09 March 2016	6	1511	Wed, 16 March 2016 01:12 By: sasisan09
package -error 4.1.3 sql developer By: M123 on Thu, 10 March 2016	4	1495	Fri, 11 March 2016 18:31 By: Barbara Boehmer
compare fields ignoring spaces & dashes & leading zero's Oracle SQL developer By: slackermn on Fri, 04 March 2016	4	3156	Fri, 11 March 2016 08:49 By: slackermn
cursor logic 4.1.3 sql developer By: M123 on Tue, 08 March 2016	8	2538	Thu, 10 March 2016 09:10 By: M123
Grouping Query Oracle 11g By: sasisan09 on Thu, 09 April 2015	5	2137	Wed, 09 March 2016 14:04 By: Solomon Yakobson
Understanding locking 12c By: gorants on Sun, 06 March 2016	18	3813	Wed, 09 March 2016 11:55 By: Michel Cadot
Outer query Oracle11g By: ssyr22 on Wed, 09 March 2016	8	1651	Wed, 09 March 2016 10:57 By: gazzag
dependency question By: desmond30 on Wed, 09 March 2016	1	868	Wed, 09 March 2016 10:43 By: BlackSwan
UTL_FILE Oracle 10g By: mano11022 on Wed, 09 March 2016	1	961	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	1684	Tue, 08 March 2016 10:29 By: mjm22
Oracle SQL 11G Express Edition By: mcdinesh.200@gmail.com on Fri, 04 March 2016	4	1289	Tue, 08 March 2016 07:48 By: Bill B
row to column plsql By: poppop on Sun, 06 March 2016	8	1849	Mon, 07 March 2016 16:21 By: Bill B
Issue with Sys_context Oracle 11g, windows By: Vijay55 on Mon, 07 March 2016	14	2567	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	2512	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	1467	Fri, 04 March 2016 08:18 By: cookiemonster
Response in JSON format Oracle , 12C, windowns By: sunilreddy on Thu, 03 March 2016	3	4627	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	1482	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	2750	Thu, 03 March 2016 06:10 By: Michel Cadot
Too many results By: pretoriaan1971 on Thu, 03 March 2016	1	918	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	1011	Thu, 03 March 2016 02:12 By: Michel Cadot
ORA-02292: integrity constraint error oracle 12c By: gorants on Wed, 02 March 2016	2	862	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	4240	Tue, 01 March 2016 11:15 By: Solomon Yakobson
Select only One Case results Oralcle SQL By: vradhak7 on Mon, 29 February 2016	2	1309	Mon, 29 February 2016 09:05 By: Michel Cadot
Account Lock ~ OS user 12c By: deepakdot on Tue, 23 February 2016	8	1858	Mon, 29 February 2016 07:14 By: deepakdot
Not exists with union query-Help Oracle 11G By: Ratika on Mon, 22 February 2016	14	2831	Mon, 29 February 2016 05:37 By: Michel Cadot
html character to unicode 11g By: mshrkshl on Mon, 29 February 2016	2	1123	Mon, 29 February 2016 03:43 By: mshrkshl
Finding the source of the Company By: hypesslearner on Sat, 27 February 2016	11	2298	Mon, 29 February 2016 00:04 By: Littlefoot
String Printing by PL/SQL code? 10g By: P1Oracle on Sat, 27 February 2016	6	1698	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	1691	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	3034	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	1719	Fri, 26 February 2016 03:49 By: cookiemonster
retrieve first changed row By: suji6281 on Mon, 15 February 2016	35	4440	Fri, 26 February 2016 01:48 By: varlamovvp
composite data type 4.1.3 sql developer By: M123 on Thu, 25 February 2016	7	1634	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	1549	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	2572	Thu, 25 February 2016 04:31 By: varlamovvp
External table error By: techgirl123 on Wed, 24 February 2016	2	1206	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	1899	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	1470	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	821	Wed, 24 February 2016 06:43 By: Michel Cadot