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
  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 10594 Thu, 29 November 2018 04:56
By: chat2raj.s
  Display Time
11g
By: glmjoy on Wed, 28 November 2018
10 4754 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 5692 Wed, 28 November 2018 07:58
By: joy_division
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
9 6687 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 3880 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 4014 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 6422 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 3421 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 2986 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 3335 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 4860 Fri, 23 November 2018 02:16
By: saipradyumn
  SQL Query assistance
12.2
By: jkingqst on Tue, 20 November 2018
30 11894 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 6777 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 2678 Tue, 20 November 2018 07:43
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
20 7186 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 2776 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 4432 Wed, 14 November 2018 01:09
By: Michel Cadot
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 2655 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 3529 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 4543 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 3930 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 3732 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 3242 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 3578 Fri, 02 November 2018 15:24
By: lott42_gmail
  SQL query
By: james94539 on Thu, 01 November 2018
3 4315 Fri, 02 November 2018 02:35
By: Michel Cadot
  DBMS_LOB.SUBSTR
11g
By: EDT on Thu, 01 November 2018
8 3725 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 8786 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 9470 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 4582 Tue, 30 October 2018 04:16
By: Andrey_R
  Who deleted the data
12c
By: deepakdot on Tue, 23 October 2018
21 10419 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 3642 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 3598 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 3866 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 3505 Fri, 26 October 2018 10:47
By: Michel Cadot
  execute immediate (merged)
By: mail_valeria on Fri, 26 October 2018
20 6559 Fri, 26 October 2018 08:53
By: cookiemonster
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
4 3556 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 4537 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 5349 Tue, 23 October 2018 22:23
By: Barbara Boehmer
  a procedure with dinamic sql
By: jasminzeni on Wed, 17 October 2018
4 4760 Tue, 23 October 2018 07:33
By: Bill B
  Written Assignment (+ example code) ( 1 2)
By: cwilliam912 on Wed, 17 October 2018
51 11047 Mon, 22 October 2018 08:46
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: Fri Mar 05 13:36:56 CST 2021