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
  Interval in DBMS_JOB
11.2.0.4
By: azeem87 on Wed, 19 October 2016
2 1583 Thu, 20 October 2016 04:18
By: cookiemonster
  sql query with combination of row values
By: gorants on Wed, 19 October 2016
5 1333 Thu, 20 October 2016 03:09
By: pablolee
  PL/SQL Function fails without an exception
Oracle 12c
By: moverdear on Mon, 19 September 2016
11 1858 Wed, 19 October 2016 09:54
By: BlackSwan
  Insert a space in the middle of a six characther string
Oracle 11g
By: halifaxns on Tue, 18 October 2016
2 1237 Tue, 18 October 2016 11:09
By: halifaxns
  Help required for getting create index DDL on partitioned table.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 18 October 2016
8 3280 Tue, 18 October 2016 08:12
By: Michel Cadot
  star keyword oracle
Oracle 11g
By: ram_orafaq1989 on Mon, 17 October 2016
3 1377 Mon, 17 October 2016 15:06
By: EdStevens
  replace with question mark in the filename
oracle 11.2.0.3
By: pointers on Sat, 15 October 2016
2 1503 Sat, 15 October 2016 06:12
By: pointers
  Confirming Custom Raised Error Exceptions
Oracle 11g
By: Irish88 on Fri, 07 October 2016
6 1905 Fri, 14 October 2016 08:48
By: Irish88
  Update Statement Correction
By: suji6281 on Thu, 13 October 2016
3 1270 Thu, 13 October 2016 11:35
By: Michel Cadot
  ORA-01843: not a valid month and ORA-01847: day of month must be between 1 and last day of month
11.2.0.4
By: azeem87 on Wed, 12 October 2016
10 3823 Thu, 13 October 2016 10:51
By: Solomon Yakobson
icon5.gif How to generate Query aggregation in oracle
Oracle
By: rohansr002 on Wed, 12 October 2016
2 1252 Thu, 13 October 2016 00:31
By: Michel Cadot
  pl/sql table
Oracle 12c
By: SamMen on Wed, 12 October 2016
4 1195 Wed, 12 October 2016 13:01
By: John Watson
  Anonymous block in sql plus
By: SamMen on Tue, 11 October 2016
7 3065 Wed, 12 October 2016 11:38
By: Bill B
  Create Table error
11g
By: Irish88 on Tue, 11 October 2016
3 1420 Wed, 12 October 2016 07:24
By: Irish88
  Unable to Recreate the Procedure
Oracle 10g
By: chat2raj.s on Tue, 11 October 2016
7 1409 Tue, 11 October 2016 08:57
By: chat2raj.s
  Easy Query
By: calamardo114 on Mon, 10 October 2016
8 2120 Tue, 11 October 2016 03:41
By: cookiemonster
  What is Corrected By RowID? I wish to know Missing Numbers in a column
By: graphe on Tue, 11 October 2016
4 1495 Tue, 11 October 2016 03:39
By: Littlefoot
  rows to column text
By: bchowdam on Fri, 07 October 2016
13 3816 Mon, 10 October 2016 19:44
By: Barbara Boehmer
  compile invalid view
By: desmond30 on Mon, 10 October 2016
5 1346 Mon, 10 October 2016 14:47
By: Michel Cadot
  If exists clause in oracle
By: mazeem on Sat, 08 October 2016
6 1653 Sun, 09 October 2016 07:03
By: Solomon Yakobson
icon10.gif Declations unknown
SQL Developer 4.0.3.16
By: Donfox09 on Fri, 07 October 2016
6 1612 Fri, 07 October 2016 21:34
By: Donfox09
  Displaying DESC_TAB parms
Oralce 11g
By: Irish88 on Mon, 03 October 2016
18 4995 Thu, 06 October 2016 13:15
By: Barbara Boehmer
  Count of Data in Each Subpartition
Oracle 11g
By: abhayman on Wed, 05 October 2016
9 2241 Thu, 06 October 2016 13:15
By: Bill B
  view and Cursor behavior :Run time Exception:ORA-00932: inconsistent datatypes: expected - got -
oracle 11g
By: kadhir on Thu, 06 October 2016
5 1504 Thu, 06 October 2016 12:51
By: Bill B
  REGEXP_REPLACE
oracle 11g
By: chavva.kiru@gmail.com on Wed, 05 October 2016
2 1197 Thu, 06 October 2016 00:30
By: Michel Cadot
  Get the deletion date for a certain DB object (Stored Procedure)
11.0.2.10
By: OraFerro on Wed, 05 October 2016
8 1586 Wed, 05 October 2016 09:53
By: Bill B
  EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data API Error
Oracle R12
By: ajayhareesh on Fri, 30 September 2016
7 4049 Mon, 03 October 2016 08:03
By: Bill B
  How to get rolling week count
By: jaggy on Fri, 30 September 2016
15 4112 Mon, 03 October 2016 06:35
By: Michel Cadot
  HTTPS Webservices Issue though PL/SQL
12.1.0.2
By: jeganr on Fri, 30 September 2016
3 5933 Fri, 30 September 2016 12:55
By: John Watson
  Multiple inline query
Oracle 11g
By: Xandot on Mon, 26 September 2016
9 2295 Wed, 28 September 2016 09:49
By: Michel Cadot
  Distinct Comma Separated Values
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Tue, 05 July 2016
9 6089 Wed, 28 September 2016 06:15
By: Xandot
  Fixed Width Flat file via Oracle table
11g,win 7
By: shumail on Thu, 15 September 2016
7 2228 Tue, 27 September 2016 15:42
By: Bill B
  Column Data Modification
Oracle Database 11g Release 2: 11.2.0.1–11.2.0.4
By: LRB495 on Mon, 26 September 2016
2 1220 Tue, 27 September 2016 00:42
By: Michel Cadot
  Date Time problem in sql server
Oracle 10g
By: sss111ind on Fri, 23 September 2016
13 27653 Mon, 26 September 2016 10:07
By: sss111ind
  Nested Query- Result Achieved. Performance improvement ?
10.2.0.1.0
By: bluetooth420 on Thu, 22 September 2016
19 3531 Sun, 25 September 2016 12:22
By: BlackSwan
icon11.gif Count Adult Age in Range Time in 2016
Windows
By: blogbeka on Wed, 21 September 2016
11 1768 Thu, 22 September 2016 04:22
By: cookiemonster
  Missing Record in running Total
10.2.0
By: bluetooth420 on Sat, 17 September 2016
23 3504 Wed, 21 September 2016 02:13
By: bluetooth420
  Materialised views not refreshing
Oracle 11g Release 11.2.0.4.0
By: brown_zzz on Thu, 15 September 2016
2 1249 Mon, 19 September 2016 11:47
By: Michel Cadot
  DECLARE a FUNCTION
By: derrellgore on Thu, 15 September 2016
6 1746 Mon, 19 September 2016 08:59
By: Bill B
  SQL%ROWCOUNT
SQL*Plus: Release 12.1.0.1.0, Linux x86 64-bit
By: anders_e on Fri, 16 September 2016
4 1465 Mon, 19 September 2016 07:27
By: anders_e
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 Jul 31 06:58:56 CDT 2021