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
  Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
Oracle 12.1.
By: rkrishna on Sun, 27 August 2017
10 7318 Sun, 03 September 2017 06:38
By: John Watson
  Oracle lookup function in loop returns rowtype how to get fields from rowtype
Oracle 12g
By: jokrasa on Fri, 25 August 2017
3 10926 Tue, 29 August 2017 03:38
By: cookiemonster
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 18813 Mon, 04 September 2017 02:00
By: quirks
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 6954 Wed, 30 August 2017 02:37
By: pstanand
  Wanted to delete duplicate records
Oracle 11 g
By: samiran_cts on Tue, 22 August 2017
8 7821 Thu, 24 August 2017 10:07
By: samiran_cts
  Applying function on column having multiple datatypes
By: oracbeg on Tue, 22 August 2017
6 763 Tue, 22 August 2017 07:51
By: joy_division
  File compressing is not happening
Oracle 11g , 11.2.0.3.0
By: mm_kanish05 on Tue, 22 August 2017
2 368 Tue, 22 August 2017 03:43
By: cookiemonster
  Using Trigger in Oracle DB to update a table in SQL Server DB
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: queeny on Tue, 22 August 2017
5 2834 Tue, 22 August 2017 07:43
By: Michel Cadot
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 8532 Tue, 29 August 2017 06:19
By: quirks
  Join and group by on multiple tables
Oracle 11g
By: kishor9329 on Mon, 21 August 2017
2 4779 Mon, 21 August 2017 08:10
By: Bill B
  Max function
PL SQL
By: OldDog on Sun, 20 August 2017
9 695 Tue, 22 August 2017 02:51
By: quirks
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 560 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 486 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 292 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 422 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
5 780 Sat, 26 August 2017 07:47
By: Flyby
  Need to get the comma separated value
By: rajeshsvnr on Mon, 14 August 2017
4 445 Thu, 17 August 2017 12:05
By: rajeshsvnr
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
5 693 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 406 Tue, 15 August 2017 07:37
By: John Watson
  Should I Clean Up My Collections?
11g
By: whdyck on Thu, 17 August 2017
8 487 Fri, 18 August 2017 09:37
By: whdyck
  Rectify the code
By: salam_shah on Tue, 08 August 2017
9 704 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
2 363 Mon, 18 September 2017 09:11
By: sss111ind
  Setting Edition // Remote Database
Oracle 11.2.0.4
By: suddhasatwa_oracle on Mon, 07 August 2017
13 704 Fri, 18 August 2017 02:26
By: Michel Cadot
  extract portion of strings
12c
By: m.abdulhaq on Sat, 05 August 2017
6 866 Tue, 08 August 2017 23:09
By: m.abdulhaq
  SQL QUERY
oracle 11g 32-bit, windows7
By: shawaj on Fri, 04 August 2017
5 858 Tue, 08 August 2017 21:28
By: shawaj
  string operations
oracle 11g
By: POGAKU_SANTHOSH on Tue, 01 August 2017
9 1139 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 5128 Tue, 01 August 2017 13:38
By: Solomon Yakobson
  string aggregation
10g
By: praf1981 on Thu, 27 July 2017
2 958 Sun, 30 July 2017 23:42
By: Barbara Boehmer
  Help with sql code
10 G
By: ramkumar10 on Wed, 26 July 2017
4 632 Thu, 27 July 2017 22:45
By: ramkumar10
  member procedure execution
oracle 11g
By: ynkr999 on Tue, 25 July 2017
3 328 Tue, 15 August 2017 00:16
By: Barbara Boehmer
  Weeks, Quarters, and Counts
11g
By: jmltinc on Mon, 24 July 2017
5 253 Mon, 24 July 2017 11:22
By: jmltinc
  Count , Per Week Group by
By: azeem87 on Mon, 24 July 2017
5 705 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 377 Mon, 24 July 2017 07:54
By: joy_division
  Mutating error
Oracle 12.1
By: arifmd1705 on Sat, 22 July 2017
9 408 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 317 Fri, 21 July 2017 10:38
By: Michel Cadot
  utl_file issue
oracle 11g
By: POGAKU_SANTHOSH on Fri, 21 July 2017
2 224 Fri, 21 July 2017 15:16
By: Bill B
  xml question
oracle 11g
By: deb171100 on Thu, 20 July 2017
4 229 Fri, 21 July 2017 06:34
By: Bill B
  oracle external table load
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
2 253 Sun, 23 July 2017 19:09
By: Barbara Boehmer
  Repeat Cursor
12.1.0.2.0
By: SteveShephard on Thu, 20 July 2017
10 336 Fri, 21 July 2017 14:20
By: Barbara Boehmer
  Solution for ora-00020 maximum number of processes
oracle database 8i
By: amjad_alahdal on Thu, 20 July 2017
17 22301 Sun, 20 August 2017 02:23
By: amjad_alahdal
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: Thu Sep 21 14:41:19 CDT 2017

Total time taken to generate the page: 0.32569 seconds