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
Materialized view creation with complex queries 11.2.0.4 By: grpatwari on Wed, 26 October 2016	12	2840	Mon, 31 October 2016 04:18 By: grpatwari
Bug in Oracle External Table Not display Decimal Values Oracle11g, Unix By: ninan on Thu, 27 October 2016	8	2871	Fri, 28 October 2016 02:58 By: Michel Cadot
Split Blog column to multiple columns within a row By: alexust on Wed, 26 October 2016	4	1590	Thu, 27 October 2016 15:01 By: Solomon Yakobson
Purging old records 11gR2 - Linux By: grvenkatesh1986@gmail.com on Thu, 27 October 2016	6	1904	Thu, 27 October 2016 11:51 By: Michel Cadot
Query : Need help on populating prev day data in current day if missing Oracle 11.2 By: srinivas.k2005 on Tue, 25 October 2016	7	2231	Wed, 26 October 2016 10:14 By: Michel Cadot
NULL VS '' Oracle 11g Release 2, Linux By: anil_mk on Wed, 26 October 2016	4	1398	Wed, 26 October 2016 10:13 By: Michel Cadot
transaction id sql By: suji6281 on Mon, 24 October 2016	4	5054	Tue, 25 October 2016 23:54 By: Barbara Boehmer
Referencing Collection elements 11g By: Irish88 on Fri, 14 October 2016	6	2505	Tue, 25 October 2016 06:45 By: Irish88
worklist sql By: suji6281 on Fri, 21 October 2016	3	2507	Tue, 25 October 2016 05:07 By: suji6281
error ORA 210001 By: yk107 on Mon, 24 October 2016	7	2324	Tue, 25 October 2016 03:14 By: cookiemonster
Can we update "last_update_date" on Closed\Cancelled Orders using API Oracle R12 By: ajayhareesh on Mon, 24 October 2016	1	2529	Mon, 24 October 2016 19:52 By: Barbara Boehmer
need help in sql query oracle 10g By: harry13 on Mon, 24 October 2016	2	1086	Mon, 24 October 2016 07:52 By: Michel Cadot
calculate working days not beween date - merged ( 1 2) By: shahzad-ul-hasan on Tue, 10 November 2015	79	10980	Fri, 21 October 2016 01:36 By: John Watson
multi insert By: premier10 on Thu, 20 October 2016	14	3961	Thu, 20 October 2016 13:13 By: Bill B
Interval in DBMS_JOB 11.2.0.4 By: azeem87 on Wed, 19 October 2016	2	1520	Thu, 20 October 2016 04:18 By: cookiemonster
sql query with combination of row values By: gorants on Wed, 19 October 2016	5	1302	Thu, 20 October 2016 03:09 By: pablolee
PL/SQL Function fails without an exception Oracle 12c By: moverdear on Mon, 19 September 2016	11	1821	Wed, 19 October 2016 09:54 By: BlackSwan
Insert a space in the middle of a six characther string Oracle 11g By: halifaxns on Tue, 18 October 2016	2	1183	Tue, 18 October 2016 11:09 By: halifaxns
Help required for getting create index DDL on partitioned table. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Tue, 18 October 2016	8	3148	Tue, 18 October 2016 08:12 By: Michel Cadot
star keyword oracle Oracle 11g By: ram_orafaq1989 on Mon, 17 October 2016	3	1341	Mon, 17 October 2016 15:06 By: EdStevens
replace with question mark in the filename oracle 11.2.0.3 By: pointers on Sat, 15 October 2016	2	1445	Sat, 15 October 2016 06:12 By: pointers
Confirming Custom Raised Error Exceptions Oracle 11g By: Irish88 on Fri, 07 October 2016	6	1873	Fri, 14 October 2016 08:48 By: Irish88
Update Statement Correction By: suji6281 on Thu, 13 October 2016	3	1236	Thu, 13 October 2016 11:35 By: Michel Cadot
ORA-01843: not a valid month and ORA-01847: day of month must be between 1 and last day of month 11.2.0.4 By: azeem87 on Wed, 12 October 2016	10	3705	Thu, 13 October 2016 10:51 By: Solomon Yakobson
How to generate Query aggregation in oracle Oracle By: rohansr002 on Wed, 12 October 2016	2	1212	Thu, 13 October 2016 00:31 By: Michel Cadot
pl/sql table Oracle 12c By: SamMen on Wed, 12 October 2016	4	1162	Wed, 12 October 2016 13:01 By: John Watson
Anonymous block in sql plus By: SamMen on Tue, 11 October 2016	7	2961	Wed, 12 October 2016 11:38 By: Bill B
Create Table error 11g By: Irish88 on Tue, 11 October 2016	3	1381	Wed, 12 October 2016 07:24 By: Irish88
Unable to Recreate the Procedure Oracle 10g By: chat2raj.s on Tue, 11 October 2016	7	1382	Tue, 11 October 2016 08:57 By: chat2raj.s
Easy Query By: calamardo114 on Mon, 10 October 2016	8	2063	Tue, 11 October 2016 03:41 By: cookiemonster
What is Corrected By RowID? I wish to know Missing Numbers in a column By: graphe on Tue, 11 October 2016	4	1458	Tue, 11 October 2016 03:39 By: Littlefoot
rows to column text By: bchowdam on Fri, 07 October 2016	13	3779	Mon, 10 October 2016 19:44 By: Barbara Boehmer
compile invalid view By: desmond30 on Mon, 10 October 2016	5	1284	Mon, 10 October 2016 14:47 By: Michel Cadot
If exists clause in oracle By: mazeem on Sat, 08 October 2016	6	1613	Sun, 09 October 2016 07:03 By: Solomon Yakobson
Declations unknown SQL Developer 4.0.3.16 By: Donfox09 on Fri, 07 October 2016	6	1574	Fri, 07 October 2016 21:34 By: Donfox09
Displaying DESC_TAB parms Oralce 11g By: Irish88 on Mon, 03 October 2016	18	4867	Thu, 06 October 2016 13:15 By: Barbara Boehmer
Count of Data in Each Subpartition Oracle 11g By: abhayman on Wed, 05 October 2016	9	2207	Thu, 06 October 2016 13:15 By: Bill B
view and Cursor behavior :Run time Exception:ORA-00932: inconsistent datatypes: expected - got - oracle 11g By: kadhir on Thu, 06 October 2016	5	1468	Thu, 06 October 2016 12:51 By: Bill B
REGEXP_REPLACE oracle 11g By: chavva.kiru@gmail.com on Wed, 05 October 2016	2	1163	Thu, 06 October 2016 00:30 By: Michel Cadot
Get the deletion date for a certain DB object (Stored Procedure) 11.0.2.10 By: OraFerro on Wed, 05 October 2016	8	1547	Wed, 05 October 2016 09:53 By: Bill B