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
AND & OR Condition Usage By: vharish006 on Tue, 07 February 2017	6	370	Wed, 08 February 2017 03:25 By: cookiemonster
DBLinks stopped after wrongly changing domain name in sqlnet.ora 11.0.2.10 By: OraFerro on Tue, 07 February 2017	6	274	Tue, 07 February 2017 03:47 By: OraFerro
Display only 10 charecters from column Oracle 11g Release 2 Linux By: anil_mk on Mon, 06 February 2017	12	452	Tue, 07 February 2017 07:07 By: Bill B
Writing multiple Files using UTL_FILE 11g, Windows XP By: siva27 on Mon, 06 February 2017	6	379	Mon, 06 February 2017 08:00 By: Michel Cadot
Full outer join with ZERO rows in Second table 10.2 By: bluetooth420 on Sat, 11 February 2017	11	481	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	1258	Sun, 12 February 2017 09:56 By: Bill B
Function To Reverese The Phone Number By: Hemanth319 on Sun, 05 February 2017	5	469	Mon, 06 February 2017 14:54 By: Bill B
Cursor Program To Find Tax Amount By: Hemanth319 on Sun, 05 February 2017	3	277	Mon, 06 February 2017 15:02 By: Bill B
order of operations in the below statements sql developer By: M123 on Thu, 02 February 2017	3	456	Fri, 03 February 2017 03:25 By: cookiemonster
Procedure out of statements By: m_r_a on Wed, 01 February 2017	16	393	Wed, 01 February 2017 03:29 By: cookiemonster
Performance tuning in delete operation Oracle 11g By: raj85844 on Tue, 31 January 2017	5	570	Fri, 03 February 2017 04:03 By: John Watson
Help with update statement Oracle 11g, 2, Solaris 11 By: apenkov on Tue, 31 January 2017	6	419	Wed, 01 February 2017 08:00 By: Bill B
constraint error 10g, win8.1, By: rzkhan on Tue, 31 January 2017	28	720	Wed, 01 February 2017 10:28 By: Michel Cadot
ORA-01722 for bind variable in dbms_sql Oracle 10g By: myadi26 on Sun, 29 January 2017	6	397	Sun, 29 January 2017 07:55 By: Michel Cadot
cursor leak and open cursors Oracle12c By: shrinika on Thu, 26 January 2017	6	389	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	568	Fri, 27 January 2017 04:31 By: Michel Cadot
Doubt in SYS_CONTEXT By: gajini on Tue, 24 January 2017	6	473	Fri, 27 January 2017 03:24 By: cookiemonster
SQL Execution Plan Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: trivendra on Mon, 23 January 2017	4	537	Mon, 23 January 2017 13:18 By: trivendra
ORA-14028 By: angro123 on Sun, 19 March 2017	5	515	Mon, 20 March 2017 09:08 By: cookiemonster
Effective Date/Min Eff Seq subquery issues PS Student Administration By: Lasmith76 on Sat, 21 January 2017	4	382	Sun, 22 January 2017 10:10 By: Lasmith76
How to create an object table By: janeya3110@gmail.com on Fri, 20 January 2017	5	605	Sat, 21 January 2017 01:16 By: Michel Cadot
Collections Oracle 11.2.0.0 By: pointers on Thu, 19 January 2017	9	582	Thu, 19 January 2017 08:30 By: BlackSwan
unable to get data from V$SESSION table By: asliyanage on Wed, 18 January 2017	4	604	Thu, 19 January 2017 06:39 By: EdStevens
How to identify one row from duplicate rows By: asliyanage on Wed, 18 January 2017	6	631	Tue, 14 February 2017 01:57 By: Michel Cadot
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 12c By: jaysorcale on Wed, 18 January 2017	14	2721	Sat, 25 February 2017 01:42 By: asliyanage
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	621	Mon, 23 January 2017 04:08 By: Michel Cadot
Help with REGEXP_SUBSTR Oracle 10g By: adfnewbie on Tue, 17 January 2017	6	776	Tue, 17 January 2017 09:34 By: Bill B
What is Unknown in logical operator By: asliyanage on Mon, 16 January 2017	4	711	Tue, 14 February 2017 01:53 By: Michel Cadot
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2 Enterprise Edition 10.2.0.4.0 - 64bit, Windows Server 2008 By: arfan_alam on Mon, 16 January 2017	9	793	Mon, 16 January 2017 09:14 By: Roachcoach
AUDSID temporary not found 12C (PDB) By: Gogetter on Mon, 16 January 2017	0	431	Mon, 16 January 2017 04:36 By: Gogetter
Remove null records from collection 11.2.0.4.0 By: pointers on Thu, 19 January 2017	1	509	Thu, 19 January 2017 09:59 By: Michel Cadot
Help to write the SQL query to Oracle DEveloper 11G By: nirmeshvats on Thu, 12 January 2017	3	539	Thu, 12 January 2017 12:52 By: John Watson
Regarding Hints Oracle 11g, Windows By: ninan on Thu, 12 January 2017	10	838	Mon, 16 January 2017 03:44 By: cookiemonster
add a sequential number to a query sql By: sanjuchand on Thu, 12 January 2017	3	477	Thu, 12 January 2017 07:57 By: Bill B
Compiling in Debug Mode Oracle 11g / SQL Developer By: Irish88 on Tue, 10 January 2017	19	822	Thu, 12 January 2017 07:23 By: Irish88
dependency question By: desmond30 on Tue, 10 January 2017	1	372	Tue, 10 January 2017 13:52 By: Michel Cadot
Recursive SQL Insert Oracle 11g By: Danny Freeman on Tue, 10 January 2017	2	410	Tue, 10 January 2017 14:05 By: Barbara Boehmer
scrambling the data for a column in a tables oracle 11g version 2 By: raj85844 on Mon, 09 January 2017	15	1177	Tue, 24 January 2017 13:28 By: Bill B
GROUP BY COST CENTER By: vharish006 on Mon, 09 January 2017	2	490	Mon, 09 January 2017 11:50 By: Michel Cadot
DBA_VIEWS giving ORA-00942 Error Oracle Database 12c 12.1.0.2.0 - 64bit Production By: abhi_orcl on Mon, 09 January 2017	3	745	Thu, 12 January 2017 08:01 By: Bill B