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
  DBMS_LOB.SUBSTR
11g
By: EDT on Thu, 01 November 2018
8 1216 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 3307 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 2633 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 1729 Tue, 30 October 2018 04:16
By: Andrey_R
  Who deleted the data
12c
By: deepakdot on Tue, 23 October 2018
21 3677 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 1215 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 1466 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 1057 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 766 Fri, 26 October 2018 10:47
By: Michel Cadot
  execute immediate (merged)
By: mail_valeria on Fri, 26 October 2018
20 1127 Fri, 26 October 2018 08:53
By: cookiemonster
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
4 1386 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 1828 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 1629 Tue, 23 October 2018 22:23
By: Barbara Boehmer
  a procedure with dinamic sql
By: jasminzeni on Wed, 17 October 2018
4 2309 Tue, 23 October 2018 07:33
By: Bill B
  Written Assignment (+ example code) ( 1 2)
By: cwilliam912 on Wed, 17 October 2018
51 4127 Mon, 22 October 2018 08:46
By: Barbara Boehmer
  STORE SQL PROCEDURES
PL/sql
By: glprobot on Fri, 19 October 2018
8 1302 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 2904 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 2843 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 851 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 1738 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 1920 Tue, 16 October 2018 13:44
By: JPBoileau
  DR Failure
By: msyogi on Tue, 16 October 2018
6 1114 Tue, 16 October 2018 08:58
By: joy_division
  Recursive query
By: zhaoquer on Tue, 16 October 2018
8 1141 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 1825 Mon, 15 October 2018 14:33
By: Bill B
  Convert Date in String field (merged)
By: ssmith001 on Tue, 18 September 2018
21 3100 Mon, 15 October 2018 14:09
By: Bill B
  Help with bitmap join indexes
11g
By: Paul Newman on Mon, 08 October 2018
2 1241 Mon, 15 October 2018 10:39
By: Bill B
  Duplicating Excel COUPNCD function in PLSQL.
By: SATHISHENU on Tue, 04 September 2018
9 1777 Sun, 14 October 2018 12:48
By: Barbara Boehmer
  Calculate problem , help me
By: zhaoquer on Sat, 13 October 2018
11 1301 Sat, 13 October 2018 04:01
By: zhaoquer
icon4.gif Complex SQL Quiries for me
11g,12c
By: graphe on Fri, 12 October 2018
6 1213 Fri, 12 October 2018 16:18
By: pablolee
  Error in converting CLOB to BLOB
SQL*Plus: Release 11.2.0.1.0
By: vinodkumarn on Mon, 27 August 2018
6 1677 Fri, 12 October 2018 11:55
By: vinodkumarn
  Return Rows when no data exists
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: ssmith001 on Wed, 10 October 2018
2 826 Wed, 10 October 2018 15:53
By: John Watson
  TRIM function
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
By: wtolentino on Wed, 10 October 2018
3 2265 Wed, 10 October 2018 09:17
By: wtolentino
  https://community.oracle.com/message/14958599#14958599
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: suhaas on Tue, 09 October 2018
1 1074 Tue, 09 October 2018 16:42
By: BlackSwan
  Help required on assigning value to Tabletype variable!
By: ramya29p on Tue, 09 October 2018
5 1152 Tue, 09 October 2018 08:22
By: Solomon Yakobson
  How to merge 2 rows from a table to 1 row (2 columns)
By: dsslim on Mon, 08 October 2018
2 964 Mon, 08 October 2018 20:58
By: dsslim
  HELP NEEDED IN COMPILING PACKAGE
ORACLE 11 G
By: sanjeev.sharda on Thu, 04 October 2018
7 1312 Mon, 08 October 2018 04:28
By: sanjeev.sharda
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
3 906 Sat, 06 October 2018 07:54
By: Michel Cadot
icon5.gif How to read correctly the execution plan in oracle, both in tree and tabular mode?
By: TheMatrix on Thu, 04 October 2018
6 1314 Sat, 06 October 2018 07:49
By: TheMatrix
  If the sting value more then 3 separated need to split into 2nd line
By: mist598 on Fri, 05 October 2018
4 1012 Fri, 05 October 2018 07:26
By: Michel Cadot
  regular expression substring to get the string that is delimited by a comma
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
By: wtolentino on Wed, 03 October 2018
2 996 Thu, 04 October 2018 06:54
By: wtolentino
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: Wed Dec 12 21:55:40 CST 2018