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
  compile invalid view
By: desmond30 on Mon, 10 October 2016
5 506 Mon, 10 October 2016 14:47
By: Michel Cadot
  If exists clause in oracle
By: mazeem on Sat, 08 October 2016
6 630 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 568 Fri, 07 October 2016 21:34
By: Donfox09
  rows to column text
By: bchowdam on Fri, 07 October 2016
13 866 Mon, 10 October 2016 19:44
By: Barbara Boehmer
  view and Cursor behavior :Run time Exception:ORA-00932: inconsistent datatypes: expected - got -
oracle 11g
By: kadhir on Thu, 06 October 2016
5 497 Thu, 06 October 2016 12:51
By: Bill B
  Count of Data in Each Subpartition
Oracle 11g
By: abhayman on Wed, 05 October 2016
9 606 Thu, 06 October 2016 13:15
By: Bill B
  REGEXP_REPLACE
oracle 11g
By: chavva.kiru@gmail.com on Wed, 05 October 2016
2 468 Thu, 06 October 2016 00:30
By: Michel Cadot
  Displaying DESC_TAB parms
Oralce 11g
By: Irish88 on Mon, 03 October 2016
18 1085 Thu, 06 October 2016 13:15
By: Barbara Boehmer
  Get the deletion date for a certain DB object (Stored Procedure)
11.0.2.10
By: OraFerro on Wed, 05 October 2016
8 448 Wed, 05 October 2016 09:53
By: Bill B
  PL/SQL: numeric or value error: character string buffer too small
11.2.0.4
By: grpatwari on Mon, 24 October 2016
23 2324 Tue, 14 February 2017 00:16
By: grpatwari
  Partition Removing
Oracle 11g
By: saipradyumn on Mon, 03 October 2016
8 744 Wed, 02 November 2016 01:21
By: saipradyumn
  Default Character type of the column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 01 October 2016
6 864 Wed, 02 November 2016 06:08
By: Solomon Yakobson
  EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data API Error
Oracle R12
By: ajayhareesh on Fri, 30 September 2016
7 1153 Mon, 03 October 2016 08:03
By: Bill B
  How to get rolling week count
By: jaggy on Fri, 30 September 2016
15 1094 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 976 Fri, 30 September 2016 12:55
By: John Watson
  Confirming Custom Raised Error Exceptions
Oracle 11g
By: Irish88 on Fri, 07 October 2016
6 700 Fri, 14 October 2016 08:48
By: Irish88
  Column Data Modification
Oracle Database 11g Release 2: 11.2.0.1–11.2.0.4
By: LRB495 on Mon, 26 September 2016
2 453 Tue, 27 September 2016 00:42
By: Michel Cadot
  Multiple inline query
Oracle 11g
By: Xandot on Mon, 26 September 2016
9 907 Wed, 28 September 2016 09:49
By: Michel Cadot
  Date Time problem in sql server
Oracle 10g
By: sss111ind on Fri, 23 September 2016
13 4988 Mon, 26 September 2016 10:07
By: sss111ind
icon11.gif Count Adult Age in Range Time in 2016
Windows
By: blogbeka on Wed, 21 September 2016
11 643 Thu, 22 September 2016 04:22
By: cookiemonster
  Dynamic SQL : ORA-01006: bind variable does not exist (merged)
Oracle R12
By: ajayhareesh on Sun, 18 September 2016
12 1047 Sun, 18 September 2016 14:01
By: ajayhareesh
  Missing Record in running Total
10.2.0
By: bluetooth420 on Sat, 17 September 2016
23 1223 Wed, 21 September 2016 02:13
By: bluetooth420
  SQL%ROWCOUNT
SQL*Plus: Release 12.1.0.1.0, Linux x86 64-bit
By: anders_e on Fri, 16 September 2016
4 649 Mon, 19 September 2016 07:27
By: anders_e
  ORA-01847: day of month must be between 1 and last day of month 01847. 00000 - "day of month must b
Oracle
By: ROHIN on Fri, 16 September 2016
4 521 Fri, 16 September 2016 10:12
By: BlackSwan
icon5.gif Enforce blank record
Oracle 11G
By: OlafCologne on Thu, 15 September 2016
3 373 Thu, 15 September 2016 12:49
By: Michel Cadot
  DECLARE a FUNCTION
By: derrellgore on Thu, 15 September 2016
6 639 Mon, 19 September 2016 08:59
By: Bill B
  Materialised views not refreshing
Oracle 11g Release 11.2.0.4.0
By: brown_zzz on Thu, 15 September 2016
2 541 Mon, 19 September 2016 11:47
By: Michel Cadot
  Data grouping
Oracle 11g
By: srinivas.k2005 on Wed, 14 September 2016
7 644 Thu, 15 September 2016 02:17
By: srinivas.k2005
  PL/SQL Function fails without an exception
Oracle 12c
By: moverdear on Mon, 19 September 2016
11 735 Wed, 19 October 2016 09:54
By: BlackSwan
  Invalid Chars notify differently in different file editors
11G
By: harshadsp on Tue, 13 September 2016
6 564 Tue, 13 September 2016 02:46
By: Michel Cadot
  Group by Multiple Values
Oracle 11.2.0.3 Windows
By: Duane on Mon, 12 September 2016
1 625 Mon, 12 September 2016 19:08
By: Solomon Yakobson
  When we get the "Outbound Variable" Error in PLSQL
When we get the "Outbound Variable" Error in PLSQL
By: msyogi on Mon, 12 September 2016
2 452 Mon, 12 September 2016 19:45
By: BlackSwan
  Fixed Width Flat file via Oracle table
11g,win 7
By: shumail on Thu, 15 September 2016
7 719 Tue, 27 September 2016 15:42
By: Bill B
  Unique Constraint With DEFERRABLE INITIALLY DEFERRED NOVALIDATE
Oracle 11g 11.2.0.4.0
By: fixxxer on Fri, 09 September 2016
17 1333 Sun, 11 September 2016 00:48
By: Michel Cadot
  Improve nested Query, if possible
10.2.0
By: bluetooth420 on Sun, 11 September 2016
6 720 Mon, 12 September 2016 06:59
By: Flyby
  Global Temporary Tables
By: derrellgore on Tue, 13 September 2016
12 933 Thu, 15 September 2016 03:19
By: cookiemonster
  Problems converting String to data
By: RubenDC on Mon, 12 September 2016
5 507 Mon, 12 September 2016 06:43
By: RubenDC
  Unpivot or Connect by
Oracle 11.2.0.3 Windows
By: Duane on Tue, 06 September 2016
2 340 Tue, 06 September 2016 14:31
By: Michel Cadot
  Select columns based on first record (Header from flat file)
Oracle 11g, Windows 2012 R2
By: rahul1982 on Tue, 06 September 2016
20 1397 Wed, 07 September 2016 03:25
By: Michel Cadot
  Hierarchy view
Oracle Database 12c Standard Edition Release 12.1.0.2.0
By: steveshephard87 on Sat, 03 September 2016
2 528 Sat, 03 September 2016 17:52
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: Sat Sep 23 11:37:37 CDT 2017

Total time taken to generate the page: 0.06505 seconds