Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 5955 Mon, 05 September 2011 02:20
By: Littlefoot
  Count , Per Week Group by
By: azeem87 on Mon, 24 July 2017
1 61 Mon, 24 July 2017 15:59
By: BlackSwan
  Ref cursor results to CSV?
By: hmoulding on Fri, 09 June 2006
14 3693 Mon, 24 July 2017 12:42
By: hmoulding
  Weeks, Quarters, and Counts
11g
By: jmltinc on Mon, 24 July 2017
5 115 Mon, 24 July 2017 11:22
By: jmltinc
  Performance issue to Update data
Oracle 11g
By: newuser on Sat, 22 July 2017
7 241 Mon, 24 July 2017 08:21
By: Bill B
  Mutating error
Oracle 12.1
By: arifmd1705 on Sat, 22 July 2017
9 275 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 267 Mon, 24 July 2017 07:54
By: joy_division
  oracle external table load
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
2 142 Sun, 23 July 2017 19:09
By: Barbara Boehmer
read line issue has been moved to Unix by the moderator.
  Solution for ora-00020 maximum number of processes
oracle database 8i
By: amjad_alahdal on Thu, 20 July 2017
16 443 Fri, 21 July 2017 15:36
By: BlackSwan
  utl_file issue
oracle 11g
By: POGAKU_SANTHOSH on Fri, 21 July 2017
2 148 Fri, 21 July 2017 15:16
By: Bill B
  Repeat Cursor
12.1.0.2.0
By: SteveShephard on Thu, 20 July 2017
10 260 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 214 Fri, 21 July 2017 10:38
By: Michel Cadot
  xml question
oracle 11g
By: deb171100 on Thu, 20 July 2017
4 153 Fri, 21 July 2017 06:34
By: Bill B
  select from two tables
By: amjad_alahdal on Thu, 30 April 2015
6 908 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 238 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 247 Wed, 19 July 2017 12:23
By: EdStevens
  How to find out Last Modification Time of a database?
Oracle 12c
By: muniraj_tomar on Mon, 17 July 2017
10 379 Tue, 18 July 2017 10:20
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 141 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 344 Sun, 16 July 2017 21:18
By: sspn2010
  Case statement in From Clause
By: ramya29p on Mon, 10 July 2017
7 300 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 125 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 321 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 161 Wed, 12 July 2017 09:41
By: Deep Chakraborty
  uploading excel with transposed data
By: oracbeg on Wed, 12 July 2017
2 189 Wed, 12 July 2017 07:38
By: Bill B
  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 60 Tue, 11 July 2017 15:45
By: moracles
  How to retrieve negative value as positive in simple brackets?
11gR2, Windows 10
By: oracbeg on Tue, 11 July 2017
5 199 Tue, 11 July 2017 08:06
By: Solomon Yakobson
  Cast_to_number not working
By: purnima1 on Tue, 11 July 2017
4 146 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 128 Mon, 10 July 2017 12:39
By: joy_division
  GMT Time Stamp
PL SQL
By: OldDog on Sun, 28 May 2017
17 799 Mon, 10 July 2017 12:08
By: Michel Cadot
  String manipulation
By: praful1981 on Mon, 10 July 2017
2 168 Mon, 10 July 2017 03:49
By: John Watson
  Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement
Oracle 10g
By: keewee279 on Sun, 09 July 2017
1 100 Sun, 09 July 2017 06:05
By: Michel Cadot
  Appending CLOB
Oracle 10g
By: chat2raj.s on Mon, 03 July 2017
24 550 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 577 Fri, 07 July 2017 11:15
By: Michel Cadot
  Regular Expressions
Oracle
By: oomjai2233 on Fri, 07 July 2017
14 300 Fri, 07 July 2017 05:56
By: Michel Cadot
  Functional based index
By: Bala_Y on Mon, 03 July 2017
17 463 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 189 Thu, 06 July 2017 12:16
By: Michel Cadot
  Accessing Sub directory under Oracle directory
11g
By: harshadsp on Thu, 19 May 2016
12 1360 Thu, 06 July 2017 09:52
By: Bill B
  Search in concatenated string (merged)
By: patneel on Wed, 05 July 2017
2 163 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
3 166 Wed, 05 July 2017 14:05
By: Bill B
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Tue Jul 25 14:20:15 CDT 2017

Total time taken to generate the page: 0.10566 seconds