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
  Solution for ora-00020 maximum number of processes
oracle database 8i
By: amjad_alahdal on Thu, 20 July 2017
17 580 Sun, 20 August 2017 02:23
By: amjad_alahdal
Oracle SQL 1Z0-071 has been moved to Training & Certification by the moderator.
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 335 Fri, 18 August 2017 14:23
By: arifmd1705
  qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/)
By: mlashin on Tue, 08 August 2017
6 441 Wed, 16 August 2017 20:47
By: Barbara Boehmer
  Determine filePath/Name from UTL_FILE.FILE_TYPE?
Oracle 11g
By: bkuhn on Wed, 16 August 2017
4 235 Thu, 17 August 2017 09:20
By: bkuhn
  Triggers on editioning views inheriting trigger events from NEWER editions
Oracle Database - Enterprise Edition Product Version 12.1.0.2 Linux x86-64 OS Version Red Hat Enterprise 6
By: fixxxer on Wed, 16 August 2017
7 355 Fri, 18 August 2017 05:36
By: Michel Cadot
  Help with PL SQL query - Analytical Function or group by
12c
By: namitanamburi on Tue, 15 August 2017
1 264 Tue, 15 August 2017 14:00
By: Michel Cadot
  Need to get the comma separated value
By: rajeshsvnr on Mon, 14 August 2017
4 376 Thu, 17 August 2017 12:05
By: rajeshsvnr
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
5 640 Fri, 11 August 2017 01:19
By: Michel Cadot
  MISSING DATE
oracle 11g , database 11g, windows 7
By: hisham99 on Tue, 15 August 2017
6 370 Tue, 15 August 2017 07:37
By: John Watson
  Should I Clean Up My Collections?
11g
By: whdyck on Thu, 17 August 2017
8 409 Fri, 18 August 2017 09:37
By: whdyck
  Rectify the code
By: salam_shah on Tue, 08 August 2017
9 649 Mon, 14 August 2017 06:49
By: Bill B
  LPX-00230: invalid character 0 (U+0000) found in a Name or Nmtoken
Oracle 10g
By: sss111ind on Mon, 07 August 2017
1 216 Mon, 07 August 2017 08:09
By: BlackSwan
  Setting Edition // Remote Database
Oracle 11.2.0.4
By: suddhasatwa_oracle on Mon, 07 August 2017
13 646 Fri, 18 August 2017 02:26
By: Michel Cadot
  extract portion of strings
12c
By: m.abdulhaq on Sat, 05 August 2017
6 810 Tue, 08 August 2017 23:09
By: m.abdulhaq
  SQL QUERY
oracle 11g 32-bit, windows7
By: shawaj on Fri, 04 August 2017
5 804 Tue, 08 August 2017 21:28
By: shawaj
  string operations
oracle 11g
By: POGAKU_SANTHOSH on Tue, 01 August 2017
9 1084 Wed, 02 August 2017 06:36
By: Bill B
  Regular Expression : Find and Replace Specific String
Oracle 11g
By: lokimisc on Fri, 28 July 2017
17 1726 Tue, 01 August 2017 13:38
By: Solomon Yakobson
  string aggregation
10g
By: praf1981 on Thu, 27 July 2017
2 893 Sun, 30 July 2017 23:42
By: Barbara Boehmer
  Help with sql code
10 G
By: ramkumar10 on Wed, 26 July 2017
4 588 Thu, 27 July 2017 22:45
By: ramkumar10
  member procedure execution
oracle 11g
By: ynkr999 on Tue, 25 July 2017
3 288 Tue, 15 August 2017 00:16
By: Barbara Boehmer
  Weeks, Quarters, and Counts
11g
By: jmltinc on Mon, 24 July 2017
5 214 Mon, 24 July 2017 11:22
By: jmltinc
  Count , Per Week Group by
By: azeem87 on Mon, 24 July 2017
5 666 Fri, 28 July 2017 07:31
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 329 Mon, 24 July 2017 07:54
By: joy_division
  Mutating error
Oracle 12.1
By: arifmd1705 on Sat, 22 July 2017
9 346 Mon, 24 July 2017 08:12
By: Bill B
  How do we implement NVL() in XSLT?
Oracle R12
By: ajayhareesh on Fri, 21 July 2017
4 279 Fri, 21 July 2017 10:38
By: Michel Cadot
  utl_file issue
oracle 11g
By: POGAKU_SANTHOSH on Fri, 21 July 2017
2 192 Fri, 21 July 2017 15:16
By: Bill B
  xml question
oracle 11g
By: deb171100 on Thu, 20 July 2017
4 206 Fri, 21 July 2017 06:34
By: Bill B
  oracle external table load
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
2 218 Sun, 23 July 2017 19:09
By: Barbara Boehmer
  Repeat Cursor
12.1.0.2.0
By: SteveShephard on Thu, 20 July 2017
10 307 Fri, 21 July 2017 14:20
By: Barbara Boehmer
  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 298 Thu, 20 July 2017 03:19
By: cookiemonster
  Convert Columns to Rows
By: SwathiKarre on Tue, 25 July 2017
6 1095 Sun, 30 July 2017 07:48
By: Solomon Yakobson
  DBMS_JOB (NEXT_DATE / INTERVAL)
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
By: chat2raj.s on Wed, 19 July 2017
7 311 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 203 Tue, 18 July 2017 08:45
By: cookiemonster
  How to find out Last Modification Time of a database?
Oracle 12c
By: muniraj_tomar on Mon, 17 July 2017
13 631 Wed, 26 July 2017 07:03
By: BlackSwan
  Insert statement with bind variable and Create statement
Oracle 10.1
By: jaggub on Fri, 14 July 2017
2 181 Fri, 14 July 2017 19:19
By: Barbara Boehmer
  Pivot columns and dynamically assign values based on column name
Oracle 12.1.0.2, Linux
By: sspn2010 on Thu, 13 July 2017
6 403 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 96 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 195 Wed, 12 July 2017 09:41
By: Deep Chakraborty
  uploading excel with transposed data
By: oracbeg on Wed, 12 July 2017
2 221 Wed, 12 July 2017 07:38
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: Sun Aug 20 08:47:44 CDT 2017

Total time taken to generate the page: 0.04826 seconds