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
Return all rows if no matching condition found Oracle 12c By: pratik4891 on Sun, 26 February 2017	4	2162	Mon, 27 February 2017 07:21 By: Michel Cadot
Why difference between count() and count() By: asliyanage on Sat, 25 February 2017	15	5417	Sun, 26 February 2017 01:40 By: Michel Cadot
How to find No of Entries per week For consecutive week By: gspandian on Thu, 23 February 2017	30	10785	Sat, 25 February 2017 05:59 By: Solomon Yakobson
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 12c By: jaysorcale on Wed, 18 January 2017	14	22332	Sat, 25 February 2017 01:42 By: asliyanage
Declare a cursor from the return of a procedure? By: sdsmaster on Tue, 21 February 2017	8	3608	Thu, 23 February 2017 15:07 By: Barbara Boehmer
Update based on grouping 11.0.2.10 By: OraFerro on Mon, 20 February 2017	26	7285	Wed, 22 February 2017 05:24 By: Michel Cadot
PLSQL - Update in Loop Oracle 11g By: wmpl on Mon, 20 February 2017	5	3261	Tue, 21 February 2017 23:23 By: Barbara Boehmer
Flashback techniues By: Vijayarajan51 on Tue, 21 February 2017	2	2115	Tue, 21 February 2017 10:26 By: Michel Cadot
Loading techniques By: Vijayarajan51 on Tue, 21 February 2017	3	1825	Tue, 21 February 2017 10:10 By: Vijayarajan51
unique result Oracle 11g By: rahul1982 on Tue, 21 February 2017	2	1761	Tue, 21 February 2017 03:39 By: rahul1982
Comma separate value with column value as column name 11.2.0.4 By: grpatwari on Sun, 19 February 2017	4	2856	Mon, 20 February 2017 07:49 By: Michel Cadot
Synonym switching oracle 11g release 2 By: raj85844 on Thu, 16 February 2017	5	4739	Thu, 16 February 2017 16:50 By: Caffeine+
cumulative sum & product oracle 11g release 2 By: varada on Wed, 15 February 2017	18	7346	Thu, 16 February 2017 10:02 By: varada
Create a Job to run Oracle Package stored procedure 11.0.2.10 By: OraFerro on Wed, 15 February 2017	4	4298	Wed, 15 February 2017 23:05 By: OraFerro
Oracle BLOB DATA ORACLE,PLSQL By: bkumar on Wed, 15 February 2017	5	2463	Wed, 15 February 2017 14:11 By: BlackSwan
Global Temporary table storage Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit By: abhi_orcl on Tue, 14 February 2017	9	3076	Wed, 15 February 2017 10:36 By: abhi_orcl
Problem while using AUTHID CURRENT_USER By: amit.sonar on Fri, 10 February 2017	4	3146	Wed, 15 February 2017 09:26 By: cookiemonster
natural join change table By: asliyanage on Mon, 13 February 2017	7	2796	Tue, 14 February 2017 15:41 By: Bill B
REGEXP to find the comma position Oracle 11.2.0.3 By: pointers on Tue, 14 February 2017	2	1871	Tue, 14 February 2017 13:49 By: pointers
How to identify one row from duplicate rows By: asliyanage on Wed, 18 January 2017	6	2567	Tue, 14 February 2017 01:57 By: Michel Cadot
What is Unknown in logical operator By: asliyanage on Mon, 16 January 2017	4	2377	Tue, 14 February 2017 01:53 By: Michel Cadot
PL/SQL: numeric or value error: character string buffer too small 11.2.0.4 By: grpatwari on Mon, 24 October 2016	23	13278	Tue, 14 February 2017 00:16 By: grpatwari
Counting minutes in a date/time range By: dale2k9 on Tue, 07 February 2017	12	4546	Mon, 13 February 2017 10:18 By: Michel Cadot
Full outer join with ZERO rows in Second table 10.2 By: bluetooth420 on Sat, 11 February 2017	11	3779	Sun, 12 February 2017 13:05 By: bluetooth420
Using Oracle UTL_MAIL to send email through Kerio email server 11.0.2.10 ( 1 2) By: OraFerro on Mon, 06 February 2017	40	18053	Sun, 12 February 2017 09:56 By: Bill B
WHERE Clause With A Range By: jmltinc on Tue, 07 February 2017	18	6216	Thu, 09 February 2017 08:41 By: cookiemonster
generate dynamic query and avoiding recompiling query Oracle 12.1.0.2 By: fabi88 on Wed, 08 February 2017	5	2132	Wed, 08 February 2017 08:54 By: fabi88
AND & OR Condition Usage By: vharish006 on Tue, 07 February 2017	6	2459	Wed, 08 February 2017 03:25 By: cookiemonster
Display only 10 charecters from column Oracle 11g Release 2 Linux By: anil_mk on Mon, 06 February 2017	12	3917	Tue, 07 February 2017 07:07 By: Bill B
DBLinks stopped after wrongly changing domain name in sqlnet.ora 11.0.2.10 By: OraFerro on Tue, 07 February 2017	6	2297	Tue, 07 February 2017 03:47 By: OraFerro
Cursor Program To Find Tax Amount By: Hemanth319 on Sun, 05 February 2017	3	2242	Mon, 06 February 2017 15:02 By: Bill B
Function To Reverese The Phone Number By: Hemanth319 on Sun, 05 February 2017	5	2609	Mon, 06 February 2017 14:54 By: Bill B
Writing multiple Files using UTL_FILE 11g, Windows XP By: siva27 on Mon, 06 February 2017	6	2645	Mon, 06 February 2017 08:00 By: Michel Cadot
Performance tuning in delete operation Oracle 11g By: raj85844 on Tue, 31 January 2017	5	2441	Fri, 03 February 2017 04:03 By: John Watson
order of operations in the below statements sql developer By: M123 on Thu, 02 February 2017	3	2320	Fri, 03 February 2017 03:25 By: cookiemonster
constraint error 10g, win8.1, By: rzkhan on Tue, 31 January 2017	28	7404	Wed, 01 February 2017 10:28 By: Michel Cadot
Help with update statement Oracle 11g, 2, Solaris 11 By: apenkov on Tue, 31 January 2017	6	2501	Wed, 01 February 2017 08:00 By: Bill B
Procedure out of statements By: m_r_a on Wed, 01 February 2017	16	4002	Wed, 01 February 2017 03:29 By: cookiemonster
ORA-01722 for bind variable in dbms_sql Oracle 10g By: myadi26 on Sun, 29 January 2017	6	3274	Sun, 29 January 2017 07:55 By: Michel Cadot
cursor leak and open cursors Oracle12c By: shrinika on Thu, 26 January 2017	6	2183	Fri, 27 January 2017 14:39 By: shrinika