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
Creating different worksheets in a single excel Oracle 11g By: venkat111 on Thu, 28 July 2016	2	2783	Thu, 28 July 2016 14:15 By: Bill B
Extract value from xml Oracle 12c By: Raj12345 on Thu, 28 July 2016	3	4326	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	2761	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	17690	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	2786	Thu, 28 July 2016 01:03 By: Michel Cadot
XML tag selection ORACLE 11g By: lokimisc on Tue, 26 July 2016	8	9023	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	3105	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	5848	Mon, 25 July 2016 15:00 By: Bill B
LAG error 10g, 8i, win 8.1 By: rzkhan on Mon, 25 July 2016	8	5200	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	4246	Sun, 24 July 2016 14:55 By: Andrey_R
Set a range into in time Forms, By: Salehin on Tue, 07 June 2016	32	13067	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	2914	Fri, 22 July 2016 13:40 By: Solomon Yakobson
GETTING NULLS WHEN USING PIVOT By: vijay1255 on Thu, 21 July 2016	6	3785	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	4089	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	3890	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	4358	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	5899	Thu, 21 July 2016 02:20 By: sss111ind
Collection Last Record Oracle 11g By: ORAGENASHOK on Mon, 18 July 2016	4	3094	Wed, 20 July 2016 03:05 By: cookiemonster
Merging BLOB Oracle 11GR2, Windows Server 2008 R2 By: Jaffat1982 on Wed, 13 July 2016	6	6080	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	3467	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	12378	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	8378	Mon, 18 July 2016 03:54 By: flyboy
Table joining Windows By: 17111991 on Sun, 17 July 2016	4	3566	Sun, 17 July 2016 23:44 By: Barbara Boehmer
heirarchy between tables By: 17111991 on Sun, 17 July 2016	1	2061	Sun, 17 July 2016 12:38 By: Michel Cadot
Unpivot Query Help to transpose the data Oracle 11g By: arifs3738 on Sat, 16 July 2016	2	2290	Sun, 17 July 2016 12:19 By: arifs3738
ORA-01722 when returning ROWTYPE in function oracle Database 11g Enterprise Edition Release 11.1.0.6.0 By: rkhatiwala on Tue, 12 July 2016	13	6859	Fri, 15 July 2016 14:45 By: Michel Cadot
Parent child count? By: P1Oracle on Tue, 12 July 2016	6	2937	Wed, 13 July 2016 03:36 By: cookiemonster
PLS-00907: cannot load libraryunit PROD.DAILY_RPT (referenced by ) 11G By: venkat111 on Fri, 01 July 2016	6	17674	Tue, 12 July 2016 13:40 By: Bill B
finding constrains on table oracle 12c By: gorants on Mon, 11 July 2016	15	7797	Tue, 12 July 2016 02:20 By: Michel Cadot
Query: select id where max(value) - possible? Oracle By: ich01 on Mon, 11 July 2016	10	5644	Mon, 11 July 2016 17:52 By: Barbara Boehmer
information oracle 8 By: ceciaide on Fri, 08 July 2016	12	5655	Mon, 11 July 2016 16:32 By: ceciaide
PL/SQL error Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit By: jcasas on Sat, 09 July 2016	11	5354	Sat, 09 July 2016 21:09 By: Barbara Boehmer
Oracle reports Oracle 11g By: srinivas.k2005 on Mon, 04 July 2016	7	4376	Tue, 05 July 2016 05:02 By: Michel Cadot
query doubt hp unix, oracle 10g By: arun888 on Mon, 04 July 2016	4	3143	Tue, 05 July 2016 00:43 By: arun888
SQL problem - variation on top-n-of-group. DDL and DML supplied. Oracle - any version this millenium, also MySQL and PostgreSQL. By: dragam on Sat, 02 July 2016	5	4373	Mon, 04 July 2016 17:20 By: Barbara Boehmer
String Manipulations Oracle 11g R2 By: javed.khan on Mon, 04 July 2016	1	2262	Mon, 04 July 2016 13:36 By: Michel Cadot
Pick One : A Query for Multiple Submission of form but to take only first one. Oracle 11g R2 By: javed.khan on Tue, 28 June 2016	11	5160	Mon, 04 July 2016 13:13 By: Michel Cadot
Constraints in External Table. Oracle 11g By: jeeva7311 on Mon, 04 July 2016	4	2821	Mon, 04 July 2016 10:13 By: jeeva7311
Procidure includ not duplicate By: rkled on Mon, 04 July 2016	3	2886	Mon, 04 July 2016 09:29 By: Michel Cadot
Updating Status W to A SQL By: Salehin on Tue, 31 May 2016	28	15892	Mon, 04 July 2016 02:59 By: cookiemonster