|
|
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 |
13164 |
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 |
12120 |
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 |
6028 |
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 |
6013 |
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 |
12740 |
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 |
13156 |
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 |
15776 |
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 |
12103 |
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 |
5146 |
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 |
6298 |
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 |
4312 |
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 |
3960 |
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 |
7884 |
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 |
13567 |
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 |
10567 |
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 |
4232 |
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 |
7321 |
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 |
9670 |
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 |
5546 |
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 |
6209 |
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 |
4748 |
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 |
5095 |
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 |
4213 |
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 |
10293 |
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 |
7010 |
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 |
8349 |
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 |
9162 |
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 |
6082 |
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 |
10835 |
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 |
10541 |
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 |
7668 |
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 |
4390 |
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 |
5582 |
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 |
5361 |
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 |
5523 |
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 |
5691 |
Tue, 21 July 2020 01:54 By: wjuteau ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |