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 work around the substitution variables in plsql
Oracle 12c
By: mgag on Mon, 02 July 2018
3 4134 Tue, 17 July 2018 06:26
By: ajaychinna
  Generate New Excel format (XLSX) files using Oracle PLSQL
Oracle 11.2.0.4
By: nickz on Fri, 13 July 2018
3 6784 Mon, 16 July 2018 06:52
By: Bill B
  Need Help on Creating FUNCTION
By: vharish006 on Tue, 10 July 2018
13 5179 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 3717 Wed, 11 July 2018 03:38
By: flyboy
  rownum from table
By: suji6281 on Mon, 09 July 2018
7 3520 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 4909 Tue, 10 July 2018 05:30
By: fabi88
  Report query
Oracle 12CR2
By: srinivas.k2005 on Wed, 04 July 2018
10 4342 Mon, 09 July 2018 12:38
By: joy_division
  type of constraints
By: diana365 on Wed, 16 January 2002
4 3427 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 4611 Thu, 05 July 2018 07:51
By: achraf87
  Stored Procedure / Deletion Conflict
Oracle 12C
By: dba_vijay on Tue, 03 July 2018
13 4295 Thu, 05 July 2018 03:40
By: cookiemonster
  Help required on ranking logic
By: ramya29p on Mon, 02 July 2018
6 3428 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 6690 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 19612 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 4339 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 3286 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 3573 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 11834 Mon, 25 June 2018 14:05
By: nickz
  Difference between two dates
By: desmond30 on Tue, 19 June 2018
9 4104 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 5084 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 6413 Wed, 20 June 2018 02:06
By: nickz
  Help Grouping by
By: akull on Mon, 18 June 2018
6 3033 Mon, 18 June 2018 11:33
By: akull
  divide text string into different columns
By: suji6281 on Mon, 28 May 2018
10 4750 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 3496 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 4086 Mon, 18 June 2018 07:53
By: BlackSwan
  Commit Process
10g,WIndows 10
By: Satheeshkumar.P on Sun, 17 June 2018
2 2896 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 3819 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 2928 Wed, 13 June 2018 11:23
By: Michel Cadot
  USERENV, and OS_USER
By: desmond30 on Wed, 13 June 2018
3 2826 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 3148 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 4388 Wed, 06 June 2018 15:08
By: Bill B
  Multiple tables joining
By: suji6281 on Mon, 04 June 2018
5 3285 Mon, 04 June 2018 08:42
By: Michel Cadot
  does execute immediate create a new connection?
By: gunderj on Fri, 01 June 2018
2 2700 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 2710 Fri, 01 June 2018 09:35
By: John Watson
  Hierarchy problem
11.2.0.3
By: Amine on Mon, 28 May 2018
3 3019 Fri, 01 June 2018 00:43
By: Barbara Boehmer
  DB Port Error
Oracle 11 G, Suse Linux
By: chrisindya on Thu, 31 May 2018
4 2807 Thu, 31 May 2018 06:33
By: chrisindya
  cannot use UTL_SMTP on Windows 10 pro from machine at home
By: gunderj on Tue, 29 May 2018
7 3702 Thu, 31 May 2018 01:58
By: John Watson
  error while removing ' using regex
By: purnima1 on Thu, 24 May 2018
4 2884 Wed, 30 May 2018 12:33
By: Bill B
  wants to generate XML
oracle 9i
By: AyeshaSaad on Wed, 30 May 2018
2 2390 Wed, 30 May 2018 12:26
By: Bill B
  update huge table every n rows
oracle 12c
By: laredoeneko on Thu, 24 May 2018
10 3468 Tue, 29 May 2018 09:56
By: JPBoileau
  relational() function
DB12.2.0.1
By: John Watson on Mon, 28 May 2018
4 3019 Tue, 29 May 2018 08:29
By: cookiemonster
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: Wed Jan 29 01:23:42 CST 2020