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 671 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 186228 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  SQL Help
12.2.0.1
By: kapilavastu on Thu, 15 November 2018
3 317 Fri, 16 November 2018 03:33
By: cookiemonster
icon5.gif How to use Optimistic locking in my Package
Oracle 12c Release 2 ( 1 2)
By: petar97 on Thu, 08 November 2018
66 2565 Thu, 15 November 2018 06:37
By: cookiemonster
  calculate a function on whole table
oracle 11g
By: ramkumar10 on Sat, 10 November 2018
12 1492 Wed, 14 November 2018 11:54
By: Bill B
  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
10 234 Wed, 14 November 2018 08:28
By: Michel Cadot
icon9.gif Calling Java function from pl/sql
Oracle 11g
By: dineshkumar18 on Wed, 14 November 2018
0 197 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 452 Wed, 14 November 2018 01:09
By: Michel Cadot
OPatch failed with error code = 255 has been moved to Server Administration by the moderator.
  Relationship between two weak entities
By: rjan on Tue, 13 November 2018
1 192 Tue, 13 November 2018 03:30
By: cookiemonster
  How to execute 5 procedures, one after another?
By: nagarajut80 on Mon, 12 November 2018
6 198 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 1543 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 1702 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 745 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 728 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 378 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 684 Fri, 02 November 2018 15:24
By: lott42_gmail
  SQL query
By: james94539 on Thu, 01 November 2018
3 512 Fri, 02 November 2018 02:35
By: Michel Cadot
  DBMS_LOB.SUBSTR
11g
By: EDT on Thu, 01 November 2018
8 413 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 2377 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 1482 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 930 Tue, 30 October 2018 04:16
By: Andrey_R
  Who deleted the data
12c
By: deepakdot on Tue, 23 October 2018
21 2705 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 502 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 855 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 822 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 530 Fri, 26 October 2018 10:47
By: Michel Cadot
  execute immediate (merged)
By: mail_valeria on Fri, 26 October 2018
20 778 Fri, 26 October 2018 08:53
By: cookiemonster
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
4 1218 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 1580 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 1427 Tue, 23 October 2018 22:23
By: Barbara Boehmer
  a procedure with dinamic sql
By: jasminzeni on Wed, 17 October 2018
4 2153 Tue, 23 October 2018 07:33
By: Bill B
  Written Assignment (+ example code) ( 1 2)
By: cwilliam912 on Wed, 17 October 2018
51 3848 Mon, 22 October 2018 08:46
By: Barbara Boehmer
  STORE SQL PROCEDURES
PL/sql
By: glprobot on Fri, 19 October 2018
8 1124 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 2600 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 2477 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 719 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 1561 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 1672 Tue, 16 October 2018 13:44
By: JPBoileau
  DR Failure
By: msyogi on Tue, 16 October 2018
6 984 Tue, 16 October 2018 08:58
By: joy_division
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 Nov 16 07:36:03 CST 2018