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
  How to ensure uniqueness on RAISE_APPLICATION_ERROR
By: ramya29p on Mon, 23 July 2018
1 18 Mon, 23 July 2018 00:36
By: Michel Cadot
  Oracle materialized views workflow
By: camillelola on Fri, 20 July 2018
3 415 Fri, 20 July 2018 13:19
By: Lalit Kumar B
  ORA-04091: table Table_Name is mutating, trigger/function may not see it
Oracle 11g With Apex 5.1
By: Mukul Ahmed on Fri, 13 July 2018
7 1200 Fri, 20 July 2018 04:16
By: elmomagalona
icon1.gif Get last record from another table
11g
By: ritaman on Mon, 16 July 2018
17 2091 Wed, 18 July 2018 05:26
By: cookiemonster
  Need Help on Pl/Sql
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 17 July 2018
11 875 Tue, 17 July 2018 12:19
By: Lalit Kumar B
  query performance
11g
By: annu-agi on Sat, 14 July 2018
3 2059 Tue, 17 July 2018 06:29
By: Bill B
  how to work around the substitution variables in plsql
Oracle 12c
By: mgag on Mon, 02 July 2018
3 1615 Tue, 17 July 2018 06:26
By: ajaychinna
  Possibility of Name
Oracle 11G
By: Genesys on Mon, 16 July 2018
6 2481 Tue, 17 July 2018 03:18
By: leroyb_edi
  Generate New Excel format (XLSX) files using Oracle PLSQL
Oracle 11.2.0.4
By: nickz on Fri, 13 July 2018
3 2417 Mon, 16 July 2018 06:52
By: Bill B
  Need Help on Creating FUNCTION
By: vharish006 on Tue, 10 July 2018
13 2021 Wed, 11 July 2018 03:43
By: cookiemonster
  SELECT QUERY
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 10 July 2018
6 1584 Wed, 11 July 2018 03:38
By: flyboy
  rownum from table
By: suji6281 on Mon, 09 July 2018
7 1498 Tue, 10 July 2018 06:06
By: Bill B
  How can bulk insert into the parent , child tables
Oracle Linux 6.7, Oracle 12.1.0.2.0
By: fabi88 on Sun, 08 July 2018
10 1922 Tue, 10 July 2018 05:30
By: fabi88
  Report query
Oracle 12CR2
By: srinivas.k2005 on Wed, 04 July 2018
10 1768 Mon, 09 July 2018 12:38
By: joy_division
  type of constraints
By: diana365 on Wed, 16 January 2002
4 1212 Mon, 09 July 2018 07:41
By: Bill B
  problem with concatenation and group by functions
11g
By: achraf87 on Wed, 04 July 2018
11 1458 Thu, 05 July 2018 07:51
By: achraf87
  Stored Procedure / Deletion Conflict
Oracle 12C
By: dba_vijay on Tue, 03 July 2018
13 1438 Thu, 05 July 2018 03:40
By: cookiemonster
  Help required on ranking logic
By: ramya29p on Mon, 02 July 2018
6 1023 Tue, 03 July 2018 23:11
By: ramya29p
  How to get decimal value from string and convert
11g
By: tikun on Thu, 28 June 2018
18 1962 Tue, 03 July 2018 06:19
By: Bill B
  Extract domain name from email address field
PS/SQL
By: heidibb on Tue, 29 November 2011
19 11451 Tue, 03 July 2018 06:15
By: Bill B
  Select using DBMS_SQL.EXECUTE (merged)
Oracle Linux 6.7, Oracle 12.1.0.2.0
By: fabi88 on Mon, 02 July 2018
6 1506 Mon, 02 July 2018 04:07
By: Michel Cadot
  Alter Table <<table name>> add partition by range does not work
Oracle 11g
By: manikandan23 on Thu, 28 June 2018
4 1167 Fri, 29 June 2018 06:52
By: Bill B
  How to replace the new line and line feed in a specific manner
oracle 11g
By: POGAKU_SANTHOSH on Wed, 20 June 2018
5 1485 Thu, 28 June 2018 01:43
By: POGAKU_SANTHOSH
  Fetching Unix Folder Name and Timestamp in SQL/PLSQL
Oracle 11.2.0.4
By: nickz on Fri, 08 June 2018
26 3951 Mon, 25 June 2018 14:05
By: nickz
  Difference between two dates
By: desmond30 on Tue, 19 June 2018
9 1740 Mon, 25 June 2018 06:48
By: Bill B
  Compare current and previous record
Oracle 10 g
By: Danny Freeman on Fri, 15 June 2018
13 1749 Wed, 20 June 2018 11:50
By: Bill B
icon5.gif SQL: Substring folder name based on numeric value
Oracle DB 11.2.0.4
By: nickz on Thu, 14 June 2018
11 2451 Wed, 20 June 2018 02:06
By: nickz
  Help Grouping by
By: akull on Mon, 18 June 2018
6 979 Mon, 18 June 2018 11:33
By: akull
  divide text string into different columns
By: suji6281 on Mon, 28 May 2018
10 1911 Mon, 18 June 2018 10:33
By: suji6281
  problem of inserting a long string of characters :ORA-22835: Taille de tampon insuffisante pour la c
11g
By: achraf87 on Mon, 18 June 2018
2 938 Mon, 18 June 2018 08:53
By: cookiemonster
  Use multi-threading in PL/SQL
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Manoj.Gupta.91 on Mon, 18 June 2018
1 989 Mon, 18 June 2018 07:53
By: BlackSwan
  Commit Process
10g,WIndows 10
By: Satheeshkumar.P on Sun, 17 June 2018
2 1152 Mon, 18 June 2018 04:29
By: gazzag
  oracle large query text
11gr2 on rhel (11.2.0.4.0)
By: dba4oracle on Mon, 11 June 2018
9 1470 Wed, 13 June 2018 18:01
By: ramd2530
  How To display last day of a century
Oracle 11g
By: narendraenamala on Wed, 13 June 2018
3 1127 Wed, 13 June 2018 11:23
By: Michel Cadot
  USERENV, and OS_USER
By: desmond30 on Wed, 13 June 2018
3 1228 Wed, 13 June 2018 11:09
By: Solomon Yakobson
  How to restrict IN parameter length in Procedure
Oracle 11g DB, Windows 7
By: bala.b@outlook.com on Tue, 12 June 2018
5 1214 Wed, 13 June 2018 02:04
By: bala.b@outlook.com
  Want to execute 900 query's, is there any faster way to execute
Oracle SQL Developer
By: KavitaSSwami on Mon, 04 June 2018
9 1630 Wed, 06 June 2018 15:08
By: Bill B
  Multiple tables joining
By: suji6281 on Mon, 04 June 2018
5 1206 Mon, 04 June 2018 08:42
By: Michel Cadot
  does execute immediate create a new connection?
By: gunderj on Fri, 01 June 2018
2 1005 Fri, 01 June 2018 13:48
By: Michel Cadot
  Oracle.ucp.jdbc.HarvestableConnection error
Oracle 11G Suse Linux
By: chrisindya on Fri, 01 June 2018
1 1127 Fri, 01 June 2018 09:35
By: John Watson
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: Mon Jul 23 01:09:35 CDT 2018