|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to use table functions By: Mark70 on Wed, 03 June 2020 |
4 |
13160 |
Fri, 25 September 2020 03:43 By: Mark70 ![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 add SOAP elements to XML Oracle 10g By: Mark70 on Mon, 01 June 2020 |
4 |
12119 |
Fri, 25 September 2020 03:43 By: Mark70 ![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) |
|
Finding entries missing a value and listing all used values for specific data By: magriii on Wed, 23 September 2020 |
6 |
6027 |
Thu, 24 September 2020 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) |
|
Query help on 5 tables. Oracle, 11g |
4 |
6012 |
Tue, 22 September 2020 22:33 By: Iffat ![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 interval Blank count Oracle 11 |
5 |
12738 |
Fri, 18 September 2020 10:07 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) |
|
understanding table partition Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production |
9 |
13155 |
Thu, 17 September 2020 00:28 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) |
|
Invisible double quotes Oracle 12c Windows10 |
8 |
15771 |
Wed, 16 September 2020 14:08 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 data only those which are in decimals oracle 12c |
4 |
12102 |
Tue, 15 September 2020 06:06 By: lacchhii ![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 email MS Word attachment containing Arabic letters 11.2.0.1.0 |
0 |
5144 |
Sun, 06 September 2020 04:24 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) |
|
outer query returning more than one row MS SQL |
2 |
5119 |
Sat, 05 September 2020 10: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) |
|
Foreign key |
10 |
6295 |
Fri, 04 September 2020 12:56 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) |
|
to_timestamp_tz Oracle 12c Windows10 |
4 |
4309 |
Fri, 04 September 2020 12:54 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) |
|
xml to json conversion Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
1 |
3959 |
Fri, 04 September 2020 05:11 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: create a partition by reference (partition by reference(fk)) on non referenced table |
1 |
7882 |
Tue, 01 September 2020 04:57 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) |
|
Oracle Procedure with table name as parameter Oracle 11g |
11 |
13564 |
Fri, 28 August 2020 06:01 By: sunilpatro08 ![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) |
|
Future PriceCalculation based on 3 columns Oracle 11 By: buzzi7 on Wed, 19 August 2020 |
2 |
10565 |
Thu, 27 August 2020 00:18 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) |
|
row_number with duplicity 12.1.0.2.0 By: mape on Wed, 26 August 2020 |
3 |
4231 |
Wed, 26 August 2020 07:58 By: mape ![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 out how long is the field or column |
2 |
7320 |
Mon, 24 August 2020 08:51 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) |
|
ORA-29279: SMTP permanent error (split from hijacked topic) By: samsam on Sat, 22 August 2020 |
2 |
9486 |
Sat, 22 August 2020 13:28 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) |
|
Select and load CLOB column data into another table Oracle 11g |
3 |
9669 |
Wed, 19 August 2020 08:10 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
SQL CASE or IF Else Condition DB 12C By: wasimK on Mon, 17 August 2020 |
2 |
5545 |
Mon, 17 August 2020 13:38 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) |
|
regexp_substr fix string unable to handle. Oracle, 11g, Windows 7 |
16 |
6207 |
Sun, 16 August 2020 23:28 By: nitesh.erp@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) |
|
dbms_output.put_line synchronize Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
4 |
4746 |
Fri, 14 August 2020 13: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) |
|
min / max date of grouped status of a values ? (merged) oracle enterprise rdbms 18.3, linux64 By: flat on Thu, 13 August 2020 |
6 |
5093 |
Thu, 13 August 2020 09:33 By: flat ![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 foreign key of all the referenced table of table |
0 |
4212 |
Mon, 10 August 2020 23:26 By: sinha73 ![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) |
|
Errors running Proc that compiles fine SQL Developer Version 17.3.2.341 \ Build 341.0937 |
9 |
10290 |
Fri, 07 August 2020 15:44 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) |
|
INSERT WHEN NOT EXIST 12c |
6 |
7009 |
Fri, 07 August 2020 03:23 By: deepakdot ![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) |
|
- PDML disabled because single fragment or non partitioned table used Oracle 12c |
3 |
8347 |
Thu, 06 August 2020 10:12 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) |
|
Converting XML to JSON using Apex Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
2 |
9154 |
Wed, 05 August 2020 20:44 By: wantmannu ![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) |
|
set default values to current epoch (2 merged) Oracle 11.2.0.4.0 enterprise, CentOS 7.2 |
4 |
4548 |
Wed, 05 August 2020 06:29 By: weekend79 ![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 in Query (merged) Oracle 12.1.2.0 |
1 |
6080 |
Sat, 01 August 2020 12:29 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 a Output as mentioned below Product: Oracle Database 18c EE Extreme Perf ,Version:18.0.0.0.0 , Os: Windows 10 |
5 |
10833 |
Wed, 29 July 2020 03:19 By: gsaravanan ![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 is taking 41 minute in Production environment Oracle 12.1.0.1 |
7 |
10540 |
Mon, 27 July 2020 06:25 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) |
|
Select Query suggestion Oracle 12c By: akssre on Thu, 23 July 2020 |
11 |
12237 |
Sat, 25 July 2020 10:40 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) |
|
Unable to retrieve a record containing NULL value Oracle forms 11g -32 bit on Windows 7 professional |
7 |
7666 |
Fri, 24 July 2020 13:14 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) |
|
API for Progress Line By: GHDSSS on Fri, 24 July 2020 |
1 |
4389 |
Fri, 24 July 2020 10:25 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) |
|
select with while Oracle 12c By: mape on Wed, 22 July 2020 |
4 |
5581 |
Wed, 22 July 2020 12:23 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-00932: inconsistent datatypes: expected - got NCLOB Oracle |
1 |
5360 |
Wed, 22 July 2020 04: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) |
|
XML over 64K By: Mark70 on Tue, 21 July 2020 |
1 |
5522 |
Tue, 21 July 2020 09: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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
ear multivalue json as rows oracle 19 |
2 |
5690 |
Tue, 21 July 2020 01:54 By: wjuteau ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |