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
Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement Oracle 10g By: keewee279 on Sun, 09 July 2017	1	1674	Sun, 09 July 2017 06:05 By: Michel Cadot
Appending CLOB Oracle 10g By: chat2raj.s on Mon, 03 July 2017	24	7695	Sun, 09 July 2017 06:03 By: Michel Cadot
Get last 200 records from table in oracle 11g By: asliyanage on Tue, 04 July 2017	19	5893	Fri, 07 July 2017 11:15 By: Michel Cadot
Regular Expressions Oracle By: oomjai2233 on Fri, 07 July 2017	14	5623	Fri, 07 July 2017 05:56 By: Michel Cadot
Functional based index By: Bala_Y on Mon, 03 July 2017	17	5726	Thu, 06 July 2017 16:58 By: Bala_Y
Report hangs (possibly query related).. is this possible cause? Oracle Reports 11g, Oracle 12c Database By: nait1234 on Thu, 06 July 2017	8	2748	Thu, 06 July 2017 12:16 By: Michel Cadot
Accessing Sub directory under Oracle directory 11g By: harshadsp on Thu, 19 May 2016	12	9072	Thu, 06 July 2017 09:52 By: Bill B
Search in concatenated string (merged) By: patneel on Wed, 05 July 2017	2	1683	Wed, 05 July 2017 15:15 By: Michel Cadot
Recursive select Oracle 9i By: banach600 on Mon, 03 July 2017	21	5939	Wed, 05 July 2017 05:14 By: banach600
Extracting number 12c By: m.abdulhaq on Tue, 27 June 2017	12	4188	Tue, 04 July 2017 01:06 By: bbob
Moving data from one table to another Oracle 11g By: clancypc on Mon, 03 July 2017	1	1453	Mon, 03 July 2017 07:01 By: BlackSwan
What is the error ora-20914 pre insert I am getting this error in the forms? By: narendraenamala on Sat, 01 July 2017	3	1788	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	1636	Fri, 30 June 2017 01:20 By: John Watson
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	3859	Thu, 29 June 2017 11:36 By: Manoj.Gupta.91
ORA-01830 in XMLTABLE for DATE conversion 11g and 12c By: hamsterbacke on Thu, 22 June 2017	17	9616	Wed, 28 June 2017 01:29 By: Michel Cadot
not gettting output for showplanfrpspreadsheetcode11g Oracle 12c, Solaris SPARC By: Gurubalan on Mon, 26 June 2017	3	1833	Wed, 28 June 2017 00:05 By: Gurubalan
help needed with SQL code Oracle, 11, windows By: aadebayo on Fri, 23 June 2017	7	6718	Fri, 23 June 2017 09:13 By: aadebayo
PRMDB-0933-1 PRIMAVERA 16.2.1, WIN2K7 64BIT By: hiper on Thu, 22 June 2017	1	1654	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	2043	Wed, 21 June 2017 08:25 By: Michel Cadot
Sending List to Oracle Stored Procedure By: anandneema on Mon, 19 June 2017	3	2038	Mon, 19 June 2017 09:45 By: Michel Cadot
grouping of records Oracle 11.2.0.3 By: pointers on Sat, 17 June 2017	1	1598	Sat, 17 June 2017 01:51 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	2069	Fri, 16 June 2017 10:39 By: BlackSwan
Oracle database link performance cum security issue Oracle 10G R2 By: arpankumarmisra on Fri, 26 May 2017	9	4806	Thu, 15 June 2017 12:20 By: joy_division
Locked object in gv$locked_object without transaction in gv$transaction Oracle 11g r2 , Red Had RAC By: Andrey_R on Sat, 27 May 2017	4	2986	Thu, 15 June 2017 10:25 By: Caffeine+
Help the newbie to do my first procedure By: TonyDu94 on Wed, 14 June 2017	8	7410	Thu, 15 June 2017 00:26 By: flyboy
[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	4646	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	167301	Mon, 12 June 2017 03:02 By: cookiemonster
Trigger to fill foreign key from another table 11.0.2.10 By: OraFerro on Sun, 11 June 2017	2	1435	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	1832	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	24618	Fri, 09 June 2017 00:54 By: Michel Cadot
Different result when using FOR UPDATE Oracle 11 By: hundsmiachn on Tue, 06 June 2017	4	2124	Tue, 06 June 2017 09:56 By: Michel Cadot
dbms_output.put_line for dynamic sql query SQL*Plus: Release 11.2.0.3.0 Production By: shawaj on Tue, 30 May 2017	4	4378	Sat, 03 June 2017 03:28 By: shawaj
oracle external table issue oracle 11g , pl/sql, sql By: POGAKU_SANTHOSH on Wed, 31 May 2017	5	3142	Fri, 02 June 2017 19:03 By: Barbara Boehmer
Sequence generation for Parallel Processing ORACLE 11g, Windows By: lokimisc on Fri, 12 May 2017	21	7604	Fri, 02 June 2017 15:08 By: Bill B
Package to include a sleep inside a procedure Linux 2.6.39-400.286.3.el6uek.x86_64 - Oracle 11.2.0.4.0 By: Nagesh1985 on Thu, 01 June 2017	9	3896	Fri, 02 June 2017 13:33 By: Bill B
Passing value from one cursor to the other one. By: AkilaSubramanian on Tue, 24 May 2011	6	85108	Fri, 02 June 2017 09:34 By: Bill B
Creating foreign key constraints for nested tables of user defined types oracle Oracle By: Hatik on Thu, 01 June 2017	7	3210	Thu, 01 June 2017 22:35 By: Hatik
Query Db table with Key Value Oracle By: hippylou2u on Fri, 26 May 2017	10	4541	Wed, 31 May 2017 11:11 By: Solomon Yakobson
Armstrong numbers By: sridhar.sangubhatla on Tue, 03 July 2007	12	13857	Tue, 30 May 2017 08:20 By: ynkr999
Dependent Objects recursively Oracle 11.2.0.3 By: pointers on Mon, 29 May 2017	4	1992	Tue, 30 May 2017 00:09 By: Michel Cadot

Pages (1259): [ « ‹ 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Fri Jul 10 00:19:39 CDT 2020