|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Processed time for a Job SQL 11G |
5 |
5325 |
Fri, 14 September 2018 08:14 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) |
|
String Comparison Oracle 12.2 Windows By: Duane on Tue, 11 September 2018 |
9 |
8026 |
Wed, 12 September 2018 04:06 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 Understanding a complex (complex at least for me) sql to solve sudoku 11.2.04 |
3 |
5798 |
Sun, 09 September 2018 09: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) |
|
update column on same table using database trigger By: mist598 on Thu, 06 September 2018 |
27 |
20101 |
Fri, 07 September 2018 09:25 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) |
|
Help in YIELD [Excel Function] formula in PLSQL Oracle 11 G |
6 |
9578 |
Tue, 04 September 2018 01:14 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) |
|
Urgent : SQL Queries SQL By: akriti on Mon, 07 December 2015 |
13 |
15247 |
Sat, 01 September 2018 20:53 By: Barbara Boehmer ![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 ad-hoc report issues Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional |
14 |
9098 |
Fri, 31 August 2018 11:58 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) |
|
Query to group data Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 |
14 |
10047 |
Fri, 31 August 2018 11:36 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 regular expressions query Oracle 11.2.0.2.0 |
2 |
4464 |
Thu, 23 August 2018 12:57 By: jackman1 ![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) |
|
SQLException encounter while executing data trigger. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
4 |
9402 |
Thu, 23 August 2018 11:55 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) |
|
find circular reference in data |
4 |
4729 |
Thu, 23 August 2018 06:55 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) |
|
consistency constraint ON store Procedure 12c, window |
22 |
10760 |
Tue, 21 August 2018 08:52 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 settlement of inward vs outward quantity Oracle 11g |
13 |
7990 |
Tue, 21 August 2018 08:02 By: quirks ![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) |
|
Relation between two gold |
3 |
4919 |
Tue, 21 August 2018 07: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) |
|
Joining multiple rows and creating multiple columns |
9 |
5806 |
Tue, 21 August 2018 07: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) |
|
Strange Issue in executing procedure Oracle 11g |
22 |
11890 |
Mon, 20 August 2018 10:01 By: JPBoileau ![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) |
|
Row Movement disabled in Partitioned table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
5 |
7113 |
Mon, 20 August 2018 06:30 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) |
|
Prevent Rounding when using Format Masking Oracle 12.1.0.2.0, RHEL |
6 |
8942 |
Fri, 17 August 2018 18:37 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) |
|
Extracting just text from a Blob Column 11.2 By: dejah on Thu, 16 August 2018 |
5 |
6340 |
Fri, 17 August 2018 18: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) |
|
SQL to Subtract X workdays from a date Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
32 |
16263 |
Fri, 17 August 2018 07:53 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) |
|
FIND MONTHS 11.2.0.4.0 |
11 |
7067 |
Fri, 17 August 2018 07:53 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) |
|
Teradata To Oracle MOD Function |
2 |
4387 |
Fri, 17 August 2018 03:30 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) |
|
Put data from one field to another. PLSQL |
5 |
5401 |
Thu, 16 August 2018 10: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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
failing in Creation of PL/SQL function PL SQL ORACLE By: bench on Wed, 15 August 2018 |
14 |
9857 |
Thu, 16 August 2018 07:44 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) |
|
Last 7 days report oracle 11g |
5 |
5429 |
Wed, 15 August 2018 06:24 By: akash123 ![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 Special Character Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
0 |
4704 |
Tue, 14 August 2018 15:07 By: vharish006 ![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) |
|
Split Data in Column & Split Data in Excel (merged) Excel 2016 |
7 |
5599 |
Mon, 13 August 2018 13:53 By: vharish006 ![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 Convert Row to Column As Below Oracle 11g |
11 |
6699 |
Mon, 13 August 2018 08:11 By: joy_division ![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) |
|
Dbms_metadat 12c |
2 |
4812 |
Fri, 10 August 2018 07:42 By: joy_division ![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) |
|
Spool Japanese Characters Oracle 11g |
4 |
8338 |
Fri, 10 August 2018 07:05 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) |
|
PL/SQL Collection Oracle 11G |
4 |
5328 |
Thu, 09 August 2018 06:43 By: poojagarg ![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) |
|
Get Record Count Oracle 11g |
9 |
9223 |
Thu, 09 August 2018 04:19 By: pablolee ![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) |
|
Back fill records Oracle 11.2.0.3 |
4 |
5059 |
Wed, 08 August 2018 14:26 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) |
|
Create JSON from SQL 12C R1 |
10 |
11594 |
Tue, 31 July 2018 12:36 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) |
|
OR clause degrades performance of a query? Oracle database, any, Linux By: raresn on Mon, 30 July 2018 |
2 |
5083 |
Mon, 30 July 2018 08:31 By: raresn ![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) |
|
Performance of Stored Programs Oracle 12c , Linux By: ninan on Sun, 29 July 2018 |
14 |
8379 |
Mon, 30 July 2018 03:02 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) |
|
return top 10 records based on dynamic count of prev records results oracle 11 |
7 |
7490 |
Sun, 29 July 2018 09:23 By: greenwaldliron ![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) |
|
Possibility of Name Oracle 11G |
7 |
9865 |
Fri, 27 July 2018 20:13 By: Barbara Boehmer ![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 ensure uniqueness on RAISE_APPLICATION_ERROR |
14 |
10801 |
Thu, 26 July 2018 03:27 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) |
|
passing date value to the query from sql*plus |
3 |
5863 |
Tue, 24 July 2018 12:08 By: shrinika ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |