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
  APEX (merged 3 duplicate posts)
Oracle APEX
By: rkapex on Tue, 18 December 2018
5 2684 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 3632 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 4978 Thu, 13 December 2018 12:24
By: joy_division
  Question on rank over partition
Oracle 11g
By: fonzi on Sun, 09 December 2018
16 4418 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 6755 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 3846 Sat, 08 December 2018 08:33
By: BlackSwan
  Column union
11.1.2.10
By: OraFerro on Thu, 06 December 2018
9 2636 Thu, 06 December 2018 14:08
By: Michel Cadot
  Fill in missing data
12.2
By: lott42_gmail on Thu, 06 December 2018
1 2030 Thu, 06 December 2018 13:36
By: lott42_gmail
  SQL Help
12.2.0.1
By: kapilavastu on Thu, 15 November 2018
6 6434 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 23461 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 4996 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 10188 Thu, 29 November 2018 04:56
By: chat2raj.s
  Display Time
11g
By: glmjoy on Wed, 28 November 2018
10 4508 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 5305 Wed, 28 November 2018 07:58
By: joy_division
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
9 6173 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 3548 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 3573 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 6083 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 3137 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 2683 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 3042 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 4278 Fri, 23 November 2018 02:16
By: saipradyumn
  SQL Query assistance
12.2
By: jkingqst on Tue, 20 November 2018
30 11454 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 6357 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 2358 Tue, 20 November 2018 07:43
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
20 6619 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 2418 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 3958 Wed, 14 November 2018 01:09
By: Michel Cadot
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 2423 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 3261 Mon, 12 November 2018 05:26
By: Michel Cadot
  Last and Sum in group by
11.1.2.10
By: OraFerro on Thu, 27 September 2018
3 4234 Sun, 11 November 2018 05:19
By: Barbara Boehmer
  List of Months between 2 dates
12.2
By: lott42_gmail on Mon, 05 November 2018
7 3591 Wed, 07 November 2018 15:07
By: lott42_gmail
  ORA-00904 on selecting by column name
By: chat2raj.s on Tue, 06 November 2018
4 3351 Tue, 06 November 2018 04:35
By: chat2raj.s
  PL/SQL error Ora-06502
Oracle 11g, Reports builder 6i
By: kmack on Mon, 05 November 2018
3 2923 Mon, 05 November 2018 05:10
By: Michel Cadot
  Ranking data by a set of data maybe using analytical function
12.2
By: lott42_gmail on Thu, 01 November 2018
7 3291 Fri, 02 November 2018 15:24
By: lott42_gmail
  SQL query
By: james94539 on Thu, 01 November 2018
3 3903 Fri, 02 November 2018 02:35
By: Michel Cadot
  DBMS_LOB.SUBSTR
11g
By: EDT on Thu, 01 November 2018
8 3396 Thu, 01 November 2018 15:31
By: Michel Cadot
  How to print Boolean or True/False value in Sql
Oracle 12c, Windows
By: akssre on Wed, 07 March 2018
15 7720 Thu, 01 November 2018 08:29
By: joy_division
  How to allow multi-users in Procedure
Oracle 12c
By: petar97 on Fri, 26 October 2018
21 9063 Thu, 01 November 2018 06:52
By: EdStevens
  date column displays strange output
Oracle 11g RAC, Linux OEL 6
By: Andrey_R on Mon, 29 October 2018
12 4251 Tue, 30 October 2018 04:16
By: Andrey_R
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: Fri Sep 25 05:26:04 CDT 2020