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
Loading techniques By: Vijayarajan51 on Tue, 21 February 2017	3	1749	Tue, 21 February 2017 10:10 By: Vijayarajan51
unique result Oracle 11g By: rahul1982 on Tue, 21 February 2017	2	1679	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	2761	Mon, 20 February 2017 07:49 By: Michel Cadot
Synonym switching oracle 11g release 2 By: raj85844 on Thu, 16 February 2017	5	4616	Thu, 16 February 2017 16:50 By: Caffeine+
cumulative sum & product oracle 11g release 2 By: varada on Wed, 15 February 2017	18	7188	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	4201	Wed, 15 February 2017 23:05 By: OraFerro
Oracle BLOB DATA ORACLE,PLSQL By: bkumar on Wed, 15 February 2017	5	2382	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	2969	Wed, 15 February 2017 10:36 By: abhi_orcl
Problem while using AUTHID CURRENT_USER By: amit.sonar on Fri, 10 February 2017	4	2959	Wed, 15 February 2017 09:26 By: cookiemonster
natural join change table By: asliyanage on Mon, 13 February 2017	7	2695	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	1773	Tue, 14 February 2017 13:49 By: pointers
How to identify one row from duplicate rows By: asliyanage on Wed, 18 January 2017	6	2467	Tue, 14 February 2017 01:57 By: Michel Cadot
What is Unknown in logical operator By: asliyanage on Mon, 16 January 2017	4	2303	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	13171	Tue, 14 February 2017 00:16 By: grpatwari
Counting minutes in a date/time range By: dale2k9 on Tue, 07 February 2017	12	4452	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	3695	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	17793	Sun, 12 February 2017 09:56 By: Bill B
WHERE Clause With A Range By: jmltinc on Tue, 07 February 2017	18	6122	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	2047	Wed, 08 February 2017 08:54 By: fabi88
AND & OR Condition Usage By: vharish006 on Tue, 07 February 2017	6	2373	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	3836	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	2211	Tue, 07 February 2017 03:47 By: OraFerro
Cursor Program To Find Tax Amount By: Hemanth319 on Sun, 05 February 2017	3	2166	Mon, 06 February 2017 15:02 By: Bill B
Function To Reverese The Phone Number By: Hemanth319 on Sun, 05 February 2017	5	2529	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	2529	Mon, 06 February 2017 08:00 By: Michel Cadot
Performance tuning in delete operation Oracle 11g By: raj85844 on Tue, 31 January 2017	5	2353	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	2236	Fri, 03 February 2017 03:25 By: cookiemonster
constraint error 10g, win8.1, By: rzkhan on Tue, 31 January 2017	28	7326	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	2420	Wed, 01 February 2017 08:00 By: Bill B
Procedure out of statements By: m_r_a on Wed, 01 February 2017	16	3922	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	3155	Sun, 29 January 2017 07:55 By: Michel Cadot
cursor leak and open cursors Oracle12c By: shrinika on Thu, 26 January 2017	6	2088	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	3923	Fri, 27 January 2017 04:31 By: Michel Cadot
Doubt in SYS_CONTEXT By: gajini on Tue, 24 January 2017	6	2603	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	17373	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	2384	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	3376	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	1582	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	2861	Sun, 22 January 2017 10:10 By: Lasmith76
How to create an object table By: janeya3110@gmail.com on Fri, 20 January 2017	5	2549	Sat, 21 January 2017 01:16 By: Michel Cadot