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
How to find out Last Modification Time of a database? Oracle 12c By: muniraj_tomar on Mon, 17 July 2017	13	10598	Wed, 26 July 2017 07:03 By: BlackSwan
Ref cursor results to CSV? By: hmoulding on Fri, 09 June 2006	14	16975	Mon, 24 July 2017 12:42 By: hmoulding
Weeks, Quarters, and Counts 11g By: jmltinc on Mon, 24 July 2017	5	4096	Mon, 24 July 2017 11:22 By: jmltinc
Mutating error Oracle 12.1 By: arifmd1705 on Sat, 22 July 2017	9	7530	Mon, 24 July 2017 08:12 By: Bill B
foreign key conflict issue Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production. By: orcl2ram on Sat, 22 July 2017	9	5967	Mon, 24 July 2017 07:54 By: joy_division
oracle external table load oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	2	3806	Sun, 23 July 2017 19:09 By: Barbara Boehmer
utl_file issue oracle 11g By: POGAKU_SANTHOSH on Fri, 21 July 2017	2	3527	Fri, 21 July 2017 15:16 By: Bill B
Repeat Cursor 12.1.0.2.0 By: SteveShephard on Thu, 20 July 2017	10	6833	Fri, 21 July 2017 14:20 By: Barbara Boehmer
How do we implement NVL() in XSLT? Oracle R12 By: ajayhareesh on Fri, 21 July 2017	4	7004	Fri, 21 July 2017 10:38 By: Michel Cadot
xml question oracle 11g By: deb171100 on Thu, 20 July 2017	4	4327	Fri, 21 July 2017 06:34 By: Bill B
select from two tables By: amjad_alahdal on Thu, 30 April 2015	6	5960	Thu, 20 July 2017 05:48 By: amjad_alahdal
ORA-1555 during pl/sql pocedure PL/SQL Release 11.2.0.3.0 - Production,windows 10 By: priya_t on Wed, 19 July 2017	6	5331	Thu, 20 July 2017 03:19 By: cookiemonster
DBMS_JOB (NEXT_DATE / INTERVAL) Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production By: chat2raj.s on Wed, 19 July 2017	7	4849	Wed, 19 July 2017 12:23 By: EdStevens
Solution for ORA-06550: line 6, column 31: PLS-00103: Encountered the symbol ")" when expecting one sql developer,4.1,windows7 By: priya_t on Tue, 18 July 2017	5	14311	Tue, 18 July 2017 08:45 By: cookiemonster
Pivot columns and dynamically assign values based on column name Oracle 12.1.0.2, Linux By: sspn2010 on Thu, 13 July 2017	6	5017	Sun, 16 July 2017 21:18 By: sspn2010
Case statement in From Clause By: ramya29p on Mon, 10 July 2017	7	5529	Fri, 14 July 2017 19:33 By: Barbara Boehmer
Insert statement with bind variable and Create statement Oracle 10.1 By: jaggub on Fri, 14 July 2017	2	3659	Fri, 14 July 2017 19:19 By: Barbara Boehmer
Count Distinct Not Working in Case Select Oracle SQL By: phaenggi on Tue, 11 July 2017	11	7808	Wed, 12 July 2017 15:05 By: Bill B
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	5319	Wed, 12 July 2017 09:41 By: Deep Chakraborty
uploading excel with transposed data By: oracbeg on Wed, 12 July 2017	2	3847	Wed, 12 July 2017 07:38 By: Bill B
How to retrieve negative value as positive in simple brackets? 11gR2, Windows 10 By: oracbeg on Tue, 11 July 2017	5	4272	Tue, 11 July 2017 08:06 By: Solomon Yakobson
Cast_to_number not working By: purnima1 on Tue, 11 July 2017	4	4526	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	3045	Mon, 10 July 2017 12:39 By: joy_division
GMT Time Stamp PL SQL By: OldDog on Sun, 28 May 2017	17	10130	Mon, 10 July 2017 12:08 By: Michel Cadot
Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement Oracle 10g By: keewee279 on Sun, 09 July 2017	1	3683	Sun, 09 July 2017 06:05 By: Michel Cadot
Appending CLOB Oracle 10g By: chat2raj.s on Mon, 03 July 2017	24	14018	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	9745	Fri, 07 July 2017 11:15 By: Michel Cadot
Regular Expressions Oracle By: oomjai2233 on Fri, 07 July 2017	14	8468	Fri, 07 July 2017 05:56 By: Michel Cadot
Functional based index By: Bala_Y on Mon, 03 July 2017	17	8897	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	6287	Thu, 06 July 2017 12:16 By: Michel Cadot
Accessing Sub directory under Oracle directory 11g By: harshadsp on Thu, 19 May 2016	12	16586	Thu, 06 July 2017 09:52 By: Bill B
Search in concatenated string (merged) By: patneel on Wed, 05 July 2017	2	3315	Wed, 05 July 2017 15:15 By: Michel Cadot
Recursive select Oracle 9i By: banach600 on Mon, 03 July 2017	21	9465	Wed, 05 July 2017 05:14 By: banach600
Extracting number 12c By: m.abdulhaq on Tue, 27 June 2017	12	6929	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	2911	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	3982	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	3325	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	6971	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	17459	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	3789	Wed, 28 June 2017 00:05 By: Gurubalan

Pages (1272): [ « ‹ 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Sat Mar 07 00:10:58 CST 2026