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
complex query oracle By: bikashp on Wed, 23 November 2016	1	491	Wed, 23 November 2016 06:35 By: Michel Cadot
Oracle Outer join Operator(+) with operand of OR or IN Oracle, 11g, Windows 7 By: azamkhan on Mon, 23 January 2017	1	323	Mon, 23 January 2017 00:22 By: Michel Cadot
Element exists in a collection Oracle 11.2.0.3 By: pointers on Fri, 02 December 2016	3	716	Fri, 02 December 2016 06:43 By: Solomon Yakobson
Trigger to prevent delete according to select 11.0.2.10 By: OraFerro on Tue, 22 November 2016	9	913	Thu, 24 November 2016 08:16 By: ALEXWE
Show all months between 2 months in a group by query Oracle 11g By: avni on Mon, 21 November 2016	1	656	Mon, 21 November 2016 03:09 By: Michel Cadot
Please provide best approach to design ETL in Oracle. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Thu, 24 November 2016	4	451	Thu, 24 November 2016 07:20 By: John Watson
Correct order of data in Hierarchical Query Oracle 12c By: ramjss on Sat, 19 November 2016	13	1250	Tue, 06 December 2016 04:29 By: ramjss
electronic data sharding By: sudeepto chattaraj on Fri, 18 November 2016	14	1118	Tue, 22 November 2016 07:26 By: EdStevens
Update Table Based On Another Table oracle 11g, windows server By: morissa on Fri, 18 November 2016	14	4577	Tue, 22 November 2016 03:38 By: cookiemonster
Rows not populating Oracle DB 12c By: krishna.orcl97 on Fri, 18 November 2016	9	674	Fri, 18 November 2016 14:18 By: BlackSwan
Oracle 11g Ntile function on top of Dense_rank By: raj85844 on Wed, 16 November 2016	1	401	Wed, 16 November 2016 23:36 By: raj85844
Calling procedure from trigger Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Windows 7 By: SW26477 on Wed, 16 November 2016	2	534	Wed, 16 November 2016 10:32 By: Michel Cadot
PL/SQL Email Oracle 11gr2 By: VariableReset on Sat, 12 November 2016	3	714	Sat, 12 November 2016 06:48 By: VariableReset
spool sql data in excel multi sheets By: Preeti123456 on Thu, 10 November 2016	3	720	Fri, 11 November 2016 04:17 By: pablolee
Need to match combination string at database Oracle 11g, AIX server By: Shan.kumar on Thu, 10 November 2016	12	7176	Mon, 14 November 2016 00:21 By: Shan.kumar
How to log what parameter the API is passing to query oracle 11g By: magnify on Wed, 09 November 2016	3	301	Wed, 09 November 2016 12:22 By: BlackSwan
SQL Query Request oracle 11g By: raj85844 on Wed, 09 November 2016	14	975	Fri, 11 November 2016 10:19 By: Michel Cadot
Search data between months Oracle 11g By: Xandot on Wed, 09 November 2016	2	396	Wed, 09 November 2016 05:07 By: Xandot
Query help Oracle By: julien1630 on Tue, 08 November 2016	14	6588	Tue, 08 November 2016 10:36 By: Solomon Yakobson
merge statement problem 10g By: emadnabil on Sun, 13 November 2016	15	981	Mon, 14 November 2016 07:56 By: emadnabil
Filling a table of object in function loop 11.0.2.10 By: OraFerro on Sun, 13 November 2016	7	763	Mon, 14 November 2016 06:31 By: Michel Cadot
external table with single column oracle 11g By: guddu_12 on Mon, 07 November 2016	23	886	Tue, 08 November 2016 07:06 By: EdStevens
Procedure execution issue and trace 11g r2, linux By: qazims92 on Mon, 07 November 2016	7	601	Tue, 08 November 2016 03:56 By: cookiemonster
Conditional based default value Oracle 11 By: saipradyumn on Mon, 07 November 2016	5	346	Mon, 07 November 2016 08:05 By: saipradyumn
how to close open cursor when exception oracle 11 By: yk107 on Tue, 15 November 2016	11	1106	Wed, 16 November 2016 12:57 By: yk107
package modified details oracle 12c, unix By: pstanand on Sun, 06 November 2016	6	390	Sun, 06 November 2016 02:27 By: Michel Cadot
Getting months in the current Fiscal Year in Oracle Oracle Database 11g Enterprise Edition By: megha2525 on Fri, 04 November 2016	5	592	Wed, 09 November 2016 03:01 By: Flyby
summation of multiple values for a particular at specific period oracle 10.g By: eogyamfi on Thu, 03 November 2016	10	492	Fri, 04 November 2016 11:04 By: Michel Cadot
How to format JSON column RDBMS 12C By: samiraly on Mon, 31 October 2016	5	616	Thu, 03 November 2016 09:04 By: samiraly
conversion to 16bit decimal oracle 11gr2 By: guddu_12 on Fri, 28 October 2016	16	904	Mon, 07 November 2016 10:09 By: guddu_12
ORA-06502 with UTL_RAW 11gr2, Windows By: qazims92 on Fri, 28 October 2016	12	840	Wed, 02 November 2016 02:29 By: qazims92
Bug in Oracle External Table Not display Decimal Values Oracle11g, Unix By: ninan on Thu, 27 October 2016	8	691	Fri, 28 October 2016 02:58 By: Michel Cadot
Purging old records 11gR2 - Linux By: grvenkatesh1986@gmail.com on Thu, 27 October 2016	6	587	Thu, 27 October 2016 11:51 By: Michel Cadot
low value & high value Oracle 11g By: saipradyumn on Thu, 27 October 2016	2	591	Tue, 01 November 2016 06:58 By: saipradyumn
Query Help Oracle Database 11g 11.2.0.4.0 By: SADASIVAM on Thu, 27 October 2016	4	780	Wed, 02 November 2016 01:11 By: SADASIVAM
Split Blog column to multiple columns within a row By: alexust on Wed, 26 October 2016	4	531	Thu, 27 October 2016 15:01 By: Solomon Yakobson
Materialized view creation with complex queries 11.2.0.4 By: grpatwari on Wed, 26 October 2016	12	954	Mon, 31 October 2016 04:18 By: grpatwari
Query Help Oracle Database 11g 11.2.0.4.0 By: SADASIVAM on Wed, 02 November 2016	0	878	Wed, 02 November 2016 01:08 By: SADASIVAM
Table compression Oracle 12c By: srinivas.k2005 on Fri, 28 October 2016	15	821	Tue, 01 November 2016 15:28 By: John Watson
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	958	Wed, 26 October 2016 10:14 By: Michel Cadot