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 :: Polls :: Message Navigator

Topic	Replies	Views	Last message
how to work around the substitution variables in plsql Oracle 12c By: mgag on Mon, 02 July 2018	3	6523	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	15719	Mon, 16 July 2018 06:52 By: Bill B
Need Help on Creating FUNCTION By: vharish006 on Tue, 10 July 2018	13	8966	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	6528	Wed, 11 July 2018 03:38 By: flyboy
rownum from table By: suji6281 on Mon, 09 July 2018	7	6694	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	10585	Tue, 10 July 2018 05:30 By: fabi88
Report query Oracle 12CR2 By: srinivas.k2005 on Wed, 04 July 2018	10	8363	Mon, 09 July 2018 12:38 By: joy_division
type of constraints By: diana365 on Wed, 16 January 2002	4	5620	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	8199	Thu, 05 July 2018 07:51 By: achraf87
Stored Procedure / Deletion Conflict Oracle 12C By: dba_vijay on Tue, 03 July 2018	13	7548	Thu, 05 July 2018 03:40 By: cookiemonster
Help required on ranking logic By: ramya29p on Mon, 02 July 2018	6	5854	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	10873	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	30618	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	7352	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	7284	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	8366	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	17549	Mon, 25 June 2018 14:05 By: nickz
Difference between two dates By: desmond30 on Tue, 19 June 2018	9	6941	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	10921	Wed, 20 June 2018 11:50 By: Bill B
SQL: Substring folder name based on numeric value Oracle DB 11.2.0.4 By: nickz on Thu, 14 June 2018	11	9398	Wed, 20 June 2018 02:06 By: nickz
Help Grouping by By: akull on Mon, 18 June 2018	6	5407	Mon, 18 June 2018 11:33 By: akull
divide text string into different columns By: suji6281 on Mon, 28 May 2018	10	8612	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	6125	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	10836	Mon, 18 June 2018 07:53 By: BlackSwan
Commit Process 10g,WIndows 10 By: Satheeshkumar.P on Sun, 17 June 2018	2	4709	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	6656	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	5029	Wed, 13 June 2018 11:23 By: Michel Cadot
USERENV, and OS_USER By: desmond30 on Wed, 13 June 2018	3	4762	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	5306	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	6350	Wed, 06 June 2018 15:08 By: Bill B
Multiple tables joining By: suji6281 on Mon, 04 June 2018	5	4965	Mon, 04 June 2018 08:42 By: Michel Cadot
does execute immediate create a new connection? By: gunderj on Fri, 01 June 2018	2	4711	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	4042	Fri, 01 June 2018 09:35 By: John Watson
Hierarchy problem 11.2.0.3 By: Amine on Mon, 28 May 2018	3	5220	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	4639	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	6242	Thu, 31 May 2018 01:58 By: John Watson
error while removing ' using regex By: purnima1 on Thu, 24 May 2018	4	4675	Wed, 30 May 2018 12:33 By: Bill B
wants to generate XML oracle 9i By: AyeshaSaad on Wed, 30 May 2018	2	3907	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	6149	Tue, 29 May 2018 09:56 By: JPBoileau
relational() function DB12.2.0.1 By: John Watson on Mon, 28 May 2018	4	5562	Tue, 29 May 2018 08:29 By: cookiemonster