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

Topic	Replies	Views	Last message
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	42	180987	Fri, 01 June 2018 02:00 By: quickbookssupport
sticky: How to use code tags and make your code easier to read By: Littlefoot on Mon, 05 September 2011	0	10237	Mon, 05 September 2011 02:20 By: Littlefoot
Fetching Unix Folder Name and Timestamp in SQL/PLSQL Oracle 11.2.0.4 By: nickz on Fri, 08 June 2018	25	2212	Wed, 20 June 2018 13:08 By: Solomon Yakobson
Difference between two dates By: desmond30 on Tue, 19 June 2018	8	468	Wed, 20 June 2018 12:05 By: Michel Cadot
Compare current and previous record Oracle 10 g By: Danny Freeman on Fri, 15 June 2018	13	801	Wed, 20 June 2018 11:50 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	4	582	Wed, 20 June 2018 06:46 By: Solomon Yakobson
SQL: Substring folder name based on numeric value Oracle DB 11.2.0.4 By: nickz on Thu, 14 June 2018	11	1636	Wed, 20 June 2018 02:06 By: nickz
Help Grouping by By: akull on Mon, 18 June 2018	6	450	Mon, 18 June 2018 11:33 By: akull
divide text string into different columns By: suji6281 on Mon, 28 May 2018	10	1229	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	430	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	491	Mon, 18 June 2018 07:53 By: BlackSwan
Commit Process 10g,WIndows 10 By: Satheeshkumar.P on Sun, 17 June 2018	2	615	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	780	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	511	Wed, 13 June 2018 11:23 By: Michel Cadot
USERENV, and OS_USER By: desmond30 on Wed, 13 June 2018	3	620	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	589	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	947	Wed, 06 June 2018 15:08 By: Bill B
Multiple tables joining By: suji6281 on Mon, 04 June 2018	5	585	Mon, 04 June 2018 08:42 By: Michel Cadot
does execute immediate create a new connection? By: gunderj on Fri, 01 June 2018	2	422	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	539	Fri, 01 June 2018 09:35 By: John Watson
Hierarchy problem 11.2.0.3 By: Amine on Mon, 28 May 2018	3	642	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	600	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	874	Thu, 31 May 2018 01:58 By: John Watson
error while removing ' using regex By: purnima1 on Thu, 24 May 2018	4	544	Wed, 30 May 2018 12:33 By: Bill B
wants to generate XML oracle 9i By: AyeshaSaad on Wed, 30 May 2018	2	515	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	804	Tue, 29 May 2018 09:56 By: JPBoileau
relational() function DB12.2.0.1 By: John Watson on Mon, 28 May 2018	4	673	Tue, 29 May 2018 08:29 By: cookiemonster
duplicate part of text message By: suji6281 on Sun, 27 May 2018	6	644	Mon, 28 May 2018 13:45 By: suji6281
Alternative Sql Query By: nagaraju.ch on Sat, 26 May 2018	7	622	Sun, 27 May 2018 15:10 By: John Watson
Adding up graphs By: Buchas on Fri, 18 May 2018	5	693	Thu, 24 May 2018 14:22 By: Barbara Boehmer
Find substr after nth occurance of spce By: purnima1 on Tue, 22 May 2018	4	461	Thu, 24 May 2018 05:38 By: Michel Cadot
Insert values from different tables in a single statement By: caiz on Wed, 23 May 2018	5	434	Thu, 24 May 2018 04:33 By: Michel Cadot
connect by prior performance issue By: uman2631 on Fri, 18 May 2018	4	680	Wed, 23 May 2018 09:13 By: uman2631
How to implement regex (merged 2) By: purnima1 on Mon, 21 May 2018	6	564	Wed, 23 May 2018 08:17 By: Michel Cadot
Oracle Role creation on Schema By: ramya29p on Mon, 14 May 2018	6	875	Wed, 23 May 2018 01:46 By: Barbara Boehmer
Duplicating Excel "RATE" function in Oracle Oracle 11.2 By: Primordial on Wed, 18 February 2015	5	4152	Mon, 21 May 2018 10:52 By: PHILLIPM.33
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	419	Mon, 21 May 2018 02:05 By: msol25
Materialised Views - FAST Refresh Oracle 11g By: chat2raj.s on Wed, 16 May 2018	8	1070	Thu, 17 May 2018 02:18 By: chat2raj.s
Procedure Oracle 12C By: sravanakumari on Wed, 16 May 2018	2	732	Wed, 16 May 2018 07:14 By: BlackSwan
How to set the earliest date By: KavitaSSwami on Mon, 14 May 2018	6	577	Mon, 14 May 2018 15:22 By: BlackSwan