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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
external table with single column oracle 11g By: guddu_12 on Mon, 07 November 2016	23	744	Tue, 08 November 2016 07:06 By: EdStevens
Procedure execution issue and trace 11g r2, linux By: qazims92 on Mon, 07 November 2016	7	509	Tue, 08 November 2016 03:56 By: cookiemonster
conversion to 16bit decimal oracle 11gr2 By: guddu_12 on Fri, 28 October 2016	16	709	Mon, 07 November 2016 10:09 By: guddu_12
Conditional based default value Oracle 11 By: saipradyumn on Mon, 07 November 2016	5	258	Mon, 07 November 2016 08:05 By: saipradyumn
package modified details oracle 12c, unix By: pstanand on Sun, 06 November 2016	6	302	Sun, 06 November 2016 02:27 By: Michel Cadot
query needed without using only where clause 10g By: god_bunu on Fri, 04 November 2016	3	320	Sat, 05 November 2016 02:00 By: Michel Cadot
Selecting the columns Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Tue, 06 September 2016	32	1198	Fri, 04 November 2016 11:24 By: Solomon Yakobson
summation of multiple values for a particular at specific period oracle 10.g By: eogyamfi on Thu, 03 November 2016	10	382	Fri, 04 November 2016 11:04 By: Michel Cadot
Query Help Oracle 11g By: SADASIVAM on Sat, 15 October 2016	14	822	Fri, 04 November 2016 04:03 By: SADASIVAM
How to format JSON column RDBMS 12C By: samiraly on Mon, 31 October 2016	5	478	Thu, 03 November 2016 09:04 By: samiraly
Column dropped 11 g By: saipradyumn on Mon, 24 October 2016	3	491	Wed, 02 November 2016 14:59 By: Bill B
Default Character type of the column Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sat, 01 October 2016	6	779	Wed, 02 November 2016 06:08 By: Solomon Yakobson
ORA-06502 with UTL_RAW 11gr2, Windows By: qazims92 on Fri, 28 October 2016	12	670	Wed, 02 November 2016 02:29 By: qazims92
Partition Removing Oracle 11g By: saipradyumn on Mon, 03 October 2016	8	664	Wed, 02 November 2016 01:21 By: saipradyumn
Query Help Oracle Database 11g 11.2.0.4.0 By: SADASIVAM on Thu, 27 October 2016	4	660	Wed, 02 November 2016 01:11 By: SADASIVAM
Query Help Oracle Database 11g 11.2.0.4.0 By: SADASIVAM on Wed, 02 November 2016	0	775	Wed, 02 November 2016 01:08 By: SADASIVAM
Table compression Oracle 12c By: srinivas.k2005 on Fri, 28 October 2016	15	668	Tue, 01 November 2016 15:28 By: John Watson
low value & high value Oracle 11g By: saipradyumn on Thu, 27 October 2016	2	469	Tue, 01 November 2016 06:58 By: saipradyumn
Materialized view creation with complex queries 11.2.0.4 By: grpatwari on Wed, 26 October 2016	12	800	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	508	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	428	Thu, 27 October 2016 15:01 By: Solomon Yakobson
Purging old records 11gR2 - Linux By: grvenkatesh1986@gmail.com on Thu, 27 October 2016	6	466	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	827	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	469	Wed, 26 October 2016 10:13 By: Michel Cadot
transaction id sql By: suji6281 on Mon, 24 October 2016	4	787	Tue, 25 October 2016 23:54 By: Barbara Boehmer
Referencing Collection elements 11g By: Irish88 on Fri, 14 October 2016	6	1038	Tue, 25 October 2016 06:45 By: Irish88
worklist sql By: suji6281 on Fri, 21 October 2016	3	1067	Tue, 25 October 2016 05:07 By: suji6281
error ORA 210001 By: yk107 on Mon, 24 October 2016	7	722	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	510	Mon, 24 October 2016 19:52 By: Barbara Boehmer
need help in sql query oracle 10g By: harry13 on Mon, 24 October 2016	2	335	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	3219	Fri, 21 October 2016 01:36 By: John Watson
multi insert By: premier10 on Thu, 20 October 2016	14	593	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	481	Thu, 20 October 2016 04:18 By: cookiemonster
sql query with combination of row values By: gorants on Wed, 19 October 2016	5	467	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	664	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	394	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	444	Tue, 18 October 2016 08:12 By: Michel Cadot
star keyword oracle Oracle 11g By: ram_orafaq1989 on Mon, 17 October 2016	3	350	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	490	Sat, 15 October 2016 06:12 By: pointers
Confirming Custom Raised Error Exceptions Oracle 11g By: Irish88 on Fri, 07 October 2016	6	641	Fri, 14 October 2016 08:48 By: Irish88