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
Need a help with SQL Oracle 12C By: mangeshbhasme on Sun, 02 April 2017	10	871	Tue, 04 April 2017 06:59 By: EdStevens
how to send tablespace mail alerts with PL/SQL By: diomahardhika on Mon, 13 March 2017	24	1427	Tue, 04 April 2017 03:56 By: cookiemonster
How can I convert a SQL command to MySql By: vinodkalpaka on Mon, 03 April 2017	24	1405	Tue, 04 April 2017 03:28 By: vinodkalpaka
Need help with SQL Oracle 12c By: jvanh on Fri, 31 March 2017	11	867	Mon, 03 April 2017 07:05 By: John Watson
Converting comma separated value in different rows Oracle 10g R2 By: amarbose on Sun, 02 April 2017	5	615	Mon, 03 April 2017 01:34 By: Michel Cadot
Can we replace any sub query using join By: asliyanage on Wed, 22 March 2017	3	610	Sat, 01 April 2017 02:59 By: Michel Cadot
oracle-dbms-fga-dynamically-create-an-audit-trail-or-policy (3 threads merged by bb) By: jokrasa on Wed, 22 March 2017	9	1037	Fri, 31 March 2017 11:45 By: Bill B
Re: ToDate function (split from hijacked thread http://www.orafaq.com/forum/t/56308/ by bb) By: hyder on Thu, 30 March 2017	2	491	Fri, 31 March 2017 11:41 By: Bill B
UTL_FILE_DIR Oracle 10gR2/ Solaris 10 By: reym21 on Wed, 29 March 2017	13	1066	Thu, 30 March 2017 07:22 By: Bill B
Avoid UNION ALL Oracle 11.2.0.3 By: pointers on Tue, 28 March 2017	5	760	Wed, 29 March 2017 08:14 By: pointers
Grouping for varying weeks Oracle 11.2.0.3 By: pointers on Mon, 27 March 2017	7	879	Tue, 28 March 2017 04:13 By: pointers
Inserting data from multiple table into 1 table windows By: Dnmunde on Sun, 26 March 2017	8	797	Mon, 27 March 2017 00:48 By: Michel Cadot
Receiving Email Messages through Oracle procedure. ( 1 2) By: woolmer on Tue, 01 May 2007	68	18212	Sat, 25 March 2017 13:10 By: Littlefoot
Query performance SQL By: Jiggu on Thu, 16 March 2017	19	1564	Fri, 24 March 2017 04:40 By: Bill B
CURSOR taking more time Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit By: amarjadhav on Fri, 10 March 2017	11	953	Thu, 23 March 2017 14:30 By: mikek
Orcale: Missing Group By expression working Oracle 12, Windows By: MikeBnDe on Wed, 22 March 2017	5	646	Wed, 22 March 2017 10:56 By: Michel Cadot
copy table structure By: asliyanage on Wed, 15 March 2017	17	1367	Wed, 22 March 2017 09:08 By: cookiemonster
Conditional Join Logic Oracle 11g By: rajsinha on Tue, 21 March 2017	3	570	Wed, 22 March 2017 03:35 By: John Watson
need help in setting constraints for the column based on subquery (2 threads merged by bb) sql,oracle 11g By: sowk on Thu, 16 March 2017	13	1403	Tue, 21 March 2017 06:24 By: John Watson
Append Hint in oracle By: amit.sonar on Fri, 17 March 2017	10	1096	Mon, 20 March 2017 09:44 By: Solomon Yakobson
ORA-14028 By: angro123 on Sun, 19 March 2017	5	993	Mon, 20 March 2017 09:08 By: cookiemonster
ORDER BY Clause error in cursor 9i, 9.0.1.1, XP By: billgates on Fri, 17 March 2017	7	828	Fri, 17 March 2017 16:11 By: BlackSwan
invalid option using INTERVAL( NUMTODSINTERVAL(1, 'DAY')) oracle db 11.2.0.1.0 By: centaurux on Thu, 16 March 2017	5	674	Fri, 17 March 2017 13:42 By: Bill B
query dead slow ORACLE EBS R12 By: annu-agi on Sat, 11 March 2017	19	1377	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	1454	Fri, 17 March 2017 04:48 By: annu-agi
oracle transaction By: asliyanage on Wed, 15 March 2017	14	971	Thu, 16 March 2017 14:04 By: Solomon Yakobson
ORACLE sql HELP NEEDED Oracle 11 g By: abhi2varmaarma on Thu, 16 March 2017	2	508	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	700	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	596	Tue, 14 March 2017 12:14 By: Michel Cadot
How to find highest salary ? By: asliyanage on Sun, 26 February 2017	37	2089	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	553	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	646	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	613	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	1495	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	935	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	1165	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	999	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	907	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	1110	Thu, 09 March 2017 07:11 By: Bill B
Exchange Partition Oracle 11g By: saipradyumn on Wed, 08 March 2017	2	610	Wed, 08 March 2017 01:43 By: saipradyumn