|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sql query taking long time to execut |
2 |
4105 |
Tue, 21 May 2019 06:37 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) |
|
minus query using dblink Oracle 12 |
4 |
5932 |
Mon, 20 May 2019 11:50 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) |
|
Loop after fetch on generic SYS_REFCURSOR 11.2.0.1.0 |
9 |
9959 |
Mon, 20 May 2019 11:47 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) |
|
Error: ORA-00980: synonym translation is no longer valid By: abs on Thu, 09 May 2019 |
5 |
8587 |
Mon, 20 May 2019 01:09 By: sandycullen ![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) |
|
Disable FND_FILE.PUT_LINE(FND_FILE.LOG 12.0.1.2 |
8 |
9373 |
Sat, 18 May 2019 00:33 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) |
|
write to the file from PL SQL oracle 11 |
3 |
4322 |
Fri, 17 May 2019 14: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) |
|
month as columns 12c |
4 |
4456 |
Thu, 16 May 2019 01:34 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) |
|
How to get or concatenate a value from inner most query Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional |
2 |
4217 |
Wed, 15 May 2019 15:05 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) |
|
Update in EXECUTE IMMEDIATE Oracle 11G |
34 |
16005 |
Wed, 15 May 2019 12:39 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) |
|
Extract clob xml data to get node value Oracle RDBMS, 12.1, Windows By: unna on Mon, 13 May 2019 |
5 |
12696 |
Tue, 14 May 2019 15:57 By: unna ![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) |
|
Why does my SQL not work? By: jvanh on Tue, 14 May 2019 |
10 |
5432 |
Tue, 14 May 2019 13: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) |
|
Package transfer from one to other oracle database Oracle database 12.2 on Oracle Linux 7 By: armait on Tue, 07 May 2019 |
30 |
9275 |
Wed, 08 May 2019 09: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 remove line breaks and put it in excel Oracle11g By: ssyr on Thu, 02 May 2019 |
6 |
5550 |
Mon, 06 May 2019 06: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) |
|
parent value of xmlquery Oracle 12C |
4 |
4963 |
Fri, 03 May 2019 10:07 By: _jum ![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-00933: SQL command not properly ended Oracle Live SQL |
8 |
10254 |
Thu, 02 May 2019 09:54 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) |
|
Runtime data stored in tables By: hapr1 on Wed, 01 May 2019 |
1 |
3800 |
Wed, 01 May 2019 18:19 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) |
|
Converting returned rows into columns Oracle 11 |
3 |
4732 |
Sun, 28 April 2019 06:26 By: Satheeshkumar.P ![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) |
|
Inserting %RowType objects "faster" 11g |
1 |
3832 |
Tue, 23 April 2019 14:12 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) |
|
Query taking 40 hours to execute SQL developer |
10 |
6150 |
Tue, 23 April 2019 04:11 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) |
|
pl/sql procedure compile error PLS-00103 11.2.0.4 |
2 |
4698 |
Mon, 22 April 2019 21:30 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) |
|
optimizer_feature_enable Hint Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
6 |
4442 |
Mon, 22 April 2019 10: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) |
|
update with subqueries possibilty |
2 |
3537 |
Mon, 22 April 2019 06: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) |
|
update collection of object type using update statement Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
4 |
5221 |
Sat, 20 April 2019 09:47 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) |
|
json fetching using JSON_TABLE Oracle 12c |
6 |
5380 |
Sat, 20 April 2019 08:24 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) |
|
Comparing daywise data |
5 |
4541 |
Sat, 20 April 2019 02:17 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) |
|
Problem with selecting data 9.2.0.5.0 |
5 |
5003 |
Wed, 17 April 2019 10:03 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) |
|
Query running extremely slow Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional |
14 |
14752 |
Wed, 17 April 2019 03:39 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) |
|
Carriage Return Finding Oracle 11g,Windows |
15 |
6873 |
Fri, 12 April 2019 05:38 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) |
|
Explain plan attached 11g |
3 |
4488 |
Fri, 12 April 2019 02:03 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) |
|
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016 |
32 |
13385 |
Fri, 12 April 2019 01: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) |
|
Import XML file into XMLType Column Database 11.2.0.2.0 By: ator on Fri, 05 April 2019 |
9 |
8037 |
Tue, 09 April 2019 10: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) |
|
View my own queries 10g, RHEL 7 |
6 |
5108 |
Mon, 08 April 2019 02:25 By: Roachcoach ![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) |
|
Import/Entry from txt file SQL*Plus: Release 8.0.6.0.0 - Production |
6 |
5438 |
Sun, 07 April 2019 06:11 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 split one column with dates into two with periods (from-to) ORACLE DB |
6 |
5611 |
Sat, 06 April 2019 11:03 By: chrisk4@wp.pl ![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) |
|
Storing only DATE I timestamp data type column Oracle 12c |
2 |
4649 |
Fri, 05 April 2019 00:03 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 Retrieve string unto first pipe symbol in query Oracle11g By: ssyr on Fri, 29 March 2019 |
5 |
6063 |
Tue, 02 April 2019 14:03 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) |
|
Compare and contrast TRUNCATE and DELETE for a table |
9 |
14855 |
Tue, 02 April 2019 13:50 By: dragam ![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 next working day within the same period PL SQL |
3 |
4066 |
Tue, 02 April 2019 05:24 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) |
|
How to send sms to no of mobile numbers using url in plsql procedure |
5 |
6463 |
Mon, 01 April 2019 14:32 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) |
|
Error in materialized view refresh path Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
16 |
28000 |
Mon, 01 April 2019 10:04 By: saipradyumn ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |