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
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 12c By: jaysorcale on Wed, 18 January 2017	14	22161	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	3538	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	7244	Wed, 22 February 2017 05:24 By: Michel Cadot
PLSQL - Update in Loop Oracle 11g By: wmpl on Mon, 20 February 2017	5	3209	Tue, 21 February 2017 23:23 By: Barbara Boehmer
Flashback techniues By: Vijayarajan51 on Tue, 21 February 2017	2	2061	Tue, 21 February 2017 10:26 By: Michel Cadot
Loading techniques By: Vijayarajan51 on Tue, 21 February 2017	3	1780	Tue, 21 February 2017 10:10 By: Vijayarajan51
unique result Oracle 11g By: rahul1982 on Tue, 21 February 2017	2	1711	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	2810	Mon, 20 February 2017 07:49 By: Michel Cadot
Synonym switching oracle 11g release 2 By: raj85844 on Thu, 16 February 2017	5	4654	Thu, 16 February 2017 16:50 By: Caffeine+
cumulative sum & product oracle 11g release 2 By: varada on Wed, 15 February 2017	18	7256	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	4237	Wed, 15 February 2017 23:05 By: OraFerro
Oracle BLOB DATA ORACLE,PLSQL By: bkumar on Wed, 15 February 2017	5	2415	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	3012	Wed, 15 February 2017 10:36 By: abhi_orcl
Problem while using AUTHID CURRENT_USER By: amit.sonar on Fri, 10 February 2017	4	3025	Wed, 15 February 2017 09:26 By: cookiemonster
natural join change table By: asliyanage on Mon, 13 February 2017	7	2734	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	1810	Tue, 14 February 2017 13:49 By: pointers
How to identify one row from duplicate rows By: asliyanage on Wed, 18 January 2017	6	2501	Tue, 14 February 2017 01:57 By: Michel Cadot
What is Unknown in logical operator By: asliyanage on Mon, 16 January 2017	4	2335	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	13212	Tue, 14 February 2017 00:16 By: grpatwari
Counting minutes in a date/time range By: dale2k9 on Tue, 07 February 2017	12	4488	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	3732	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	17853	Sun, 12 February 2017 09:56 By: Bill B
WHERE Clause With A Range By: jmltinc on Tue, 07 February 2017	18	6157	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	2083	Wed, 08 February 2017 08:54 By: fabi88
AND & OR Condition Usage By: vharish006 on Tue, 07 February 2017	6	2403	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	3878	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	2245	Tue, 07 February 2017 03:47 By: OraFerro
Cursor Program To Find Tax Amount By: Hemanth319 on Sun, 05 February 2017	3	2198	Mon, 06 February 2017 15:02 By: Bill B
Function To Reverese The Phone Number By: Hemanth319 on Sun, 05 February 2017	5	2560	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	2571	Mon, 06 February 2017 08:00 By: Michel Cadot
Performance tuning in delete operation Oracle 11g By: raj85844 on Tue, 31 January 2017	5	2387	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	2267	Fri, 03 February 2017 03:25 By: cookiemonster
constraint error 10g, win8.1, By: rzkhan on Tue, 31 January 2017	28	7360	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	2451	Wed, 01 February 2017 08:00 By: Bill B
Procedure out of statements By: m_r_a on Wed, 01 February 2017	16	3954	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	3199	Sun, 29 January 2017 07:55 By: Michel Cadot
cursor leak and open cursors Oracle12c By: shrinika on Thu, 26 January 2017	6	2128	Fri, 27 January 2017 14:39 By: shrinika
JSON Parsing Linux, Oracle 11.2.0.3.0 By: gopieee16 on Tue, 24 January 2017	4	3962	Fri, 27 January 2017 04:31 By: Michel Cadot
Doubt in SYS_CONTEXT By: gajini on Tue, 24 January 2017	6	2640	Fri, 27 January 2017 03:24 By: cookiemonster
scrambling the data for a column in a tables oracle 11g version 2 By: raj85844 on Mon, 09 January 2017	15	17449	Tue, 24 January 2017 13:28 By: Bill B