|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
compile invalid view |
5 |
1932 |
Mon, 10 October 2016 14:47 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
If exists clause in oracle By: mazeem on Sat, 08 October 2016 |
6 |
2758 |
Sun, 09 October 2016 07:03 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon10.gif](/forum/images/message_icons/icon10.gif) |
Declations unknown SQL Developer 4.0.3.16 |
6 |
2318 |
Fri, 07 October 2016 21:34 By: Donfox09 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Displaying DESC_TAB parms Oralce 11g By: Irish88 on Mon, 03 October 2016 |
18 |
7124 |
Thu, 06 October 2016 13:15 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Count of Data in Each Subpartition Oracle 11g |
9 |
2900 |
Thu, 06 October 2016 13:15 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
view and Cursor behavior :Run time Exception:ORA-00932: inconsistent datatypes: expected - got - oracle 11g By: kadhir on Thu, 06 October 2016 |
5 |
2003 |
Thu, 06 October 2016 12:51 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
REGEXP_REPLACE oracle 11g |
2 |
1738 |
Thu, 06 October 2016 00:30 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Get the deletion date for a certain DB object (Stored Procedure) 11.0.2.10 |
8 |
2115 |
Wed, 05 October 2016 09:53 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data API Error Oracle R12 |
7 |
5338 |
Mon, 03 October 2016 08:03 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to get rolling week count By: jaggy on Fri, 30 September 2016 |
15 |
5485 |
Mon, 03 October 2016 06:35 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
HTTPS Webservices Issue though PL/SQL 12.1.0.2 By: jeganr on Fri, 30 September 2016 |
3 |
8210 |
Fri, 30 September 2016 12:55 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Multiple inline query Oracle 11g By: Xandot on Mon, 26 September 2016 |
9 |
3357 |
Wed, 28 September 2016 09:49 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
8170 |
Wed, 28 September 2016 06:15 By: Xandot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Fixed Width Flat file via Oracle table 11g,win 7 By: shumail on Thu, 15 September 2016 |
7 |
3166 |
Tue, 27 September 2016 15:42 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Column Data Modification Oracle Database 11g Release 2: 11.2.0.1–11.2.0.4 By: LRB495 on Mon, 26 September 2016 |
2 |
1732 |
Tue, 27 September 2016 00:42 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Date Time problem in sql server Oracle 10g |
13 |
28997 |
Mon, 26 September 2016 10:07 By: sss111ind ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Nested Query- Result Achieved. Performance improvement ? 10.2.0.1.0 |
19 |
4545 |
Sun, 25 September 2016 12:22 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon11.gif](/forum/images/message_icons/icon11.gif) |
Count Adult Age in Range Time in 2016 Windows |
11 |
2452 |
Thu, 22 September 2016 04:22 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Missing Record in running Total 10.2.0 |
23 |
4892 |
Wed, 21 September 2016 02:13 By: bluetooth420 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Materialised views not refreshing Oracle 11g Release 11.2.0.4.0 |
2 |
1777 |
Mon, 19 September 2016 11:47 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DECLARE a FUNCTION |
6 |
2312 |
Mon, 19 September 2016 08:59 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL%ROWCOUNT SQL*Plus: Release 12.1.0.1.0, Linux x86 64-bit |
4 |
2071 |
Mon, 19 September 2016 07:27 By: anders_e ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Dynamic SQL : ORA-01006: bind variable does not exist (merged) Oracle R12 |
12 |
8083 |
Sun, 18 September 2016 14:01 By: ajayhareesh ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
3484 |
Fri, 16 September 2016 10:12 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Enforce blank record Oracle 11G |
3 |
1717 |
Thu, 15 September 2016 12:49 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Global Temporary Tables |
12 |
3724 |
Thu, 15 September 2016 03:19 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Data grouping Oracle 11g |
7 |
2276 |
Thu, 15 September 2016 02:17 By: srinivas.k2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Invalid Chars notify differently in different file editors 11G |
6 |
1904 |
Tue, 13 September 2016 02:46 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
1538 |
Mon, 12 September 2016 19:45 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Group by Multiple Values Oracle 11.2.0.3 Windows By: Duane on Mon, 12 September 2016 |
1 |
1640 |
Mon, 12 September 2016 19:08 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Improve nested Query, if possible 10.2.0 |
6 |
2549 |
Mon, 12 September 2016 06:59 By: Flyby ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Problems converting String to data By: RubenDC on Mon, 12 September 2016 |
5 |
1974 |
Mon, 12 September 2016 06:43 By: RubenDC ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Unique Constraint With DEFERRABLE INITIALLY DEFERRED NOVALIDATE Oracle 11g 11.2.0.4.0 By: fixxxer on Fri, 09 September 2016 |
17 |
8261 |
Sun, 11 September 2016 00:48 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Format result set of a union DB 10g |
24 |
5561 |
Wed, 07 September 2016 03:56 By: sandeep_orafaq ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Select columns based on first record (Header from flat file) Oracle 11g, Windows 2012 R2 |
20 |
4930 |
Wed, 07 September 2016 03:25 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Unpivot or Connect by Oracle 11.2.0.3 Windows By: Duane on Tue, 06 September 2016 |
2 |
1235 |
Tue, 06 September 2016 14:31 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
select statement to split string as per the content and show it oracle 11g, windows |
5 |
2125 |
Mon, 05 September 2016 04:20 By: sandeep_orafaq ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Hierarchy view Oracle Database 12c Standard Edition Release 12.1.0.2.0 |
2 |
1994 |
Sat, 03 September 2016 17:52 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Mail Notification |
4 |
2248 |
Fri, 02 September 2016 07:22 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query to find special alphabets Oracle 11g Release 2, Linux |
5 |
2035 |
Thu, 01 September 2016 06:33 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |