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
Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	1	11002	Fri, 24 January 2020 03:56 By: cookiemonster
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	228206	Tue, 06 November 2018 14:17 By: Solomon Yakobson
Adding a from () to a query made it so slow 11.2.0.1.0 By: OraFerro on Mon, 06 April 2020	5	502	Wed, 08 April 2020 05:45 By: John Watson
Extracting specific portion of a string using REGEX Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professiona By: buggleboy007 on Mon, 06 April 2020	2	438	Mon, 06 April 2020 13:47 By: Michel Cadot
getting finacial week number oracle 11gr2 By: guddu_12 on Thu, 17 April 2014	15	8264	Sun, 05 April 2020 11:16 By: danielarias
How To Add Full Email Body Text from File to CLOB Column? Oracle 12c By: bmccollum on Wed, 01 April 2020	1	2028	Thu, 02 April 2020 00:11 By: Michel Cadot
Fill in records where date missing in sequence Oracle 12c, Querying with SQL Developer v3.2.20.10 By: sqlafterdark on Tue, 31 March 2020	1	1069	Tue, 31 March 2020 23:43 By: Michel Cadot
Alter Regex to validate email Domain on RFC 5322 from Java to Oracle sql Oracle 11g, windows 10 By: Nicha on Fri, 27 March 2020	2	3208	Mon, 30 March 2020 12:41 By: Nicha
Joined two tables on one row By: Gin min on Wed, 25 March 2020	9	3752	Thu, 26 March 2020 05:02 By: Michel Cadot
Cursored FOR loops, PLS-00103 compile error 12.1.0.2.0 By: thegerman on Sat, 21 March 2020	2	1784	Sun, 22 March 2020 18:27 By: thegerman
Moving sequences from one schema to other with the next value. 12c , Solaris 10 By: daulat01 on Wed, 18 March 2020	14	2213	Sat, 21 March 2020 06:34 By: Solomon Yakobson
XS entity with this name already exists. Oracle form 12c By: Shiv93 on Wed, 18 March 2020	7	1403	Thu, 19 March 2020 04:18 By: Shiv93
ORACLE :::Is there any other way to drop the column with out uncompression table in oracle database oracle 12c By: sivaraman.pvi@gmail.com on Thu, 12 March 2020	6	3363	Tue, 17 March 2020 12:41 By: Bill B
different rows in set of data (using lead or alternative) 11.2.0.1.0 By: OraFerro on Tue, 17 March 2020	3	798	Tue, 17 March 2020 04:20 By: OraFerro
Text to number conversion Oracle SQL Developer By: dorustd on Tue, 10 March 2020	14	2890	Thu, 12 March 2020 15:43 By: Michel Cadot
Import CSV data from CLOB Oracle 12c, Unix By: Rayam69 on Fri, 06 March 2020	32	6999	Wed, 11 March 2020 09:07 By: cookiemonster
log ORA-01013: user requested cancel of current operation tips 11g By: vioricamilea on Wed, 22 June 2011	20	13294	Wed, 11 March 2020 08:58 By: shthed@gmail.com
ORA-02069 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 By: s4.ora on Tue, 10 March 2020	2	1049	Wed, 11 March 2020 08:34 By: s4.ora
Locking issue while MATERIALIZED VIEW REFRESH PL/SQL Release 12.1.0.2.0 By: Manoj.Gupta.91 on Fri, 06 March 2020	6	4192	Wed, 11 March 2020 07:28 By: Bill B
MATERIALIZED VIEW REFRESH HISTORY Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: Manoj.Gupta.91 on Tue, 10 March 2020	1	953	Wed, 11 March 2020 07:18 By: Bill B
multiple inserts without Loops By: ghostman on Tue, 10 March 2020	2	661	Tue, 10 March 2020 06:10 By: _jum
Analytic Function: How to Partition Hierarchical Data By: whdyck on Mon, 09 March 2020	1	338	Mon, 09 March 2020 13:03 By: Michel Cadot
exit when cursor%notfound is giving buffer overflow if not being used in anonymous block (merged) By: sfksuperman on Tue, 03 March 2020	18	3334	Thu, 05 March 2020 10:19 By: Michel Cadot
Select statement inside IF statement for comparing a given string with records in table By: sfksuperman on Fri, 28 February 2020	27	4275	Tue, 03 March 2020 02:43 By: cookiemonster
convert rows to column in SQL 12C By: NeetuMishraIsBack on Fri, 28 February 2020	1	2636	Sat, 29 February 2020 00:58 By: Michel Cadot
embedded implicit cursors in SQL Oracle, Win 10 By: Calvin_007 on Fri, 28 February 2020	1	2574	Sat, 29 February 2020 00:54 By: Michel Cadot
query-assistance Oracle 11g By: winfire on Fri, 28 February 2020	4	2562	Fri, 28 February 2020 08:26 By: winfire
Time Between Consecutive Locations Oracle 12c By: run400 on Mon, 24 February 2020	4	2231	Fri, 28 February 2020 03:21 By: _jum
Oracle 11g Sequence(merged) 11g By: moyida on Thu, 27 February 2020	7	1071	Thu, 27 February 2020 12:27 By: Bill B
How to Fetch merged rows back ! By: ramya29p on Thu, 27 February 2020	2	591	Thu, 27 February 2020 05:21 By: ramya29p
regexp_replace (merged 2) By: akarra on Wed, 26 February 2020	8	946	Wed, 26 February 2020 15:04 By: akarra
Get (and lock) first unlocked row?! By: emirc on Mon, 16 May 2005	8	14815	Wed, 26 February 2020 06:54 By: EdStevens
Single update to get one column value using another column value Oracle 12c By: sss111ind on Tue, 25 February 2020	12	1000	Tue, 25 February 2020 07:44 By: sss111ind
Return defined column size of varchar and varchar2 data types By: jdbeyler on Fri, 21 February 2020	3	3359	Mon, 24 February 2020 05:55 By: Bill B
Tab Delimited Oracle Database 11g -Oracle JDBC driver- Linux By: enriquemans on Fri, 21 February 2020	3	3175	Sat, 22 February 2020 08:31 By: EdStevens
Start Transactional Control in PL/SQL Oracle Database By: aks11 on Wed, 19 February 2020	6	2498	Fri, 21 February 2020 12:06 By: Bill B
PLSQL: Execute Immediate is not working as expected in PLSQL anonymous block. By: msyogi on Thu, 20 February 2020	4	1550	Thu, 20 February 2020 11:12 By: Michel Cadot
How to export multiple blob and character data into a text file? PL/SQL By: Ethan Caleb on Tue, 18 February 2020	3	1639	Tue, 18 February 2020 21:32 By: BlackSwan
How To Show Non Matching rows in oracle Oracle 11G By: ssyr on Sun, 16 February 2020	3	1121	Mon, 17 February 2020 07:10 By: Bill B
AS_XLSX. how to set worksheet name By: calacausi on Mon, 17 February 2020	4	1149	Mon, 17 February 2020 07:08 By: Bill B