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
Procidure includ not duplicate By: rkled on Mon, 04 July 2016	3	1748	Mon, 04 July 2016 09:29 By: Michel Cadot
Updating Status W to A SQL By: Salehin on Tue, 31 May 2016	28	10534	Mon, 04 July 2016 02:59 By: cookiemonster
PLSQL grant script not working correctly 12c By: ICB555 on Fri, 01 July 2016	5	2436	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	22928	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	1775	Thu, 30 June 2016 16:24 By: Barbara Boehmer
Issue in Exxternal Table Oracle 11g By: jeeva7311 on Tue, 28 June 2016	9	2608	Thu, 30 June 2016 08:51 By: Solomon Yakobson
Conversion Approach Oracle 12c, Windows Server 2012 By: abacusdotcom on Tue, 28 June 2016	4	1573	Wed, 29 June 2016 07:38 By: abacusdotcom
low performance of CONNECT BY Oracle 11g By: Elham_gh on Tue, 28 June 2016	2	1651	Tue, 28 June 2016 08:56 By: Bill B
SQL for Tables Oracle 11g R2 By: javed.khan on Mon, 27 June 2016	15	2556	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	3913	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	2708	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	3442	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	3361	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	1862	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	71700	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	5509	Thu, 23 June 2016 03:50 By: Michel Cadot
Better query Oracle 11 By: iliyan_84@abv.bg on Wed, 22 June 2016	2	1461	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	1878	Wed, 22 June 2016 06:34 By: EdStevens
A Query for Seating Arrangement By: javed.khan on Tue, 21 June 2016	5	5064	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	12259	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	1913	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	1951	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	1479	Mon, 20 June 2016 13:06 By: Michel Cadot
Exception Handling oracle 11g By: Satheesh.A on Mon, 20 June 2016	4	1884	Mon, 20 June 2016 03:01 By: cookiemonster
LAG function 10g, win8.1 By: rzkhan on Sat, 18 June 2016	3	1687	Sat, 18 June 2016 02:30 By: Michel Cadot
connect and level sql developer By: nath123 on Fri, 17 June 2016	1	1445	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	1778	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	1667	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	1623	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	2353	Thu, 16 June 2016 02:33 By: harshadsp
TO_NUMBER function not working By: richard_oak on Wed, 15 June 2016	2	2593	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	10907	Wed, 15 June 2016 13:01 By: Michel Cadot
What is wrong with this sql code? By: anticristo on Tue, 14 June 2016	3	1801	Wed, 15 June 2016 07:34 By: EdStevens
regexp replace Oracle 11g, Win 7 By: rajivn786 on Tue, 14 June 2016	9	2106	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	13580	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	5405	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	2532	Sat, 11 June 2016 16:47 By: Barbara Boehmer
Query that gives many different values By: Jdevil on Fri, 20 May 2016	22	4415	Sat, 11 June 2016 10:43 By: EdStevens
error 04063 creating view By: loginel on Fri, 10 June 2016	3	1866	Fri, 10 June 2016 17:31 By: Barbara Boehmer
Listing individual average price Oracle SQL By: misy on Thu, 09 June 2016	3	1917	Fri, 10 June 2016 12:00 By: misy