|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to Avoid ORA-01438: value larger than specified precision allowed for this column Oracle11g By: ssyr on Fri, 24 November 2017 |
23 |
26367 |
Mon, 27 November 2017 06:01 By: ssyr ![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) |
|
Procedure By: rkapex on Sat, 25 November 2017 |
3 |
4618 |
Mon, 27 November 2017 03:25 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) |
|
Using views to summarise payment info Oracle SQL 12 By: Rugad on Sun, 26 November 2017 |
1 |
3680 |
Sun, 26 November 2017 16:44 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) |
|
help convert mac address string to hex oracle 12c |
7 |
5738 |
Sun, 26 November 2017 14:16 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) |
|
Array ORA-06533: Subscript beyond count 11.0.2.10 |
8 |
33115 |
Sat, 25 November 2017 23:01 By: OraFerro ![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) |
|
Oracle Sub-query and AND clause behaviour 11g By: LKT on Sun, 19 November 2017 |
3 |
4147 |
Fri, 24 November 2017 09:11 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Unable to grant Admin privileges on SQL Developer 12c Oracle SQL Developer 12c |
6 |
5017 |
Fri, 24 November 2017 02:20 By: Littlefoot ![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) |
|
Drop Function gives error oracle 12c Windows 2012 |
6 |
5654 |
Wed, 22 November 2017 07:05 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) |
|
how can get Three consecutive days |
5 |
5009 |
Mon, 20 November 2017 05:21 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) |
|
grouping in matrix 12c |
3 |
3957 |
Mon, 20 November 2017 05:02 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) |
|
Query Analysis Oracle 12c |
7 |
4427 |
Mon, 20 November 2017 04:53 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) |
|
Passing warning collection from PL/SQL 11.0.2.10 |
2 |
4131 |
Sun, 19 November 2017 22:27 By: OraFerro ![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 01882 Sql Developer, 1.5.1.54.40, Windows Server 2003 |
24 |
16917 |
Sun, 19 November 2017 14:23 By: ashisheck ![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_SUBSTR ORACLE,12C,UNIX |
4 |
4047 |
Fri, 17 November 2017 10:21 By: pstanand ![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) |
|
PL/SQL: SQL Statement Ignored ORACLE XE sql developer version 17.3.0.271 |
9 |
37712 |
Fri, 17 November 2017 05:35 By: malflowers ![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) |
|
oracle external table issue oracle 11g |
6 |
4526 |
Sun, 12 November 2017 11:51 By: POGAKU_SANTHOSH ![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) |
|
update query 11.2.0.4 |
9 |
46380 |
Fri, 10 November 2017 01:43 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) |
|
MATERIALIZED VIEW TNS for 64-bit Windows: Version 11.2.0.1.0 - Production By: shawaj on Wed, 08 November 2017 |
7 |
34176 |
Thu, 09 November 2017 07:10 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 datewise howmany records oracle 12c By: mvrkr44 on Thu, 09 November 2017 |
4 |
13746 |
Thu, 09 November 2017 04:14 By: mvrkr44 ![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) |
|
Re: PL/SQL:How to use VARRAY in the USING clause of EXECUTE IMMEDIATE? split from http://www.orafaq.com/forum/t/161791/ |
10 |
33626 |
Thu, 09 November 2017 04:00 By: moracles ![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) |
|
Order of Trigger Types 11g Release 11.2.0.3.0 By: whdyck on Mon, 06 November 2017 |
4 |
27862 |
Tue, 07 November 2017 08:18 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 can get five days |
11 |
216451 |
Mon, 06 November 2017 02:02 By: quirks ![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) |
|
Prevent deletion 12c |
8 |
6882 |
Sat, 04 November 2017 10:39 By: m.abdulhaq ![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-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION Oracle8i Enterprise Edition Release 8.1.7.0.0 /windows7 By: shawaj on Fri, 03 November 2017 |
3 |
9069 |
Sat, 04 November 2017 03:40 By: Littlefoot ![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) |
|
TABLE PARTITIONING Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 By: shawaj on Thu, 02 November 2017 |
3 |
65545 |
Fri, 03 November 2017 07:55 By: shawaj ![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-06502: PL/SQL: numeric or value error. Oracle 4.0 By: WhoAmI on Wed, 01 November 2017 |
9 |
180460 |
Fri, 03 November 2017 07:35 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) |
|
Modify procedure calculation for readability Oracle 11.2.0.4 By: veepee on Sun, 29 October 2017 |
17 |
442683 |
Thu, 02 November 2017 16:44 By: veepee ![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) |
|
to_char date conversion not working oracle 11 for Windows 10 By: gunderj on Wed, 01 November 2017 |
8 |
271704 |
Thu, 02 November 2017 04:15 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) |
|
NO_CPU_COSTING hint Oracle 12c |
3 |
119584 |
Tue, 31 October 2017 03:09 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 Rows to a Single Row oracle 10g By: bond007 on Mon, 16 October 2017 |
20 |
76069 |
Sat, 28 October 2017 19:19 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] Linux,11gR2 11.1.2.2.0 oracle forms and reports, oracle 11g database |
1 |
4588 |
Wed, 25 October 2017 07:14 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) |
|
SQL help on hierarchy data Oracle 10g and DB2 |
3 |
40716 |
Tue, 24 October 2017 11:57 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) |
|
Using Oracle Parallel hint |
9 |
69674 |
Tue, 24 October 2017 08:07 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) |
|
Changing the date format on a specific field |
10 |
44941 |
Mon, 23 October 2017 07:41 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) |
|
virtual private database oracle database 12c By: smaher on Fri, 20 October 2017 |
4 |
5229 |
Sat, 21 October 2017 04:16 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) |
|
REPLACE Function Oracle,12c,Unix |
6 |
87393 |
Fri, 20 October 2017 08:37 By: pstanand ![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) |
|
DBTime Zone&Off Set Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
2 |
40803 |
Fri, 20 October 2017 00:46 By: Revathi.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) |
|
Restrictions on DDL-triggers in PL/SQL Oracle XE 11.2.0.2 on Windows 10 By: Alien on Wed, 18 October 2017 |
3 |
140175 |
Thu, 19 October 2017 08:06 By: Alien ![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) |
|
Passing UDT as a SP parameter 11.0.2.10 |
4 |
59083 |
Tue, 17 October 2017 03:26 By: OraFerro ![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 extract out huge result set in xml format as .xml file 12.1.0.2 |
1 |
63738 |
Mon, 16 October 2017 15:01 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |