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
  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 5388 Mon, 18 June 2018 07:53
By: BlackSwan
  Commit Process
10g,WIndows 10
By: Satheeshkumar.P on Sun, 17 June 2018
2 3310 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 4324 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 3382 Wed, 13 June 2018 11:23
By: Michel Cadot
  USERENV, and OS_USER
By: desmond30 on Wed, 13 June 2018
3 3275 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 3572 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 4697 Wed, 06 June 2018 15:08
By: Bill B
  Multiple tables joining
By: suji6281 on Mon, 04 June 2018
5 3785 Mon, 04 June 2018 08:42
By: Michel Cadot
  does execute immediate create a new connection?
By: gunderj on Fri, 01 June 2018
2 3110 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 3019 Fri, 01 June 2018 09:35
By: John Watson
  Hierarchy problem
11.2.0.3
By: Amine on Mon, 28 May 2018
3 3442 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 3212 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 4187 Thu, 31 May 2018 01:58
By: John Watson
  error while removing ' using regex
By: purnima1 on Thu, 24 May 2018
4 3239 Wed, 30 May 2018 12:33
By: Bill B
  wants to generate XML
oracle 9i
By: AyeshaSaad on Wed, 30 May 2018
2 2764 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 3901 Tue, 29 May 2018 09:56
By: JPBoileau
  relational() function
DB12.2.0.1
By: John Watson on Mon, 28 May 2018
4 3557 Tue, 29 May 2018 08:29
By: cookiemonster
  duplicate part of text message
By: suji6281 on Sun, 27 May 2018
6 3200 Mon, 28 May 2018 13:45
By: suji6281
  Alternative Sql Query
By: nagaraju.ch on Sat, 26 May 2018
7 3271 Sun, 27 May 2018 15:10
By: John Watson
  Adding up graphs
By: Buchas on Fri, 18 May 2018
5 3410 Thu, 24 May 2018 14:22
By: Barbara Boehmer
  Find substr after nth occurance of spce
By: purnima1 on Tue, 22 May 2018
4 2975 Thu, 24 May 2018 05:38
By: Michel Cadot
icon5.gif Insert values from different tables in a single statement
By: caiz on Wed, 23 May 2018
5 3374 Thu, 24 May 2018 04:33
By: Michel Cadot
  connect by prior performance issue
By: uman2631 on Fri, 18 May 2018
4 3150 Wed, 23 May 2018 09:13
By: uman2631
  How to implement regex (merged 2)
By: purnima1 on Mon, 21 May 2018
6 3377 Wed, 23 May 2018 08:17
By: Michel Cadot
  Oracle Role creation on Schema
By: ramya29p on Mon, 14 May 2018
6 3816 Wed, 23 May 2018 01:46
By: Barbara Boehmer
  Help required for adding patition by range in table
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: msol25 on Mon, 21 May 2018
4 2936 Mon, 21 May 2018 02:05
By: msol25
  Procedure
Oracle 12C
By: sravanakumari on Wed, 16 May 2018
2 2873 Wed, 16 May 2018 07:14
By: BlackSwan
  How to set the earliest date
By: KavitaSSwami on Mon, 14 May 2018
6 3521 Mon, 14 May 2018 15:22
By: BlackSwan
  Query to find common column in more then two tables
By: KavitaSSwami on Fri, 04 May 2018
13 8841 Mon, 14 May 2018 12:01
By: BlackSwan
  SELECT WITH TIMESTAMP AND SYSDATE
ORACLE 12
By: cruizji on Sun, 13 May 2018
3 3406 Mon, 14 May 2018 08:10
By: Bill B
  Bulk collect for inserting million of records
Oracle 11.2,Linux 6
By: senmng on Sun, 06 May 2018
11 5652 Fri, 11 May 2018 09:10
By: cookiemonster
  Outer Join Question
By: elmousa68 on Fri, 11 May 2018
3 2985 Fri, 11 May 2018 07:59
By: Michel Cadot
  FORALL Bulk insert using variable
Oracle 12.1.0, Sun OS 5.11
By: Renovator on Tue, 08 May 2018
5 4543 Thu, 10 May 2018 19:54
By: Barbara Boehmer
  Main Stored procedure to execute multiple procedures
Oracle 11.2,Linux
By: senmng on Mon, 16 April 2018
16 8654 Mon, 07 May 2018 05:52
By: cookiemonster
  Format a String with Decimal Point using REGEXP_REPLACE
[Oracle Database 11G, UNIX Solaris]
By: Betaroot on Wed, 02 May 2018
2 2758 Thu, 03 May 2018 10:01
By: Betaroot
  SQL statement with averages
By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018
3 3502 Thu, 03 May 2018 02:19
By: quirks
  Stored procedure to load initial bulk load from one DB to another DB
Oracle 11.2,Linux 6
By: senmng on Wed, 02 May 2018
1 2214 Wed, 02 May 2018 14:44
By: BlackSwan
  Rollup master row
11.0.2.10
By: OraFerro on Tue, 01 May 2018
4 3061 Tue, 01 May 2018 23:39
By: OraFerro
  how to use variable to store comma seperated values
11G
By: satya_ora on Tue, 27 March 2018
10 5179 Mon, 30 April 2018 15:46
By: joy_division
  roles granted to a role
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: wtolentino on Thu, 26 April 2018
9 4488 Sat, 28 April 2018 15:55
By: EdStevens
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 29 16:45:01 CDT 2020