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
Pivot result using "Pivot" keyword 11.2 By: lott42_gmail on Thu, 20 April 2017	4	2623	Fri, 21 April 2017 12:22 By: lott42_gmail
LIKE vs NOT LIKE operator Oracle 12c By: srinivas.k2005 on Fri, 21 April 2017	4	2309	Fri, 21 April 2017 08:47 By: srinivas.k2005
DEFINE_COLUMN in DBMS_SQL Oracle 11.2.0.3 By: pointers on Thu, 20 April 2017	2	5727	Fri, 21 April 2017 02:09 By: pointers
Need help to form Query to split count into multiple rows By: rakesh281214 on Wed, 19 April 2017	5	3529	Thu, 20 April 2017 14:30 By: Barbara Boehmer
merge issue By: JEWEL78 on Tue, 18 April 2017	11	4935	Thu, 20 April 2017 03:55 By: cookiemonster
Regexp magic ! (I hope) 11.2.0.3.0 By: Amine on Fri, 14 April 2017	6	2856	Wed, 19 April 2017 01:47 By: Michel Cadot
pl/sql procedure using cursors oracle 11g By: POGAKU_SANTHOSH on Mon, 17 April 2017	3	2310	Mon, 17 April 2017 16:03 By: BlackSwan
Help required in SQL Analytic Function lag() Oracle 11gR2 11.2.0.1.0 By: jimit_shaili on Sat, 15 April 2017	5	2874	Mon, 17 April 2017 12:31 By: Michel Cadot
Partition tablespace name does not change after moving subpartition oracle12c By: shrinika on Sat, 15 April 2017	2	2530	Sat, 15 April 2017 12:59 By: shrinika
cursors windows By: jay12 on Tue, 04 April 2017	3	2103	Fri, 14 April 2017 15:49 By: Bill B
testing rollback 12.1.0.1 By: jinga on Fri, 07 April 2017	2	2047	Tue, 11 April 2017 12:56 By: Bill B
Hierarchical Queries Oracle 11.2.0.3 By: pointers on Thu, 06 April 2017	2	2500	Sat, 08 April 2017 07:42 By: pointers
UNION and dependent LOV Oracle R12 By: umamagi on Fri, 07 April 2017	3	2968	Sat, 08 April 2017 03:20 By: Littlefoot
Pre Insert logic in Trigger Oracle 11.2.0.3 By: pointers on Wed, 05 April 2017	10	3167	Thu, 06 April 2017 21:09 By: pointers
Avoid Distinct Oracle 11g By: manikandan23 on Wed, 05 April 2017	6	3722	Thu, 06 April 2017 03:33 By: cookiemonster
package By: jay12 on Wed, 05 April 2017	3	2405	Thu, 06 April 2017 03:30 By: cookiemonster
Split clob data and store in table Oracle 11g By: Roots_ct5 on Tue, 04 April 2017	3	2829	Tue, 04 April 2017 10:30 By: Roots_ct5
Need a help with SQL Oracle 12C By: mangeshbhasme on Sun, 02 April 2017	10	4238	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	9298	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	9265	Tue, 04 April 2017 03:28 By: vinodkalpaka
Need help with SQL Oracle 12c By: jvanh on Fri, 31 March 2017	11	4339	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	2859	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	2108	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	5302	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	2130	Fri, 31 March 2017 11:41 By: Bill B
UTL_FILE_DIR Oracle 10gR2/ Solaris 10 By: reym21 on Wed, 29 March 2017	13	5370	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	5987	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	3328	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	3992	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	63594	Sat, 25 March 2017 13:10 By: Littlefoot
Query performance SQL By: Jiggu on Thu, 16 March 2017	19	8518	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	3317	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	2541	Wed, 22 March 2017 10:56 By: Michel Cadot
copy table structure By: asliyanage on Wed, 15 March 2017	17	7285	Wed, 22 March 2017 09:08 By: cookiemonster
Conditional Join Logic Oracle 11g By: rajsinha on Tue, 21 March 2017	3	5156	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	6021	Tue, 21 March 2017 06:24 By: John Watson
Append Hint in oracle By: amit.sonar on Fri, 17 March 2017	10	4204	Mon, 20 March 2017 09:44 By: Solomon Yakobson
ORA-14028 By: angro123 on Sun, 19 March 2017	5	5240	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	3177	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	2766	Fri, 17 March 2017 13:42 By: Bill B