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
SQL connectivity test oracle, 11g, AIX By: Prathikesh on Sat, 06 August 2016	24	1315	Mon, 08 August 2016 02:50 By: cookiemonster
UTL_DBWS error: ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist Oracle DB, 10g R2, Windows Server 2008R2 By: mdsirajoddin on Sat, 06 August 2016	12	3089	Sat, 06 August 2016 10:38 By: Michel Cadot
Sum from part of coloumn Oracle,11g Release 11.2.0.4.0, Solaris 11 By: nms123 on Fri, 05 August 2016	2	588	Fri, 05 August 2016 09:47 By: nms123
Help using regexp_substr - Urgent Help needed Oracle 11 By: Member2014 on Thu, 04 August 2016	8	890	Fri, 05 August 2016 08:41 By: Member2014
Regular expression search By: saipradyumn on Fri, 05 August 2016	2	498	Fri, 05 August 2016 07:58 By: Solomon Yakobson
Count group data 12.1.0.2 By: bdtran on Sat, 02 July 2016	21	2486	Wed, 03 August 2016 23:44 By: bdtran
Make use of UNUSABLE_INDEX by uisnh HInt Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Wed, 27 July 2016	4	636	Wed, 03 August 2016 13:37 By: Bill B
Replace Accented Characters By: ramya29p on Wed, 27 July 2016	21	1171	Wed, 03 August 2016 05:12 By: Michel Cadot
Execution of Query Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Tue, 02 August 2016	4	565	Tue, 02 August 2016 07:51 By: John Watson
how to report oracle internal error By: desmond30 on Wed, 27 July 2016	4	1300	Tue, 02 August 2016 00:24 By: Michel Cadot
Sorting 12c By: ashlythomas on Sun, 31 July 2016	6	818	Mon, 01 August 2016 08:05 By: pablolee
Error An INTO Clause Oracle, Toad, SQL Developer, Windows Server By: abacusdotcom on Tue, 26 July 2016	6	952	Mon, 01 August 2016 06:53 By: EdStevens
Same record with Space and Without Space Oracle 12c, Windows NT By: pstanand on Fri, 29 July 2016	13	1291	Sun, 31 July 2016 03:33 By: Barbara Boehmer
comparison ALL with subquery returns no rows - TRUE Oracle 11.2.0.3 By: pointers on Fri, 29 July 2016	7	905	Sat, 30 July 2016 03:08 By: Michel Cadot
how create synonym for full database By: mfahimaamirgmailcom on Fri, 29 July 2016	7	873	Fri, 29 July 2016 07:54 By: BlackSwan
Database vs Tablespace By: KirkSpiritor on Wed, 27 July 2016	17	1289	Fri, 29 July 2016 07:42 By: EdStevens
Creating different worksheets in a single excel Oracle 11g By: venkat111 on Thu, 28 July 2016	2	572	Thu, 28 July 2016 14:15 By: Bill B
Extract value from xml Oracle 12c By: Raj12345 on Thu, 28 July 2016	3	597	Thu, 28 July 2016 14:12 By: Bill B
place set values next to each other Oracle 11.2.0.3 By: pointers on Thu, 28 July 2016	4	570	Thu, 28 July 2016 13:47 By: BlackSwan
How to display report format data Oracle 11 ( 1 2) By: ssyr22 on Thu, 30 June 2016	49	2739	Thu, 28 July 2016 02:40 By: Barbara Boehmer
unusable index on inserting data into partition table Oracle 11.0.2 By: jbvenkat_mcq on Thu, 28 July 2016	3	418	Thu, 28 July 2016 01:03 By: Michel Cadot
XML tag selection ORACLE 11g By: lokimisc on Tue, 26 July 2016	8	1604	Wed, 27 July 2016 02:09 By: pablolee
Retrieve text for ID from another table for two columns in a SELECT statement Oracle 11.2.0.3.0 , OEL 5 By: Andrey_R on Tue, 26 July 2016	4	556	Tue, 26 July 2016 10:35 By: John Watson
How can I load 300k of data into a CLOB OEL 5, Oracle 11.2.0.3.0 By: Andrey_R on Sun, 24 July 2016	13	1127	Mon, 25 July 2016 15:00 By: Bill B
LAG error 10g, 8i, win 8.1 By: rzkhan on Mon, 25 July 2016	8	860	Mon, 25 July 2016 07:35 By: rzkhan
Break a > 300k CLOB string into 32k chunks OEL 5, Oracle 11.2.0.3.0 By: Andrey_R on Sun, 24 July 2016	10	690	Sun, 24 July 2016 14:55 By: Andrey_R
Set a range into in time Forms, By: Salehin on Tue, 07 June 2016	32	2347	Sat, 23 July 2016 06:54 By: BlackSwan
SQL query for formatted data display oracle, 11gR2, RHEL By: 9390512774 on Fri, 22 July 2016	2	830	Fri, 22 July 2016 13:40 By: Solomon Yakobson
GETTING NULLS WHEN USING PIVOT By: vijay1255 on Thu, 21 July 2016	6	898	Fri, 22 July 2016 10:24 By: Bill B
Deadlock experienced but Blocking lock expected 12.1.0.2 By: epep-pdm on Wed, 20 July 2016	7	934	Thu, 21 July 2016 12:20 By: Solomon Yakobson
Getting Parent and Child from the same table & same column Oracle 11g/Windows 8.1 By: naveenjv on Wed, 20 July 2016	6	660	Thu, 21 July 2016 06:23 By: naveenjv
ORA-01006 ORA-01006: la variable attachée (bind variable) n'existe pas By: pcouas on Wed, 20 July 2016	5	990	Thu, 21 July 2016 04:50 By: pcouas
Logic for displaying below row as first row Oracle 10g By: sss111ind on Tue, 19 July 2016	12	910	Thu, 21 July 2016 02:20 By: sss111ind
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016	21	2533	Wed, 20 July 2016 07:19 By: SheliaWilson
Collection Last Record Oracle 11g By: ORAGENASHOK on Mon, 18 July 2016	4	696	Wed, 20 July 2016 03:05 By: cookiemonster
Merging BLOB Oracle 11GR2, Windows Server 2008 R2 By: Jaffat1982 on Wed, 13 July 2016	6	960	Tue, 19 July 2016 08:00 By: Jaffat1982
sorting order need to be done when the columns in the order by are given in input parameter 11 g By: saipavan.plsql on Mon, 18 July 2016	5	623	Tue, 19 July 2016 07:31 By: saipavan.plsql
transposing of data in oracle oracle 12 c By: tolupuluri on Tue, 28 June 2016	23	2607	Tue, 19 July 2016 03:49 By: Michel Cadot
Change Current schema to other schema Oracle 11g, windows By: Vijay55 on Mon, 18 July 2016	2	605	Mon, 18 July 2016 03:54 By: flyboy
Table joining Windows By: 17111991 on Sun, 17 July 2016	4	670	Sun, 17 July 2016 23:44 By: Barbara Boehmer