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
  General Question on altering table without locking it
Oracle 11gR2
By: srinivas.k2005 on Fri, 23 November 2018
3 1708 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 2066 Fri, 23 November 2018 02:16
By: saipradyumn
  SQL Query assistance
12.2
By: jkingqst on Tue, 20 November 2018
30 8071 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 4407 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 1347 Tue, 20 November 2018 07:43
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
20 4379 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 1462 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 2072 Wed, 14 November 2018 01:09
By: Michel Cadot
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 1410 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 1835 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 3049 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 2296 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 2088 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 1755 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 2163 Fri, 02 November 2018 15:24
By: lott42_gmail
  SQL query
By: james94539 on Thu, 01 November 2018
3 2229 Fri, 02 November 2018 02:35
By: Michel Cadot
  DBMS_LOB.SUBSTR
11g
By: EDT on Thu, 01 November 2018
8 1897 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 4466 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 6018 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 2591 Tue, 30 October 2018 04:16
By: Andrey_R
  Who deleted the data
12c
By: deepakdot on Tue, 23 October 2018
21 7035 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 1959 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 2120 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 1868 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 1513 Fri, 26 October 2018 10:47
By: Michel Cadot
  execute immediate (merged)
By: mail_valeria on Fri, 26 October 2018
20 3832 Fri, 26 October 2018 08:53
By: cookiemonster
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
4 2058 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 2593 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 2372 Tue, 23 October 2018 22:23
By: Barbara Boehmer
  a procedure with dinamic sql
By: jasminzeni on Wed, 17 October 2018
4 2980 Tue, 23 October 2018 07:33
By: Bill B
  Written Assignment (+ example code) ( 1 2)
By: cwilliam912 on Wed, 17 October 2018
51 5794 Mon, 22 October 2018 08:46
By: Barbara Boehmer
  STORE SQL PROCEDURES
PL/sql
By: glprobot on Fri, 19 October 2018
8 2116 Fri, 19 October 2018 08:46
By: cookiemonster
  Run dbms_scheduler.create_job with arguments
Oracle 11.2.0.1.0
By: dansrnt on Fri, 13 May 2016
26 5254 Thu, 18 October 2018 13:43
By: Bill B
  Written Assignment-Printing a Record Using an If Statement
By: cwilliam912 on Sun, 14 October 2018
25 6575 Thu, 18 October 2018 04:02
By: cookiemonster
  SQL Query to be grouped based on Column values
By: sober_sandy on Wed, 17 October 2018
1 1354 Wed, 17 October 2018 04:39
By: Michel Cadot
  Count of Pending, Failed, Running, Completed records
Oracle 12c
By: user_5678 on Mon, 15 October 2018
8 2555 Wed, 17 October 2018 00:39
By: user_5678
  Pulling hair out trying to use table function
Oracle 11
By: jbarker36 on Fri, 12 October 2018
16 2993 Tue, 16 October 2018 13:44
By: JPBoileau
  DR Failure
By: msyogi on Tue, 16 October 2018
6 1840 Tue, 16 October 2018 08:58
By: joy_division
  Recursive query
By: zhaoquer on Tue, 16 October 2018
8 1614 Tue, 16 October 2018 06:40
By: zhaoquer
  Rownumer WITH OUT Order by
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 29 September 2018
13 2686 Mon, 15 October 2018 14:33
By: Bill B
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 15 19:59:32 CDT 2019