|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
xml converting task 11g |
7 |
16318 |
Thu, 23 March 2023 14:11 By: mathguy ![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) |
|
convert xml column value into columns Oracle 19c |
3 |
10348 |
Tue, 21 March 2023 09:20 By: avtaritet ![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) |
|
Refreshing Materialized View oracle 10g |
11 |
22273 |
Tue, 21 March 2023 07:58 By: chat2raj.s ![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) |
|
Rescheduling installments by distributing amounts 12.1.0.1.0 |
8 |
21041 |
Thu, 16 March 2023 01:33 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) |
|
Suggestion on count via sql statement Oracle 12c By: akssre on Fri, 10 March 2023 |
14 |
13803 |
Mon, 13 March 2023 23:07 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) |
|
Ternary Operator in PL/SQL Oracle 10g on UNIX |
3 |
50903 |
Mon, 13 March 2023 19:29 By: mathguy ![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 parsing performance 19c By: mape on Sun, 12 March 2023 |
0 |
16043 |
Sun, 12 March 2023 01:30 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) |
|
Different UTC time from SYSDATE on different databases Oracle 21c/19c |
15 |
13207 |
Thu, 09 March 2023 10:02 By: Andrey_R ![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) |
|
Identify Groups where 2 or more Clients have bought the same Products - SQL Oracle SQL - ORACLE By: Nicha on Fri, 03 March 2023 |
33 |
20137 |
Tue, 07 March 2023 15: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) |
|
Grouping with the previous one if identical |
12 |
25726 |
Mon, 06 March 2023 09:53 By: mathguy ![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 incrementally get all numbers incremented by n between 2 columns values oracle 19c |
27 |
21401 |
Mon, 06 March 2023 08: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) |
|
Need Help with Table Type Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 |
2 |
5130 |
Mon, 06 March 2023 01:05 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) |
|
Optional parameter in Where clause 11g, Windows By: RM33 on Fri, 24 February 2023 |
3 |
18393 |
Sat, 25 February 2023 11: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) |
|
Cast(Multiset()) Oracle, 12.2.0.1.0, Linux By: Duane on Wed, 15 February 2023 |
17 |
23906 |
Fri, 17 February 2023 20:00 By: Duane ![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) |
|
Difference between two dates By: Joy83 on Thu, 09 February 2023 |
4 |
11185 |
Thu, 09 February 2023 08:30 By: Joy83 ![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) |
|
Convert Date formats |
4 |
5875 |
Wed, 08 February 2023 20:47 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) |
|
XML parse 19c By: mape on Fri, 03 February 2023 |
20 |
20574 |
Wed, 08 February 2023 13:04 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) |
|
Loop and save the index in an incremental number array By: Joy83 on Mon, 06 February 2023 |
8 |
6946 |
Mon, 06 February 2023 21:15 By: Joy83 ![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) |
|
Duplicate rows by generating date based on column value 12.1.0.1.0 |
18 |
20755 |
Tue, 31 January 2023 23:02 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) |
|
xml auto generate atribute 19c By: mape on Wed, 18 January 2023 |
5 |
20319 |
Tue, 31 January 2023 00:27 By: mathguy ![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 customer with GREATEST amount of purchases |
12 |
12689 |
Mon, 30 January 2023 09:55 By: mathguy ![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) |
|
REST API with DDOS protection ORACLE 12c By: mmation on Fri, 17 November 2017 |
3 |
13105 |
Mon, 30 January 2023 07:26 By: rxelgin ![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) |
|
Two Column Join Oracle PL SQL |
9 |
13663 |
Mon, 30 January 2023 00:30 By: ibrahimzuberi ![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) |
|
greatest total amount of purchases per day for each customer_id |
3 |
16692 |
Tue, 17 January 2023 02: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) |
|
SQL very slow EBS R12.2.8 |
16 |
21586 |
Mon, 16 January 2023 10:59 By: Duane ![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) |
|
Base64 to Blob Oracle, 12.2.0.1.0, Linux By: Duane on Thu, 12 January 2023 |
2 |
17621 |
Thu, 12 January 2023 15:20 By: Duane ![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 Level trigger |
1 |
13778 |
Wed, 11 January 2023 04:09 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) |
|
COALESCE and CASE |
5 |
16972 |
Wed, 04 January 2023 07: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) |
|
xml error eurofxref-daily.xml 19c By: mape on Sun, 01 January 2023 |
7 |
17820 |
Sun, 01 January 2023 07:57 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) |
|
Parent/Child Table Design Help Oracle, 12.2.0.1.0, Linux By: Duane on Tue, 20 December 2022 |
1 |
24336 |
Wed, 21 December 2022 01:17 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) |
|
Months Calculation and update Statement Oracle 11G, Windows |
5 |
42750 |
Sun, 11 December 2022 13: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) |
|
String Extract using REGEXP_SUBSTR Oracle, 12.2.0.1.0, Linux By: Duane on Fri, 09 December 2022 |
6 |
38461 |
Sat, 10 December 2022 15:05 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 difference between two dates in months Oracle 11 G, Windows |
3 |
35963 |
Fri, 09 December 2022 18:10 By: hissam78 ![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) |
|
Value multiple Sql Plus, Oracle 10G, Windows |
14 |
36414 |
Wed, 07 December 2022 17:02 By: hissam78 ![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 issue with Update statement having select Statement By: VVR on Thu, 01 December 2022 |
4 |
23911 |
Tue, 06 December 2022 01:00 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) |
|
Function not working Oracle 10G, Windows |
6 |
25074 |
Sat, 03 December 2022 00:37 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 row count after update Oracle 12c, Linux |
11 |
21960 |
Wed, 23 November 2022 18:47 By: rajiv.oradev ![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) |
|
unique timestamp |
8 |
16481 |
Mon, 21 November 2022 05:57 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) |
|
Row into Column and sum two columns Oracle 10 G, Windows |
0 |
12017 |
Tue, 15 November 2022 09:39 By: hissam78 ![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) |
|
RegEX data parsing 12.1 |
5 |
13066 |
Mon, 14 November 2022 11:48 By: lott42_gmail ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |