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
  NVL not working in Cursor Subquery
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Wed, 19 December 2018
4 3901 Mon, 24 December 2018 11:26
By: Bill B
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
4 4174 Mon, 24 December 2018 05:52
By: Barbara Boehmer
  Date for Sunday prior to given date
Oracle
By: ssmith001 on Thu, 20 December 2018
4 3015 Thu, 20 December 2018 13:56
By: Solomon Yakobson
  date conversion
oracle 11g
By: guddu_12 on Thu, 20 December 2018
6 3621 Thu, 20 December 2018 10:17
By: Michel Cadot
  Count function
11G
By: ABG on Wed, 19 December 2018
6 3610 Thu, 20 December 2018 10:02
By: ABG
  Multiple Row Record Insert Into One Field And Email
Oracle Forms 6i ( User Activity Audit Logs )
By: ka_wish on Thu, 20 December 2018
4 3259 Thu, 20 December 2018 07:18
By: cookiemonster
  Execution plan alters with DDL change
Oracle 11gR2
By: srinivas.k2005 on Fri, 23 November 2018
13 5275 Thu, 20 December 2018 07:06
By: EdStevens
  Error using API
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Thu, 30 August 2018
4 3872 Wed, 19 December 2018 14:26
By: Michel Cadot
  XML Through PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Thu, 01 November 2018
20 9547 Wed, 19 December 2018 14:26
By: Michel Cadot
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
18 14360 Tue, 18 December 2018 07:17
By: Barbara Boehmer
  APEX (merged 3 duplicate posts)
Oracle APEX
By: rkapex on Tue, 18 December 2018
5 3114 Tue, 18 December 2018 05:55
By: Michel Cadot
  Cannot insert specific char
Oracle 11.2.0.1.0 - 64bit, Linux OEL 6
By: Andrey_R on Sat, 15 December 2018
10 4156 Mon, 17 December 2018 04:06
By: Andrey_R
  Trigger Error ORA-00604
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: wtolentino on Thu, 13 December 2018
8 5786 Thu, 13 December 2018 12:24
By: joy_division
  Question on rank over partition
Oracle 11g
By: fonzi on Sun, 09 December 2018
16 4899 Mon, 10 December 2018 06:27
By: fonzi
  Problem with the product user profile
Oracle 12c Release 2
By: petar97 on Fri, 07 December 2018
12 7355 Mon, 10 December 2018 03:24
By: cookiemonster
  Need some help understanding parallels
oracle 12c, Red Hat Linux
By: sureshonly@hotmail.com on Wed, 05 December 2018
9 4287 Sat, 08 December 2018 08:33
By: BlackSwan
  Column union
11.1.2.10
By: OraFerro on Thu, 06 December 2018
9 3034 Thu, 06 December 2018 14:08
By: Michel Cadot
  Fill in missing data
12.2
By: lott42_gmail on Thu, 06 December 2018
1 2387 Thu, 06 December 2018 13:36
By: lott42_gmail
  SQL Help
12.2.0.1
By: kapilavastu on Thu, 15 November 2018
6 6830 Tue, 04 December 2018 08:07
By: joy_division
icon5.gif How to use Optimistic locking in my Package
Oracle 12c Release 2 ( 1 2 3)
By: petar97 on Thu, 08 November 2018
80 24755 Mon, 03 December 2018 04:59
By: cookiemonster
  Charater set
Oracle Database, 12.1.0.2,Windows
By: youngb912 on Tue, 27 November 2018
9 5577 Fri, 30 November 2018 06:27
By: gazzag
  Fetching data dynamically in Collections
Forms 6i, Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: chat2raj.s on Tue, 27 November 2018
21 10733 Thu, 29 November 2018 04:56
By: chat2raj.s
  Display Time
11g
By: glmjoy on Wed, 28 November 2018
10 4858 Wed, 28 November 2018 09:19
By: cookiemonster
  Check for status of a computer in the network
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: chat2raj.s on Wed, 14 November 2018
14 5822 Wed, 28 November 2018 07:58
By: joy_division
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
9 6836 Tue, 27 November 2018 23:42
By: chat2raj.s
  Writing Arabic Text using UTL_FILE
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
By: chat2raj.s on Mon, 24 September 2018
2 3971 Tue, 27 November 2018 23:32
By: chat2raj.s
  DBMS_SCHEDULER
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: chat2raj.s on Tue, 16 October 2018
5 4111 Tue, 27 November 2018 23:21
By: chat2raj.s
  How to get apps view DDL statement from non-apps schema
Oracle R12
By: ajayhareesh on Mon, 26 November 2018
14 6529 Mon, 26 November 2018 08:39
By: Solomon Yakobson
  How to run the procedure that have array output?
By: Ican321 on Mon, 26 November 2018
4 3499 Mon, 26 November 2018 05:40
By: Michel Cadot
  HAVING ISSUES UNDERSTANDING HOW TO SOLVE THIS ORACLE QUESTION
ORACLE SQL
By: pastorfloxy1@gmail.com on Sat, 24 November 2018
3 3082 Sun, 25 November 2018 01:21
By: Michel Cadot
  General Question on altering table without locking it
Oracle 11gR2
By: srinivas.k2005 on Fri, 23 November 2018
3 3436 Fri, 23 November 2018 11:28
By: srinivas.k2005
  MV Refresh on Partitioned Materialized views
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 22 November 2018
11 5049 Fri, 23 November 2018 02:16
By: saipradyumn
  SQL Query assistance
12.2
By: jkingqst on Tue, 20 November 2018
30 12054 Thu, 22 November 2018 03:44
By: jkingqst
  How to display the letter starting with "B" followed by number only.
Oracle 11g
By: ajaykumarkona on Thu, 09 January 2014
14 6924 Tue, 20 November 2018 10:58
By: gazzag
  Are following statements executed in any case if the first one throws an exception?
By: katherineamt on Tue, 20 November 2018
1 2760 Tue, 20 November 2018 07:43
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
20 7392 Sat, 17 November 2018 12:10
By: ramkumar10
icon9.gif Calling Java function from pl/sql
Oracle 11g
By: dineshkumar18 on Wed, 14 November 2018
0 2889 Wed, 14 November 2018 04:32
By: dineshkumar18
  resource busy and acquire with NOWAIT specified or timeout expired
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 13 November 2018
10 4603 Wed, 14 November 2018 01:09
By: Michel Cadot
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 2745 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 3625 Mon, 12 November 2018 05:26
By: Michel Cadot
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: Mon Apr 19 20:48:21 CDT 2021