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
PLSQL grant script not working correctly 12c By: ICB555 on Fri, 01 July 2016	5	3842	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	27583	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	2741	Thu, 30 June 2016 16:24 By: Barbara Boehmer
Issue in Exxternal Table Oracle 11g By: jeeva7311 on Tue, 28 June 2016	9	4487	Thu, 30 June 2016 08:51 By: Solomon Yakobson
Conversion Approach Oracle 12c, Windows Server 2012 By: abacusdotcom on Tue, 28 June 2016	4	2694	Wed, 29 June 2016 07:38 By: abacusdotcom
low performance of CONNECT BY Oracle 11g By: Elham_gh on Tue, 28 June 2016	2	2577	Tue, 28 June 2016 08:56 By: Bill B
SQL for Tables Oracle 11g R2 By: javed.khan on Mon, 27 June 2016	15	5153	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	6041	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	4266	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	5456	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	5724	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	2889	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	80096	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	7478	Thu, 23 June 2016 03:50 By: Michel Cadot
Better query Oracle 11 By: iliyan_84@abv.bg on Wed, 22 June 2016	2	2760	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	3085	Wed, 22 June 2016 06:34 By: EdStevens
A Query for Seating Arrangement By: javed.khan on Tue, 21 June 2016	5	6513	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	18344	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	2749	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	3031	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	2429	Mon, 20 June 2016 13:06 By: Michel Cadot
Exception Handling oracle 11g By: Satheesh.A on Mon, 20 June 2016	4	3143	Mon, 20 June 2016 03:01 By: cookiemonster
LAG function 10g, win8.1 By: rzkhan on Sat, 18 June 2016	3	2644	Sat, 18 June 2016 02:30 By: Michel Cadot
connect and level sql developer By: nath123 on Fri, 17 June 2016	1	2248	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	2600	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	3061	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	3225	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	3767	Thu, 16 June 2016 02:33 By: harshadsp
TO_NUMBER function not working By: richard_oak on Wed, 15 June 2016	2	3913	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	14610	Wed, 15 June 2016 13:01 By: Michel Cadot
What is wrong with this sql code? By: anticristo on Tue, 14 June 2016	3	2845	Wed, 15 June 2016 07:34 By: EdStevens
regexp replace Oracle 11g, Win 7 By: rajivn786 on Tue, 14 June 2016	9	4467	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	16460	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	6783	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	4079	Sat, 11 June 2016 16:47 By: Barbara Boehmer
Query that gives many different values By: Jdevil on Fri, 20 May 2016	22	7696	Sat, 11 June 2016 10:43 By: EdStevens
error 04063 creating view By: loginel on Fri, 10 June 2016	3	2788	Fri, 10 June 2016 17:31 By: Barbara Boehmer
Listing individual average price Oracle SQL By: misy on Thu, 09 June 2016	3	2822	Fri, 10 June 2016 12:00 By: misy
Query Date Ranges with select statement (merged 3) Oracle SQL By: basitfaazal on Tue, 07 June 2016	12	6354	Fri, 10 June 2016 08:36 By: Bill B
RAISE_APPLICATION_ERROR to display multiple line 11g By: harshadsp on Fri, 10 June 2016	1	2131	Fri, 10 June 2016 08:35 By: Bill B