|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Directory Name with UTL_FILE.FOPEN() Oracle, 12.2, Unix By: Duane on Fri, 03 June 2022 |
19 |
16212 |
Wed, 08 June 2022 13:36 By: Duane ![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) |
|
List of partitions 12c |
6 |
6661 |
Wed, 08 June 2022 11:20 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) |
|
file transfer mechanism (FTP/SFTP/SSHFTP) using purely PL/SQL Oracle 19c database |
6 |
7377 |
Mon, 06 June 2022 13:03 By: vaibhav8080 ![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-02270 on FK creation attempt Oracle 19c R2 Standard Edition 2 Linux |
6 |
6995 |
Mon, 06 June 2022 04:47 By: Andrey_R ![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) |
|
Trigger created with compilation errors (invalid specification trigger) SQL plus By: Syaz on Thu, 02 June 2022 |
2 |
7439 |
Fri, 03 June 2022 00: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) |
|
Previous Date value calculation through LAG function Oracle 12C By: akssre on Wed, 01 June 2022 |
1 |
7381 |
Thu, 02 June 2022 00:33 By: akssre ![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 department name, employee 19.2 |
3 |
6807 |
Wed, 01 June 2022 05:35 By: Unclefool ![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 use WHEN OTHERS exception as first Oracle 11g |
2 |
11236 |
Mon, 30 May 2022 03:52 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) |
|
Help me for a SQL query Oracle HCM Fusion |
3 |
7747 |
Sun, 22 May 2022 13:20 By: hamihai ![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 flinding max plan id 19.8 |
1 |
16798 |
Wed, 11 May 2022 00:24 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) |
|
partition non partioned table 12 c |
10 |
17471 |
Thu, 28 April 2022 14:15 By: varunvir ![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) |
|
INSERT, SELECT CONNECT by 19.8 |
3 |
12032 |
Tue, 26 April 2022 14:45 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) |
|
Remove unwanted characters 19c |
4 |
12421 |
Tue, 26 April 2022 11:51 By: varunvir ![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 create data instead of storing it 12.1.0.1.0 |
1 |
10857 |
Tue, 26 April 2022 05:31 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 append a header on the top of the CSV file Oracle Database 19c Enterprise Edition Release 19.0.0.0.0, Windows 10 Pro |
2 |
13789 |
Sat, 23 April 2022 08:16 By: buggleboy007 ![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 there a better way to do this in Oracle - Generate series with other entries Oracle >= 11.2 By: dragam on Thu, 14 April 2022 |
1 |
8312 |
Thu, 14 April 2022 09:05 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) |
|
question on solution provided oracle 19c(19.0.0.0.0) |
0 |
9130 |
Wed, 13 April 2022 20:35 By: manoj12 ![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 Needed in Oracle Referenced Column DataType oracle 19c |
3 |
9676 |
Tue, 12 April 2022 09:27 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) |
|
Oracle JOIN tables Oracle 19.2 |
4 |
7188 |
Mon, 11 April 2022 14:35 By: Unclefool ![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) |
|
Find Difference between 2 columns along with difference data Oracle 12g |
6 |
12707 |
Mon, 04 April 2022 02:04 By: piripicchio ![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) |
|
XML Generation Oracle 11g, XP |
13 |
23770 |
Sat, 02 April 2022 14: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) |
|
Data not sorted Oracle 19.2 |
2 |
11321 |
Fri, 01 April 2022 07:35 By: Unclefool ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Oracle Update to get data from other tables using join |
2 |
10752 |
Fri, 01 April 2022 07:10 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) |
|
Remove empty tags from XML Oracle 11g, XP |
0 |
9427 |
Thu, 31 March 2022 15:33 By: rajiv.oradev ![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-01722 Invalid Number for numeric values. Oracle 12c |
9 |
12014 |
Fri, 25 March 2022 05:28 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) |
|
DB last date 12.1.0.1.0 |
4 |
12143 |
Thu, 24 March 2022 07:34 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) |
|
Code not waiting for REFCURSOR Oracle 12c By: IanC on Thu, 17 March 2022 |
5 |
15113 |
Tue, 22 March 2022 05:50 By: IanC ![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 suggestion Oracle 12c By: akssre on Tue, 15 March 2022 |
9 |
12631 |
Thu, 17 March 2022 05:22 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) |
|
Pass a "Cursor XXXX is" statement to another procedure Oracle, 12.2, Unix By: Duane on Mon, 14 March 2022 |
3 |
9395 |
Tue, 15 March 2022 17:56 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) |
|
Oracle calculate hours between timestamps 19.2 |
3 |
11169 |
Thu, 10 March 2022 17:30 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) |
|
Let's promote them all ! 11.2.0.3 By: Amine on Fri, 18 February 2022 |
8 |
14735 |
Wed, 09 March 2022 15:01 By: Amine ![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 Needed in Date Variable |
1 |
13175 |
Tue, 22 February 2022 00:34 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) |
|
Getting ORA-24374 , when using function in with query (merged) PLSQL 12.1.0.2.0 |
13 |
13761 |
Mon, 21 February 2022 07:16 By: gopalMisra ![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 -Report missing string when running a query Oracle 11 windows 10 |
4 |
7633 |
Sat, 19 February 2022 00:26 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) |
|
Facing issie in 19c |
5 |
8020 |
Thu, 17 February 2022 08: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) |
|
Putting a row with a particular value on top of a sort Oracle 21, Windows 10 By: orHooha on Wed, 09 February 2022 |
3 |
9141 |
Wed, 09 February 2022 20:59 By: orHooha ![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 oracle11g By: Norfree on Wed, 02 February 2022 |
4 |
15126 |
Tue, 08 February 2022 06:49 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) |
|
record count between one hour Oracle 19c By: bkbora on Fri, 04 February 2022 |
3 |
8942 |
Sun, 06 February 2022 06: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) |
|
Oracle case INSERT statement 19.2 |
6 |
8454 |
Sat, 05 February 2022 09:14 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) |
|
Print value in table columns dynamically By: dancko on Sun, 30 January 2022 |
5 |
17762 |
Wed, 02 February 2022 13:10 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |