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
invalid option using INTERVAL( NUMTODSINTERVAL(1, 'DAY')) oracle db 11.2.0.1.0 By: centaurux on Thu, 16 March 2017	5	2768	Fri, 17 March 2017 13:42 By: Bill B
query dead slow ORACLE EBS R12 By: annu-agi on Sat, 11 March 2017	19	9027	Fri, 17 March 2017 11:31 By: Michel Cadot
function based index on date column 11g, 11.2.0.3.0 By: annu-agi on Fri, 10 March 2017	9	10512	Fri, 17 March 2017 04:48 By: annu-agi
oracle transaction By: asliyanage on Wed, 15 March 2017	14	6103	Thu, 16 March 2017 14:04 By: Solomon Yakobson
ORACLE sql HELP NEEDED Oracle 11 g By: abhi2varmaarma on Thu, 16 March 2017	2	2286	Thu, 16 March 2017 13:04 By: Michel Cadot
calling a function as a input parameter for a stored procedure oracle 11g release 2 By: raj85844 on Tue, 14 March 2017	6	3456	Thu, 16 March 2017 07:31 By: Bill B
dynamically creating index from same table in different schema 11g release 2 By: raj85844 on Tue, 14 March 2017	5	2456	Tue, 14 March 2017 12:14 By: Michel Cadot
How to find highest salary ? By: asliyanage on Sun, 26 February 2017	37	8431	Tue, 14 March 2017 05:49 By: asliyanage
Uploading csv files with different names on periodical basis. Oracle Enterprise Edition 11g R2 By: Manoj.Gupta.91 on Sat, 11 March 2017	3	2152	Mon, 13 March 2017 21:07 By: BlackSwan
Help me with error Compilation unit analysis terminated (2 threads merged by bb) window7 By: hosun0919 on Sun, 12 March 2017	3	6646	Mon, 13 March 2017 01:09 By: Michel Cadot
Query Help Oracle 12.1.0.2.0 By: SADASIVAM on Sun, 12 March 2017	0	2100	Sun, 12 March 2017 00:49 By: SADASIVAM
UTL_FILE.Put_Line carriage return. 11g R2 By: Manoj.Gupta.91 on Tue, 21 February 2017	6	9141	Sat, 11 March 2017 02:43 By: Manoj.Gupta.91
Assistance in Query Construction Oracle 10g, 11g By: ORA2015 on Thu, 09 March 2017	11	4963	Fri, 10 March 2017 10:55 By: ORA2015
Cant get rid of ORA-14155 after all googling (2 threads merged by bb) 9i, 9.0.1.1, XP By: billgates on Fri, 10 March 2017	11	6927	Fri, 10 March 2017 10:48 By: Michel Cadot
FOR UPDATE NOWAIT and ORA-29285: file write error Oracle 11g By: Prabhu Hooli on Sat, 04 March 2017	7	3644	Fri, 10 March 2017 08:16 By: BlackSwan
How do I total each column of data with multiple queries? Oracle 12.1, Version 3.2.20.09 By: Dallas Graves on Mon, 06 March 2017	8	3365	Thu, 09 March 2017 07:16 By: Bill B
which is best to locate row in oracle table By: asliyanage on Wed, 08 March 2017	15	5448	Thu, 09 March 2017 07:11 By: Bill B
Exchange Partition Oracle 11g By: saipradyumn on Wed, 08 March 2017	2	3186	Wed, 08 March 2017 01:43 By: saipradyumn
Enable novalidate constraint Oracle 11g By: ORAGENASHOK on Mon, 06 March 2017	7	4127	Tue, 07 March 2017 03:27 By: Roachcoach
How to split col into two columns according to data types By: ssyr on Mon, 06 March 2017	21	5887	Tue, 07 March 2017 03:02 By: cookiemonster
Date closest to event date By: ertweety on Mon, 06 March 2017	5	2863	Mon, 06 March 2017 20:44 By: ertweety
Analytical query Oracle 11g By: srinivas.k2005 on Mon, 06 March 2017	3	2423	Mon, 06 March 2017 09:46 By: cookiemonster
Delays between two dates excluding holidays/weekends Oracle 11.2.0.3 By: pointers on Thu, 02 March 2017	3	2589	Mon, 06 March 2017 02:58 By: cookiemonster
why cbo select FULL TABLE SCAN By: meganmegan on Thu, 02 March 2017	14	5304	Sun, 05 March 2017 04:57 By: meganmegan
Bitmap index for nullable timestamp column ? Oracle 11gR2 / Linux By: kevinz on Mon, 27 February 2017	19	6682	Thu, 02 March 2017 20:08 By: Bill B
Convert select query to a cursor and that has to fetch first record Oracle 11g By: msyogi on Thu, 02 March 2017	3	2120	Thu, 02 March 2017 14:21 By: Michel Cadot
Using debug in EBS r12 database with SQL Developer ORACLE EBS R12 By: annu-agi on Wed, 01 March 2017	4	3162	Thu, 02 March 2017 09:53 By: Michel Cadot
{} in SQL Oracle 11g By: rahul1982 on Thu, 02 March 2017	5	2405	Thu, 02 March 2017 08:13 By: cookiemonster
How to query and not include weekend or Bankholidays SQL By: timppap on Thu, 02 March 2017	2	2250	Thu, 02 March 2017 02:17 By: Barbara Boehmer
Carriage return in column data for spool Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: abhi_orcl on Tue, 28 February 2017	12	7413	Wed, 01 March 2017 12:08 By: Michel Cadot
Today I came across different space issue in 12c DB (merged 2) PL/SQL Release 12.1.0.2.0 - Production By: saini006 on Wed, 01 March 2017	5	3498	Wed, 01 March 2017 09:18 By: Flyby
Complex date differences - Bet you can't figure this one out. By: ertweety on Mon, 27 February 2017	11	5600	Tue, 28 February 2017 09:27 By: Michel Cadot
online table structure changes without affecting the user 11g By: manikandan23 on Sat, 25 February 2017	22	6203	Tue, 28 February 2017 06:49 By: EdStevens
Execute Immediate with Dynamic From table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 28 February 2017	2	2167	Tue, 28 February 2017 01:51 By: saipradyumn
2 column values going inverse and how to display corresponding keys 11g By: manikandan23 on Sat, 25 February 2017	14	6440	Mon, 27 February 2017 16:13 By: Barbara Boehmer
Avoiding 2 Group By clauses By: manikandan23 on Mon, 27 February 2017	5	2522	Mon, 27 February 2017 12:00 By: Michel Cadot
can we use column alias in having clause By: asliyanage on Sun, 26 February 2017	6	2764	Mon, 27 February 2017 09:14 By: Bill B
Deletes with respect to table sizes 11g By: manikandan23 on Sat, 25 February 2017	6	2381	Mon, 27 February 2017 09:11 By: Bill B
Return all rows if no matching condition found Oracle 12c By: pratik4891 on Sun, 26 February 2017	4	2120	Mon, 27 February 2017 07:21 By: Michel Cadot
Why difference between count() and count() By: asliyanage on Sat, 25 February 2017	15	5372	Sun, 26 February 2017 01:40 By: Michel Cadot