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
Pivot columns and dynamically assign values based on column name Oracle 12.1.0.2, Linux By: sspn2010 on Thu, 13 July 2017	6	407	Sun, 16 July 2017 21:18 By: sspn2010
Re: PL/SQL:How to use VARRAY in the USING clause of EXECUTE IMMEDIATE? split from http://www.orafaq.com/forum/t/161791/ By: moracles on Tue, 11 July 2017	5	102	Tue, 11 July 2017 15:45 By: moracles
Merging of Interval Partitions Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Wed, 12 July 2017	3	199	Wed, 12 July 2017 09:41 By: Deep Chakraborty
uploading excel with transposed data By: oracbeg on Wed, 12 July 2017	2	224	Wed, 12 July 2017 07:38 By: Bill B
Count Distinct Not Working in Case Select Oracle SQL By: phaenggi on Tue, 11 July 2017	11	375	Wed, 12 July 2017 15:05 By: Bill B
How to retrieve negative value as positive in simple brackets? 11gR2, Windows 10 By: oracbeg on Tue, 11 July 2017	5	237	Tue, 11 July 2017 08:06 By: Solomon Yakobson
Cast_to_number not working By: purnima1 on Tue, 11 July 2017	4	187	Tue, 11 July 2017 02:00 By: purnima1
Update Match Flag Status in Invoice Distribution Oracle Applications : 11.5.10.2 By: iamaelle on Mon, 10 July 2017	1	156	Mon, 10 July 2017 12:39 By: joy_division
Case statement in From Clause By: ramya29p on Mon, 10 July 2017	7	360	Fri, 14 July 2017 19:33 By: Barbara Boehmer
Regular Expressions Oracle By: oomjai2233 on Fri, 07 July 2017	14	354	Fri, 07 July 2017 05:56 By: Michel Cadot
Report hangs (possibly query related).. is this possible cause? Oracle Reports 11g, Oracle 12c Database By: nait1234 on Thu, 06 July 2017	8	215	Thu, 06 July 2017 12:16 By: Michel Cadot
Search in concatenated string (merged) By: patneel on Wed, 05 July 2017	2	181	Wed, 05 July 2017 15:15 By: Michel Cadot
PLS-00201: identifier 'UTL_MAIL' must be declared 11.2.0.4 By: grpatwari on Wed, 05 July 2017	5	432	Wed, 26 July 2017 08:32 By: Bill B
Code Help: Inserting Records based on records in another table meeting certain parameters Oracle SQL Developer By: cem616 on Wed, 09 August 2017	6	542	Mon, 14 August 2017 14:07 By: buggleboy007
Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement Oracle 10g By: keewee279 on Sun, 09 July 2017	1	130	Sun, 09 July 2017 06:05 By: Michel Cadot
Get last 200 records from table in oracle 11g By: asliyanage on Tue, 04 July 2017	19	639	Fri, 07 July 2017 11:15 By: Michel Cadot
Functional based index By: Bala_Y on Mon, 03 July 2017	17	512	Thu, 06 July 2017 16:58 By: Bala_Y
Moving data from one table to another Oracle 11g By: clancypc on Mon, 03 July 2017	1	196	Mon, 03 July 2017 07:01 By: BlackSwan
Recursive select Oracle 9i By: banach600 on Mon, 03 July 2017	21	535	Wed, 05 July 2017 05:14 By: banach600
Appending CLOB Oracle 10g By: chat2raj.s on Mon, 03 July 2017	24	608	Sun, 09 July 2017 06:03 By: Michel Cadot
String manipulation By: praf1981 on Mon, 10 July 2017	3	411	Thu, 27 July 2017 05:57 By: praf1981
What is the error ora-20914 pre insert I am getting this error in the forms? By: narendraenamala on Sat, 01 July 2017	3	197	Sat, 01 July 2017 01:53 By: narendraenamala
Materialized View refresh performance issue. Oracle 11g R2 By: Manoj.Gupta.91 on Thu, 29 June 2017	3	286	Fri, 30 June 2017 01:20 By: John Watson
Extracting number 12c By: m.abdulhaq on Tue, 27 June 2017	12	486	Tue, 04 July 2017 01:06 By: bbob
not gettting output for showplanfrpspreadsheetcode11g Oracle 12c, Solaris SPARC By: Gurubalan on Mon, 26 June 2017	3	273	Wed, 28 June 2017 00:05 By: Gurubalan
help needed with SQL code Oracle, 11, windows By: aadebayo on Fri, 23 June 2017	7	298	Fri, 23 June 2017 09:13 By: aadebayo
ORA-01830 in XMLTABLE for DATE conversion 11g and 12c By: hamsterbacke on Thu, 22 June 2017	17	821	Wed, 28 June 2017 01:29 By: Michel Cadot
PRMDB-0933-1 PRIMAVERA 16.2.1, WIN2K7 64BIT By: hiper on Thu, 22 June 2017	1	232	Thu, 22 June 2017 03:16 By: Michel Cadot
how to calculate column value dynamically oracle 11g 11.2.0.4.0 release By: harishankar_kar on Wed, 21 June 2017	3	279	Wed, 21 June 2017 08:25 By: Michel Cadot
How to generate JSON Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: Manoj.Gupta.91 on Wed, 21 June 2017	4	394	Thu, 29 June 2017 11:36 By: Manoj.Gupta.91
Sending List to Oracle Stored Procedure By: anandneema on Mon, 19 June 2017	3	353	Mon, 19 June 2017 09:45 By: Michel Cadot
stored proc execution based on selected value from a column Oracle 11.2.0.4 By: veepee on Fri, 16 June 2017	5	372	Fri, 16 June 2017 10:39 By: BlackSwan
Help the newbie to do my first procedure By: TonyDu94 on Wed, 14 June 2017	8	341	Thu, 15 June 2017 00:26 By: flyboy
grouping of records Oracle 11.2.0.3 By: pointers on Sat, 17 June 2017	1	391	Sat, 17 June 2017 01:51 By: Michel Cadot
Trigger to fill foreign key from another table 11.0.2.10 By: OraFerro on Sun, 11 June 2017	2	203	Sun, 11 June 2017 03:40 By: Michel Cadot
Update values "in groups" Oracle 12c, 12.1.0.2.0, MS Windows 7 By: Littlefoot on Fri, 09 June 2017	5	275	Fri, 09 June 2017 07:33 By: Solomon Yakobson
Handling invalid identifier exception in plsql oracle 11g By: ynkr999 on Wed, 07 June 2017	6	2752	Fri, 09 June 2017 00:54 By: Michel Cadot
[Error] Execution (64: 64): ORA-32034: unsupported use of WITH clause for materilized view CORE 11.2.0.4.0 Production By: JEWEL78 on Wed, 14 June 2017	7	290	Wed, 14 June 2017 13:54 By: Bill B
ORA-00922: missing or invalid option - PROCEDURE with SPOOL By: freis_bcf on Tue, 06 June 2017	14	17900	Mon, 12 June 2017 03:02 By: cookiemonster
Different result when using FOR UPDATE Oracle 11 By: hundsmiachn on Tue, 06 June 2017	4	236	Tue, 06 June 2017 09:56 By: Michel Cadot