|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
sql oracle 10g |
2 |
16876 |
Fri, 24 March 2023 09:29 By: arun888 ![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 and Max values of contiguous rows (3 merged) oracle 10g |
11 |
23247 |
Fri, 24 March 2023 01:46 By: arun888 ![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 converting task 11g |
7 |
16776 |
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 |
10597 |
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 |
22837 |
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 |
21510 |
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 |
14382 |
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 |
51233 |
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 |
16178 |
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 |
14025 |
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 |
20912 |
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 |
26407 |
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 |
21995 |
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 |
5353 |
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 |
18612 |
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 |
24593 |
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 |
11673 |
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 |
6343 |
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 |
21193 |
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 |
7541 |
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 |
21499 |
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 |
20671 |
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 |
13314 |
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 |
13491 |
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 |
14390 |
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 |
16999 |
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 |
22607 |
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 |
18034 |
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 |
14031 |
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 |
17418 |
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 |
18150 |
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 |
24517 |
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 |
43016 |
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 |
38695 |
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 |
36164 |
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 |
36891 |
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 |
24350 |
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 |
25490 |
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 |
22765 |
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 |
16786 |
Mon, 21 November 2022 05:57 By: deepakdot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |