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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
0 1480 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 190394 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  Cannot insert specific char
Oracle 11.2.0.1.0 - 64bit, Linux OEL 6
By: Andrey_R on Sat, 15 December 2018
0 34 Sat, 15 December 2018 15:39
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 257 Thu, 13 December 2018 12:24
By: joy_division
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
9 6093 Thu, 13 December 2018 09:14
By: cookiemonster
  Transactions than can be rejected, temporary tables or not?
11.1.2.10
By: OraFerro on Mon, 10 December 2018
6 471 Tue, 11 December 2018 01:48
By: OraFerro
  Question on rank over partition
Oracle 11g
By: fonzi on Sun, 09 December 2018
16 525 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 437 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 684 Sat, 08 December 2018 08:33
By: BlackSwan
  RETURNING BULK COLLECT INTO COLLECTION
12C
By: shawaj on Fri, 23 November 2018
7 1298 Thu, 06 December 2018 15:19
By: BlackSwan
  Column union
11.1.2.10
By: OraFerro on Thu, 06 December 2018
9 392 Thu, 06 December 2018 14:08
By: Michel Cadot
  Fill in missing data
12.2
By: lott42_gmail on Thu, 06 December 2018
1 233 Thu, 06 December 2018 13:36
By: lott42_gmail
  SQL Help
12.2.0.1
By: kapilavastu on Thu, 15 November 2018
6 3952 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 7072 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 1840 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 2257 Thu, 29 November 2018 04:56
By: chat2raj.s
  Display Time
11g
By: glmjoy on Wed, 28 November 2018
10 1932 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 1922 Wed, 28 November 2018 07:58
By: joy_division
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
9 3038 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 1510 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 1536 Tue, 27 November 2018 23:21
By: chat2raj.s
  Execution plan alters with DDL change
Oracle 11gR2
By: srinivas.k2005 on Fri, 23 November 2018
11 1234 Mon, 26 November 2018 11:26
By: Bill B
  How to get apps view DDL statement from non-apps schema
Oracle R12
By: ajayhareesh on Mon, 26 November 2018
14 1153 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 837 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 814 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 921 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 1297 Fri, 23 November 2018 02:16
By: saipradyumn
  SQL Query assistance
12.2
By: jkingqst on Tue, 20 November 2018
30 3978 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 2592 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 845 Tue, 20 November 2018 07:43
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
20 3203 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 1078 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 1323 Wed, 14 November 2018 01:09
By: Michel Cadot
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 977 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 1089 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 2371 Sun, 11 November 2018 05:19
By: Barbara Boehmer
  XML Through PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Thu, 01 November 2018
19 2742 Fri, 09 November 2018 10:44
By: Michel Cadot
  List of Months between 2 dates
12.2
By: lott42_gmail on Mon, 05 November 2018
7 1636 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 1515 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 1192 Mon, 05 November 2018 05:10
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: Sat Dec 15 19:48:37 CST 2018