|
|
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 |
4429 |
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 |
4407 |
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 |
5522 |
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 |
7959 |
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 |
11077 |
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 |
4512 |
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 |
7533 |
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 |
6457 |
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 |
12119 |
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 |
12155 |
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 |
8630 |
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 |
5729 |
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 |
4283 |
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 |
16884 |
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 |
5362 |
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 |
123544 |
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 |
6526 |
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 |
9735 |
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 |
5050 |
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 |
6617 |
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 |
6758 |
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 |
9760 |
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 |
8712 |
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 |
10473 |
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 |
14088 |
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 |
7622 |
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 |
9010 |
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 |
11253 |
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 |
14107 |
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 |
8121 |
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 |
5603 |
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 |
5330 |
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 |
6050 |
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 |
5395 |
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 |
4179 |
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 |
5044 |
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 |
39166 |
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 |
6353 |
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 |
4451 |
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 |
6371 |
Tue, 21 May 2019 06:50 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |