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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
cumulative sum & product oracle 11g release 2 By: varada on Wed, 15 February 2017	18	1584	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	859	Wed, 15 February 2017 23:05 By: OraFerro
Oracle BLOB DATA ORACLE,PLSQL By: bkumar on Wed, 15 February 2017	5	538	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	826	Wed, 15 February 2017 10:36 By: abhi_orcl
Problem while using AUTHID CURRENT_USER By: amit.sonar on Fri, 10 February 2017	4	684	Wed, 15 February 2017 09:26 By: cookiemonster
natural join change table By: asliyanage on Mon, 13 February 2017	7	747	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	508	Tue, 14 February 2017 13:49 By: pointers
How to identify one row from duplicate rows By: asliyanage on Wed, 18 January 2017	6	1019	Tue, 14 February 2017 01:57 By: Michel Cadot
What is Unknown in logical operator By: asliyanage on Mon, 16 January 2017	4	1097	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	4618	Tue, 14 February 2017 00:16 By: grpatwari
Counting minutes in a date/time range By: dale2k9 on Tue, 07 February 2017	12	1410	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	989	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	3196	Sun, 12 February 2017 09:56 By: Bill B
WHERE Clause With A Range By: jmltinc on Tue, 07 February 2017	18	1681	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	660	Wed, 08 February 2017 08:54 By: fabi88
AND & OR Condition Usage By: vharish006 on Tue, 07 February 2017	6	814	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	1256	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	709	Tue, 07 February 2017 03:47 By: OraFerro
Cursor Program To Find Tax Amount By: Hemanth319 on Sun, 05 February 2017	3	591	Mon, 06 February 2017 15:02 By: Bill B
Function To Reverese The Phone Number By: Hemanth319 on Sun, 05 February 2017	5	907	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	791	Mon, 06 February 2017 08:00 By: Michel Cadot
Performance tuning in delete operation Oracle 11g By: raj85844 on Tue, 31 January 2017	5	944	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	769	Fri, 03 February 2017 03:25 By: cookiemonster
constraint error 10g, win8.1, By: rzkhan on Tue, 31 January 2017	28	2097	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	807	Wed, 01 February 2017 08:00 By: Bill B
Procedure out of statements By: m_r_a on Wed, 01 February 2017	16	1257	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	878	Sun, 29 January 2017 07:55 By: Michel Cadot
cursor leak and open cursors Oracle12c By: shrinika on Thu, 26 January 2017	6	837	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	1216	Fri, 27 January 2017 04:31 By: Michel Cadot
Doubt in SYS_CONTEXT By: gajini on Tue, 24 January 2017	6	882	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	3219	Tue, 24 January 2017 13:28 By: Bill B
SQL Execution Plan Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: trivendra on Mon, 23 January 2017	4	887	Mon, 23 January 2017 13:18 By: trivendra
Edition Based Redefinition - Triggers on Editioning Views Oracle Database 11g Enterprise Edition 11.2.0.4.0 64 Bit Production, Linux By: fixxxer on Wed, 18 January 2017	7	1215	Mon, 23 January 2017 04:08 By: Michel Cadot
Oracle Outer join Operator(+) with operand of OR or IN Oracle, 11g, Windows 7 By: azamkhan on Mon, 23 January 2017	1	562	Mon, 23 January 2017 00:22 By: Michel Cadot
Effective Date/Min Eff Seq subquery issues PS Student Administration By: Lasmith76 on Sat, 21 January 2017	4	832	Sun, 22 January 2017 10:10 By: Lasmith76
How to create an object table By: janeya3110@gmail.com on Fri, 20 January 2017	5	1026	Sat, 21 January 2017 01:16 By: Michel Cadot
Remove null records from collection 11.2.0.4.0 By: pointers on Thu, 19 January 2017	1	779	Thu, 19 January 2017 09:59 By: Michel Cadot
Collections Oracle 11.2.0.0 By: pointers on Thu, 19 January 2017	9	1066	Thu, 19 January 2017 08:30 By: BlackSwan
unable to get data from V$SESSION table By: asliyanage on Wed, 18 January 2017	4	992	Thu, 19 January 2017 06:39 By: EdStevens
Help with REGEXP_SUBSTR Oracle 10g By: adfnewbie on Tue, 17 January 2017	6	1304	Tue, 17 January 2017 09:34 By: Bill B