|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DBMS_HS_PASSTHROUGH - Database Link as Input Parameter By: aimy on Wed, 06 January 2021 |
8 |
14664 |
Fri, 08 January 2021 00:35 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) |
|
opening and closing balance oracle 19c |
3 |
10501 |
Thu, 07 January 2021 06:36 By: learner123 ![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 query. Oracle 11g. |
10 |
13420 |
Wed, 06 January 2021 00: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) |
|
oracle pl/sql 11g |
1 |
5265 |
Mon, 04 January 2021 11:27 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Fuzzy Matching S-Q-L Sever Taking Fime for 2.4 millions records |
1 |
8940 |
Thu, 31 December 2020 14:26 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) |
|
sending bulk email in Report 12c? Report 12c By: Dhabhu on Wed, 30 December 2020 |
0 |
5446 |
Wed, 30 December 2020 00:21 By: Dhabhu ![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) |
|
Partitoning taking long time Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production |
5 |
9669 |
Thu, 24 December 2020 13:04 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) |
|
DBMS_HS_PASSTHROUGH - Column Value Truncated SQL*Plus: Release 11.2.0.1.0 [Server version: 5.7.29-5-log MySQL Community Server - (GPL)] By: aimy on Mon, 21 December 2020 |
0 |
6156 |
Mon, 21 December 2020 10:38 By: aimy ![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 08103 - object no longer exists referring a temporary table By: NZZ on Fri, 18 December 2020 |
1 |
5063 |
Fri, 18 December 2020 10:56 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) |
|
Insufficient privileges? |
5 |
8522 |
Fri, 18 December 2020 01: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) |
|
Mix of Cross and Full Outer Join https://livesql.oracle.com/apex |
5 |
7269 |
Wed, 16 December 2020 02: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) |
|
tab_to_string for longer texts ORA-06502-numeric or value error string |
9 |
11691 |
Wed, 16 December 2020 01:37 By: rafalbballer ![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-06502 error for json_value (merged) Oracle 12 |
8 |
7734 |
Mon, 14 December 2020 15:07 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) |
|
Display Numeric Value from Text Field Oracle 10 G, Windows7 |
4 |
9004 |
Sun, 13 December 2020 00: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 into one row 12.1.0.2 By: mape on Wed, 09 December 2020 |
7 |
8269 |
Wed, 09 December 2020 07:06 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) |
|
ten-digit hexadecimal number 12.1.0.2.0 By: mape on Tue, 01 December 2020 |
8 |
10192 |
Wed, 09 December 2020 06:10 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) |
|
REGEXP_REPLACE Oracle 12c |
2 |
4048 |
Tue, 08 December 2020 23:47 By: sss111ind ![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_api package that... has no body? Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows |
22 |
14460 |
Tue, 08 December 2020 18:28 By: flyboy ![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 for a noobie! By: nail3r on Thu, 03 December 2020 |
1 |
6273 |
Thu, 03 December 2020 04: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) |
|
Need help to rewrite the query 11G |
4 |
5935 |
Tue, 01 December 2020 00:27 By: nikhiljuneja@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) |
|
week start from saturday oracle 10g, windows 7 |
7 |
8415 |
Tue, 01 December 2020 00: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) |
|
How to convert JSON into XML in Oracle 10g By: Mark70 on Mon, 30 November 2020 |
1 |
6552 |
Mon, 30 November 2020 05:45 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) |
|
Creating Procedure (2 merged) Windows 10, Oracle Express Edition 10g, Developer 10g |
1 |
6138 |
Sun, 29 November 2020 04:21 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) |
|
Table joining with two columns sharing a foreign key |
2 |
5917 |
Fri, 27 November 2020 05:43 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) |
|
One row for multiple rows based on a condition By: annacol on Wed, 25 November 2020 |
2 |
6467 |
Thu, 26 November 2020 00:07 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) |
|
Day book format oracle 10g, windows 7 |
9 |
9045 |
Tue, 24 November 2020 10:43 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 SQL Logic For Comparing Data Between Two Tabless Oracle By: nrk1979 on Fri, 20 November 2020 |
3 |
11296 |
Sat, 21 November 2020 07:30 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) |
![icon6.gif](/forum/images/message_icons/icon6.gif) |
Query with LIKE too SLOW... By: aimy on Fri, 20 November 2020 |
9 |
11912 |
Fri, 20 November 2020 10:16 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) |
|
UPDATE query with three table join (3 merged) oracle sql |
4 |
6762 |
Wed, 18 November 2020 16:07 By: flyboy ![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) |
|
Count of records with the max(date) and Max(lastrecordid) SQL |
2 |
8102 |
Tue, 17 November 2020 02:46 By: enniwesw ![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 to Jewish/Hebrew Date (2 merged) By: LiorI on Sun, 15 November 2020 |
2 |
7412 |
Sun, 15 November 2020 03:47 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) |
|
Extract words from a string and use them as variables oracle |
5 |
6092 |
Sat, 14 November 2020 00: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) |
|
table refresh process - discuss optoins 12.2 |
8 |
9020 |
Fri, 13 November 2020 01:22 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) |
|
table record into XML user defined (2 merged) By: mape on Wed, 11 November 2020 |
8 |
6028 |
Wed, 11 November 2020 08:14 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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
OLAP sql-cube operator By: jusasi on Fri, 06 November 2020 |
1 |
5336 |
Fri, 06 November 2020 05:21 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) |
|
ORA-00979: not a GROUP BY expression oracle 18c |
4 |
7300 |
Fri, 06 November 2020 03:07 By: Haykel_bh ![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 can I execute multiple SQL statements in one batch? Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows |
6 |
5604 |
Thu, 05 November 2020 10: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) |
|
How can I model a column in a new table after a column in an existing table? |
4 |
5100 |
Thu, 05 November 2020 10:02 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) |
|
A regular user cannot create Varchar2(32767) Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows |
1 |
5283 |
Wed, 04 November 2020 15:01 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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Nested JSON_ARRAYAGG --> ORA-00937 - how to create json structure Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production |
2 |
8660 |
Wed, 04 November 2020 10:17 By: autenrip ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |