Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Create a Job to run Oracle Package stored procedure
11.0.2.10
By: OraFerro on Wed, 15 February 2017
4 1104 Wed, 15 February 2017 23:05
By: OraFerro
  Oracle BLOB DATA
ORACLE,PLSQL
By: bkumar on Wed, 15 February 2017
5 719 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 1041 Wed, 15 February 2017 10:36
By: abhi_orcl
  Problem while using AUTHID CURRENT_USER
By: amit.sonar on Fri, 10 February 2017
4 871 Wed, 15 February 2017 09:26
By: cookiemonster
  natural join change table
By: asliyanage on Mon, 13 February 2017
7 940 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 664 Tue, 14 February 2017 13:49
By: pointers
  How to identify one row from duplicate rows
By: asliyanage on Wed, 18 January 2017
6 1191 Tue, 14 February 2017 01:57
By: Michel Cadot
  What is Unknown in logical operator
By: asliyanage on Mon, 16 January 2017
4 1265 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 5565 Tue, 14 February 2017 00:16
By: grpatwari
  Counting minutes in a date/time range
By: dale2k9 on Tue, 07 February 2017
12 1808 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 1231 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 4167 Sun, 12 February 2017 09:56
By: Bill B
  WHERE Clause With A Range
By: jmltinc on Tue, 07 February 2017
18 2224 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 832 Wed, 08 February 2017 08:54
By: fabi88
  AND & OR Condition Usage
By: vharish006 on Tue, 07 February 2017
6 1025 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 1683 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 901 Tue, 07 February 2017 03:47
By: OraFerro
icon4.gif Cursor Program To Find Tax Amount
By: Hemanth319 on Sun, 05 February 2017
3 747 Mon, 06 February 2017 15:02
By: Bill B
  Function To Reverese The Phone Number
By: Hemanth319 on Sun, 05 February 2017
5 1107 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 993 Mon, 06 February 2017 08:00
By: Michel Cadot
  Performance tuning in delete operation
Oracle 11g
By: raj85844 on Tue, 31 January 2017
5 1103 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 897 Fri, 03 February 2017 03:25
By: cookiemonster
  constraint error
10g, win8.1,
By: rzkhan on Tue, 31 January 2017
28 2907 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 976 Wed, 01 February 2017 08:00
By: Bill B
  Procedure out of statements
By: m_r_a on Wed, 01 February 2017
16 1744 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 1125 Sun, 29 January 2017 07:55
By: Michel Cadot
  cursor leak and open cursors
Oracle12c
By: shrinika on Thu, 26 January 2017
6 988 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 1477 Fri, 27 January 2017 04:31
By: Michel Cadot
  Doubt in SYS_CONTEXT
By: gajini on Tue, 24 January 2017
6 1051 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 4371 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 1035 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 1471 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 670 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 1001 Sun, 22 January 2017 10:10
By: Lasmith76
  How to create an object table
By: janeya3110@gmail.com on Fri, 20 January 2017
5 1177 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 909 Thu, 19 January 2017 09:59
By: Michel Cadot
  Collections
Oracle 11.2.0.0
By: pointers on Thu, 19 January 2017
9 1282 Thu, 19 January 2017 08:30
By: BlackSwan
  unable to get data from V$SESSION table
By: asliyanage on Wed, 18 January 2017
4 1198 Thu, 19 January 2017 06:39
By: EdStevens
  Help with REGEXP_SUBSTR
Oracle 10g
By: adfnewbie on Tue, 17 January 2017
6 1575 Tue, 17 January 2017 09:34
By: Bill B
  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 1692 Mon, 16 January 2017 09:14
By: Roachcoach
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Tue Sep 25 20:36:30 CDT 2018