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
convert rows to column in SQL 12C By: NeetuMishraIsBack on Fri, 28 February 2020	1	2837	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	2754	Sat, 29 February 2020 00:54 By: Michel Cadot
query-assistance Oracle 11g By: winfire on Fri, 28 February 2020	4	2776	Fri, 28 February 2020 08:26 By: winfire
Time Between Consecutive Locations Oracle 12c By: run400 on Mon, 24 February 2020	4	2441	Fri, 28 February 2020 03:21 By: _jum
Oracle 11g Sequence(merged) 11g By: moyida on Thu, 27 February 2020	7	1292	Thu, 27 February 2020 12:27 By: Bill B
How to Fetch merged rows back ! By: ramya29p on Thu, 27 February 2020	2	752	Thu, 27 February 2020 05:21 By: ramya29p
regexp_replace (merged 2) By: akarra on Wed, 26 February 2020	8	1207	Wed, 26 February 2020 15:04 By: akarra
Get (and lock) first unlocked row?! By: emirc on Mon, 16 May 2005	8	15197	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	1235	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	3514	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	3349	Sat, 22 February 2020 08:31 By: EdStevens
Start Transactional Control in PL/SQL Oracle Database By: aks11 on Wed, 19 February 2020	6	2698	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	1668	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	1799	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	1259	Mon, 17 February 2020 07:10 By: Bill B
AS_XLSX. how to set worksheet name By: calacausi on Mon, 17 February 2020	4	1323	Mon, 17 February 2020 07:08 By: Bill B
test failed: ORA-01017 invalid username / password access denied By: syed.javid.ali.ali@gmail. on Sun, 16 February 2020	5	986	Sun, 16 February 2020 14:56 By: EdStevens
ORA-02085 database link AZZRE.CG44.FR connects to GZWR2.ZZ44.FR Oracle 12.2, SLES12 SP3 By: Mat44 on Wed, 12 February 2020	8	2333	Thu, 13 February 2020 07:24 By: Solomon Yakobson
ORA-20200: ORA-0000: normal, successful completion when executing PCRD_DF_MANAGEMENT.DF_MANAGE ORA By: shilpanarayan94 on Wed, 12 February 2020	3	1592	Wed, 12 February 2020 08:58 By: Michel Cadot
Simultaneous DML executions on different objects in the same session 11g and higher, any OS By: Olexandr Siroklyn on Tue, 28 January 2020	12	3811	Mon, 10 February 2020 10:38 By: Olexandr Siroklyn
Previous week's first and last day Oracle 12 By: asagpariya on Thu, 06 February 2020	6	3722	Sat, 08 February 2020 10:35 By: Bill B
Combining multiple regexp_like statements & correct regex syntax By: mgarret40 on Mon, 03 February 2020	4	2589	Wed, 05 February 2020 01:25 By: Michel Cadot
Delete statement to retain last 90 days of data Oracle SQL IDE 4.0.3.16 Win2k8 Server By: Jay76 on Fri, 31 January 2020	11	3082	Mon, 03 February 2020 06:03 By: Bill B
ORA-12801: error signaled in parallel query server PXXX (merged 3) oracle ,12c By: jgjeetu on Fri, 31 January 2020	12	3412	Mon, 03 February 2020 00:19 By: jgjeetu
Calling webservice from plsql package (merged) Oracle12c By: Shiv93 on Sun, 05 January 2020	5	6343	Fri, 31 January 2020 00:44 By: Shiv93
How to download a BLOB field data to local storage (merged) Oracle form 12c RDS By: Shiv93 on Thu, 30 January 2020	2	1064	Thu, 30 January 2020 04:08 By: John Watson
DB link issue in cloned databases on same host 11.1.0.7.0 By: aloksk on Tue, 28 January 2020	7	2780	Tue, 28 January 2020 23:50 By: aloksk
Writing from Ref cursor to UTIL file Oracle 11g By: Samhita_Varma on Mon, 27 January 2020	2	2725	Mon, 27 January 2020 09:56 By: Michel Cadot
Design Question 12c ( 1 2) By: ora9a on Fri, 26 April 2019	43	8032	Sat, 25 January 2020 02:35 By: Michel Cadot
Looping through dblinks with a cursor Oracle 12.2.0.1, RHEL 6.10 By: scoogie1973 on Thu, 23 January 2020	9	1774	Fri, 24 January 2020 01:45 By: John Watson
XMLQUERY: ORA-01427: single-row subquery returns more than one row oracle 12g By: shobhakashyapgmailcom on Sun, 19 January 2020	4	2117	Wed, 22 January 2020 23:38 By: shobhakashyapgmailcom
Query on Oracle JVM Oracle 11g By: IshwaryaMurali on Tue, 21 January 2020	4	1863	Wed, 22 January 2020 04:51 By: IshwaryaMurali
ORA-00604 & ORA-28003 - Even when not trying to change password oracle 11g By: IshwaryaMurali on Fri, 17 January 2020	7	2255	Tue, 21 January 2020 00:39 By: Michel Cadot
Hierarchy Queries By: msinha8 on Mon, 23 December 2019	16	6542	Fri, 10 January 2020 10:22 By: msinha8
DML operation on a table 12C By: deepakdot on Fri, 10 January 2020	2	2588	Fri, 10 January 2020 05:12 By: deepakdot
ORA-03001 while using bulk collect By: shanthkumaar on Fri, 16 March 2007	4	7646	Thu, 09 January 2020 06:30 By: Solomon Yakobson
ORA-01031: insufficient privileges \| Database level trigger Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: vippysharma on Wed, 25 December 2019	10	5803	Mon, 06 January 2020 04:17 By: cookiemonster
Raise exception in case clause PL/SQL function 11.2.0.1.0 By: OraFerro on Mon, 06 January 2020	4	1693	Mon, 06 January 2020 02:30 By: OraFerro
Error performing insert Oracle Sql Developed By: Xbox2019 on Thu, 02 January 2020	1	3291	Thu, 02 January 2020 12:19 By: Michel Cadot
WITH Clause VS INLINE View Execution Oracle 12C By: ashrubhg@gmail.com on Mon, 30 December 2019	2	3792	Wed, 01 January 2020 06:17 By: John Watson