|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
REQEXP_SUBTR debug 11i |
3 |
4432 |
Tue, 13 August 2019 14:15 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) |
|
Union and sort the data based on date range 11G By: laknar on Wed, 07 August 2019 |
2 |
4411 |
Thu, 08 August 2019 00:41 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) |
|
Comprimir una imagen utilizando AS_ZIP Oracle Database 11g Release 11.2.0.4.0 |
3 |
5527 |
Thu, 08 August 2019 00:38 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) |
|
Is it possible to insert a folder from a directory into a table? Oracle Data Base 11g r2 |
12 |
7964 |
Thu, 08 August 2019 00:37 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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
read and validate file Oracle Data Base 11g r2 |
13 |
11086 |
Tue, 06 August 2019 12:57 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) |
|
Oracle insert statement Oracle 12 |
2 |
4517 |
Mon, 05 August 2019 07:35 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) |
|
Stored Procedures compile in 11G but do not in 12C (12.1.0.1.0) Oracle 12.1.0.1.0 on a Windows 10 By: ALONG on Thu, 01 August 2019 |
8 |
7537 |
Mon, 05 August 2019 03:00 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) |
|
Convert Columns to rows win 8,Oracle 10g By: Xandot on Thu, 20 November 2014 |
7 |
6462 |
Tue, 30 July 2019 02:56 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) |
|
Leading zeros in a spool file |
6 |
12128 |
Mon, 29 July 2019 09:00 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) |
|
Load multiline data in table using sql loader Oracle 12c |
14 |
12164 |
Fri, 26 July 2019 12:31 By: adfire05 ![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 query took too long to execute on one schema but very little time on another scema oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM |
16 |
8636 |
Fri, 26 July 2019 07: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) |
|
How to use sysdate as a column header Oracle 11g |
5 |
5734 |
Thu, 25 July 2019 07:39 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) |
|
Case insensitive in oracle 12c RDBMS 12.2..0.1 on linux |
1 |
4290 |
Wed, 24 July 2019 14: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) |
|
How to get the file name from directory Oracle 10g |
15 |
16891 |
Mon, 22 July 2019 07:52 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) |
|
ALTER INDEX To Add the Extra columns Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
5 |
5366 |
Thu, 18 July 2019 14:08 By: Lalit Kumar 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) |
|
Sending table data in HTML format through PL/SQL Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production |
17 |
123553 |
Tue, 16 July 2019 07:51 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) |
|
MV Refresh On Commit Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
2 |
6529 |
Mon, 15 July 2019 00:39 By: saipradyumn ![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) |
|
Returning into clause for insert selectstatements Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
6 |
9738 |
Mon, 15 July 2019 00:26 By: saipradyumn ![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) |
|
Different Values of RAWTOHEX in Oracle 12c and 11g Oracle 12.1.0.2.0 and Oracle 11.2.0.1.0 Both Enterprise Editions |
3 |
5054 |
Fri, 12 July 2019 10: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) |
|
MAX(DECODE Oracle 8i, Windows ver 6.1 |
7 |
6621 |
Thu, 11 July 2019 06:03 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) |
|
Trying to Report on Date Periods within a table Oracle 12C |
6 |
6765 |
Sun, 07 July 2019 20:48 By: mvs2019 ![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) |
|
Automatic abropting the long running job Oracle 12c |
8 |
9766 |
Sat, 06 July 2019 07:28 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 to Create variable out of Table Type Variable! |
7 |
8719 |
Mon, 24 June 2019 12:38 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) |
|
Incorrect work of the sql query with JOIN. Oracle, 11g, Win 7 By: orajav on Thu, 13 June 2019 |
18 |
10476 |
Fri, 14 June 2019 05:50 By: orajav ![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 the Sql query to find employees who were recruited on the same day or on neighboring days. Oracle, 11g, Win 7 By: orajav on Wed, 12 June 2019 |
21 |
14097 |
Thu, 13 June 2019 12:46 By: orajav ![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 pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va oracle 11g |
3 |
7626 |
Thu, 13 June 2019 07:24 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 build a query that gets its values from a file Oracle SQL Developer Version 4.0.1.14 / windows 7.0 |
10 |
9014 |
Wed, 12 June 2019 10:23 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) |
|
Backup Oracle 11.1 , linux |
20 |
11258 |
Tue, 11 June 2019 12:35 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) |
|
Aggregate operation on array 11.2.0.1.0 |
20 |
14111 |
Tue, 11 June 2019 03:56 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) |
|
PLS-00306: wrong number or types of arguments in call to 'FOPEN' (CM merged 2) Oracle 11GR2 |
4 |
8128 |
Thu, 06 June 2019 06:43 By: maik2910 ![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) |
|
Combining 3 queries into 1 Oracle11g By: ssyr on Wed, 05 June 2019 |
5 |
5607 |
Wed, 05 June 2019 11: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) |
|
Approximate 50MB files per day to be saved in Oracle Database Oracle 11gR2 |
1 |
5334 |
Mon, 03 June 2019 12:31 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) |
|
select START_TIME = TO_DATE returns 0 RDBMS 12.2..0.1 on linux |
5 |
6056 |
Mon, 03 June 2019 11:01 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 write SQL Query to get desire output oracle 12c By: shawaj on Fri, 31 May 2019 |
3 |
5402 |
Sun, 02 June 2019 23:38 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) |
|
varchar2 byte or char semantics db any version |
2 |
4184 |
Wed, 29 May 2019 12:19 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) |
|
json filter unusual behaviour Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 |
3 |
5052 |
Wed, 29 May 2019 07:48 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) |
|
can we call an sql script from the code of a stored procedure |
28 |
39176 |
Mon, 27 May 2019 04:24 By: William Robertson ![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 all child records from a table with multiple self referential integrity constraints? (merged 3) 11g By: rrcr on Thu, 23 May 2019 |
8 |
6357 |
Fri, 24 May 2019 08:06 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) |
|
case if avec PL/SQL |
1 |
4458 |
Thu, 23 May 2019 00:20 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) |
|
Help in building a Query |
4 |
6376 |
Tue, 21 May 2019 06:50 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |