|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Co-related Subquery Throwing Error While Using rank function |
6 |
6460 |
Wed, 02 October 2019 09:54 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) |
|
running total query 11 g |
4 |
6664 |
Mon, 30 September 2019 06:10 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) |
|
Cannot drop a user oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM |
7 |
8469 |
Mon, 30 September 2019 05:49 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) |
|
date usage in SQL query |
6 |
7372 |
Mon, 30 September 2019 05:46 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) |
|
Need help with Error: subprogram or cursor reference is out of scope Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 By: rappaj on Thu, 26 September 2019 |
9 |
7255 |
Fri, 27 September 2019 08:48 By: rappaj ![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 to find Consecutive Halves By: patneel on Tue, 24 September 2019 |
2 |
4779 |
Wed, 25 September 2019 11:03 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) |
|
Writing Query but not getting desired output |
6 |
6285 |
Wed, 25 September 2019 05:50 By: flyboy ![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) |
|
co related subquery written in Analytical functions |
3 |
5069 |
Wed, 25 September 2019 03: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) |
|
display issue |
4 |
4918 |
Tue, 24 September 2019 13: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) |
|
RETURNING clause returns wrong value upon UPDATE statement Oracle 11g |
5 |
5969 |
Tue, 24 September 2019 02:21 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 call compiled procedure and function in a procedure Toad 11.5 with Oracle 10g |
9 |
7829 |
Mon, 23 September 2019 10: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) |
|
ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
5 |
10940 |
Fri, 20 September 2019 06:39 By: revathitirun ![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 informations about processes Oracle 11 - Unix |
13 |
8099 |
Tue, 17 September 2019 10:35 By: limner1977 ![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 around LIST_AGG function oracle 11gr2 |
4 |
5875 |
Tue, 17 September 2019 08:50 By: rajeshkr ![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 masking Oracle 12c 2 |
6 |
5395 |
Fri, 13 September 2019 03:25 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) |
|
Sql query to group the values in comma seperated values Oracle DB 10.2.0.2 |
4 |
4504 |
Thu, 12 September 2019 10:13 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) |
|
what is utc and gmt Oracle 12c |
3 |
4392 |
Thu, 12 September 2019 06:26 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) |
|
View not pulling with updated table information APEX Oracle -PL/SQL By: WillJ on Tue, 10 September 2019 |
8 |
7511 |
Wed, 11 September 2019 07:28 By: WillJ ![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 Show Column Value separated with colon as well as another column vlaue Oracle 11G By: ssyr on Tue, 10 September 2019 |
6 |
7118 |
Wed, 11 September 2019 07:14 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) |
|
display data in new column |
6 |
6984 |
Tue, 10 September 2019 06:25 By: getideas456@gmail.com ![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-00001: unique constraint On Merge Insert Oracle11g By: ssyr on Fri, 30 August 2019 |
7 |
7627 |
Tue, 10 September 2019 00:19 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) |
|
Procedure SendMail Gmail Oracle 11 |
0 |
3587 |
Mon, 09 September 2019 14:14 By: fabissilva ![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) |
|
BI Publisher Apex web Services Oracle 11g By: akarra on Mon, 09 September 2019 |
1 |
4847 |
Mon, 09 September 2019 12:59 By: akarra ![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) |
|
IIF and Oracle Windows 2003 and Oracle 10g |
16 |
18604 |
Fri, 06 September 2019 08:32 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) |
|
ORA-29913 ORA-29400 KUP-00554 Oracle 12c |
6 |
10168 |
Wed, 04 September 2019 06:40 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) |
|
How to remove ordinal suffixes after the numbers pl/sql developer, windows 10 |
10 |
7937 |
Fri, 30 August 2019 13:47 By: nareshk00 ![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) |
|
Purging Data From table! |
22 |
16947 |
Fri, 30 August 2019 02:01 By: oracledev ![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) |
|
Additional Column Indicator for Failed or Passed Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production |
2 |
4452 |
Thu, 29 August 2019 11:45 By: wtolentino ![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) |
|
Create table as select Oracle 11.2, AIX By: corina on Wed, 28 August 2019 |
6 |
5519 |
Thu, 29 August 2019 10: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) |
|
help with sql grouping |
6 |
6835 |
Wed, 28 August 2019 17:01 By: ramkumar10 ![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 with sql using analytical functions. |
4 |
7363 |
Wed, 28 August 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Compare two tables to find new/modified/removed records Oracle DB 11g Enterprise Edition 11.2.0.4.0 - 64bit / Windows 7 x64 By: nickz on Thu, 22 August 2019 |
3 |
7012 |
Fri, 23 August 2019 09:12 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) |
|
Dynamic Logic Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
5 |
6633 |
Fri, 23 August 2019 01:59 By: vippysharma ![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) |
|
Bursting Program is not being Submitted |
1 |
5713 |
Wed, 21 August 2019 14:58 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) |
|
regexp_replace Oracle 12c |
6 |
5162 |
Tue, 20 August 2019 01:50 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) |
|
xml generation from db Oracle 12c 2 |
1 |
3860 |
Mon, 19 August 2019 03:47 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) |
|
plsql logic |
10 |
6287 |
Sat, 17 August 2019 10:23 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) |
|
Data spliting 11gr2 |
5 |
5027 |
Fri, 16 August 2019 08:46 By: rajeshkr ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Materialized View Query Oracle SQL Developer 4.2.0 |
3 |
5307 |
Fri, 16 August 2019 06:22 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) |
|
SQL Tuning instead of Cross Join 11G By: laknar on Thu, 25 July 2019 |
18 |
9426 |
Fri, 16 August 2019 05:50 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |