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
String Manipulations Oracle 11g R2 By: javed.khan on Mon, 04 July 2016	1	1428	Mon, 04 July 2016 13:36 By: Michel Cadot
Pick One : A Query for Multiple Submission of form but to take only first one. Oracle 11g R2 By: javed.khan on Tue, 28 June 2016	11	3282	Mon, 04 July 2016 13:13 By: Michel Cadot
Constraints in External Table. Oracle 11g By: jeeva7311 on Mon, 04 July 2016	4	1654	Mon, 04 July 2016 10:13 By: jeeva7311
Procidure includ not duplicate By: rkled on Mon, 04 July 2016	3	1757	Mon, 04 July 2016 09:29 By: Michel Cadot
Updating Status W to A SQL By: Salehin on Tue, 31 May 2016	28	10541	Mon, 04 July 2016 02:59 By: cookiemonster
PLSQL grant script not working correctly 12c By: ICB555 on Fri, 01 July 2016	5	2441	Mon, 04 July 2016 02:56 By: cookiemonster
First business day of a given month Oracle 10g By: sidh_z on Mon, 06 December 2010	24	22957	Fri, 01 July 2016 12:10 By: Michel Cadot
How can I modify length of a column in type definition. 11.2.0.1.0 By: Manoj.Gupta.91 on Thu, 30 June 2016	2	1781	Thu, 30 June 2016 16:24 By: Barbara Boehmer
Issue in Exxternal Table Oracle 11g By: jeeva7311 on Tue, 28 June 2016	9	2614	Thu, 30 June 2016 08:51 By: Solomon Yakobson
Conversion Approach Oracle 12c, Windows Server 2012 By: abacusdotcom on Tue, 28 June 2016	4	1580	Wed, 29 June 2016 07:38 By: abacusdotcom
low performance of CONNECT BY Oracle 11g By: Elham_gh on Tue, 28 June 2016	2	1657	Tue, 28 June 2016 08:56 By: Bill B
SQL for Tables Oracle 11g R2 By: javed.khan on Mon, 27 June 2016	15	2564	Mon, 27 June 2016 21:11 By: BlackSwan
Help Creating a Trigger for Reoccuring Events Oracle 12c By: mattfriend on Thu, 23 June 2016	12	3921	Mon, 27 June 2016 09:22 By: Bill B
column with data_type CLOB does not appear in user_ind_columns, why? By: gunderj on Sat, 25 June 2016	7	2718	Sat, 25 June 2016 10:57 By: Michel Cadot
How to prevent trigger from firing on failed insert Oracle 8,2 By: laddg on Fri, 24 June 2016	13	3450	Sat, 25 June 2016 07:02 By: EdStevens
Table update through nested loop issue in function By: nitesh.erp@gmail.com on Thu, 23 June 2016	15	3372	Thu, 23 June 2016 09:28 By: nitesh.erp@gmail.com
Analytic Report query Oracle 11g By: srinivas.k2005 on Thu, 23 June 2016	2	1869	Thu, 23 June 2016 08:18 By: srinivas.k2005
ORA-29278: SMTP transient error: 421 Service not available By: musman on Tue, 06 May 2008	29	71735	Thu, 23 June 2016 08:12 By: BlackSwan
Need Help to convert rows into column Oracle 11g By: chintan.patel on Tue, 21 June 2016	12	5522	Thu, 23 June 2016 03:50 By: Michel Cadot
Better query Oracle 11 By: iliyan_84@abv.bg on Wed, 22 June 2016	2	1465	Thu, 23 June 2016 02:56 By: Roachcoach
how to get one week historical query for v$SQL By: royalyogi on Tue, 21 June 2016	4	1885	Wed, 22 June 2016 06:34 By: EdStevens
A Query for Seating Arrangement By: javed.khan on Tue, 21 June 2016	5	5070	Wed, 22 June 2016 00:43 By: Michel Cadot
Update 7% basic Salary SQL Plus 8.0 ( 1 2) By: Salehin on Wed, 11 May 2016	44	12267	Mon, 20 June 2016 22:05 By: Salehin
SQL to filter redundant key field Oracle 9.2 on Solaris By: raghx on Mon, 20 June 2016	2	1919	Mon, 20 June 2016 19:34 By: Barbara Boehmer
how to export the data from table to the file oracle 11g By: tolupuluri on Mon, 20 June 2016	4	1956	Mon, 20 June 2016 15:31 By: tolupuluri
Aggregate based on serial number after checking for thresholds By: ketangarg86 on Mon, 20 June 2016	3	1486	Mon, 20 June 2016 13:06 By: Michel Cadot
Exception Handling oracle 11g By: Satheesh.A on Mon, 20 June 2016	4	1889	Mon, 20 June 2016 03:01 By: cookiemonster
LAG function 10g, win8.1 By: rzkhan on Sat, 18 June 2016	3	1691	Sat, 18 June 2016 02:30 By: Michel Cadot
connect and level sql developer By: nath123 on Fri, 17 June 2016	1	1451	Fri, 17 June 2016 15:10 By: Solomon Yakobson
What is the use of %ROWTYPE and %TYPE in PL/SQL? By: abhik143 on Fri, 17 June 2016	2	1787	Fri, 17 June 2016 02:13 By: Frank Naude
Query table with multi part column names 11g By: bobghw on Thu, 16 June 2016	6	1675	Thu, 16 June 2016 15:21 By: Bill B
Calculating values from two different tables by using SQL command. Oracle 11g ver 11.2.0.1.0 By: faisal78 on Thu, 16 June 2016	5	1631	Thu, 16 June 2016 08:39 By: Bill B
Removing specific line from file using UTL_FILE 11g By: harshadsp on Tue, 14 June 2016	6	2361	Thu, 16 June 2016 02:33 By: harshadsp
TO_NUMBER function not working By: richard_oak on Wed, 15 June 2016	2	2614	Wed, 15 June 2016 17:56 By: richard_oak
"ORA-22813: operand value exceeds system limits" on executing sql returning XMLTYPE data Oracle 11g By: Nikita_01 on Tue, 14 June 2016	12	10924	Wed, 15 June 2016 13:01 By: Michel Cadot
What is wrong with this sql code? By: anticristo on Tue, 14 June 2016	3	1808	Wed, 15 June 2016 07:34 By: EdStevens
regexp replace Oracle 11g, Win 7 By: rajivn786 on Tue, 14 June 2016	9	2115	Tue, 14 June 2016 15:55 By: Bill B
External Table and Blank spaces Oracle 12C Windows NT By: pstanand on Mon, 13 June 2016	14	13610	Tue, 14 June 2016 11:01 By: Michel Cadot
order of geting value from sequence by trigger Oracle 11g By: miodas007 on Wed, 01 June 2016	6	5411	Mon, 13 June 2016 09:58 By: Bill B
Extract the most data after joining 3 tables Oracle SQL By: misy on Sat, 11 June 2016	8	2538	Sat, 11 June 2016 16:47 By: Barbara Boehmer