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
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 34354 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 8442 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 14489 Thu, 29 November 2018 04:56
By: chat2raj.s
  Display Time
11g
By: glmjoy on Wed, 28 November 2018
10 7295 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 8438 Wed, 28 November 2018 07:58
By: joy_division
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
9 8767 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 5684 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 5859 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 9313 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 5238 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 5255 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 4905 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 8856 Fri, 23 November 2018 02:16
By: saipradyumn
  SQL Query assistance
12.2
By: jkingqst on Tue, 20 November 2018
30 16361 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 9410 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 4207 Tue, 20 November 2018 07:43
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
20 11270 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 4604 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 7891 Wed, 14 November 2018 01:09
By: Michel Cadot
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 4091 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 5298 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 6612 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 6368 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 6154 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 4621 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 5607 Fri, 02 November 2018 15:24
By: lott42_gmail
  SQL query
By: james94539 on Thu, 01 November 2018
3 6642 Fri, 02 November 2018 02:35
By: Michel Cadot
  DBMS_LOB.SUBSTR
11g
By: EDT on Thu, 01 November 2018
8 6267 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 17417 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 13495 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 7231 Tue, 30 October 2018 04:16
By: Andrey_R
  Who deleted the data
12c
By: deepakdot on Tue, 23 October 2018
21 13133 Mon, 29 October 2018 02:10
By: deepakdot
  How to make a trigger on the table for the history table
Oracle 12c Release 2
By: petar97 on Sun, 28 October 2018
7 5951 Sun, 28 October 2018 14:57
By: Michel Cadot
  How to tune Query on Large Oracle Table
By: sacharya2017 on Thu, 25 October 2018
9 5884 Fri, 26 October 2018 12:51
By: sacharya2017
  Generate Random Id's of existing Id's
12.2
By: lott42_gmail on Thu, 25 October 2018
14 7518 Fri, 26 October 2018 12:13
By: lott42_gmail
  Replace strings [merged by jd]
Oracle RDBMS, 12.1, Windows
By: unna on Fri, 26 October 2018
9 6736 Fri, 26 October 2018 10:47
By: Michel Cadot
  execute immediate (merged)
By: mail_valeria on Fri, 26 October 2018
20 10632 Fri, 26 October 2018 08:53
By: cookiemonster
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
4 5794 Thu, 25 October 2018 13:04
By: Barbara Boehmer
  query performance
EBS R12, db-10.1.1.2
By: annu-agi on Wed, 19 September 2018
9 7912 Wed, 24 October 2018 00:25
By: Michel Cadot
  PLS-00201: identifier 'CTX_DDL' must be declared
By: Sania Fatimi on Tue, 23 October 2018
4 9346 Tue, 23 October 2018 22:23
By: Barbara Boehmer
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 Jun 01 02:33:15 CDT 2024