|
|
Topic |
Replies |
Views |
Last message |
![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 |
5678 |
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 |
5867 |
Tue, 21 July 2020 01:54 By: wjuteau ![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) |
|
Sorting of columns in alternative order. 11g |
4 |
9016 |
Sat, 18 July 2020 15: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) |
|
creating a materialized view throws "ORA-01031: insufficient privileges" Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
5 |
12066 |
Wed, 15 July 2020 12:56 By: wtolentino ![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 Inherit data default from %TYPE attribute for a variable Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production |
7 |
9261 |
Wed, 15 July 2020 10:33 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) |
|
REGEXP_LIKE to match string in a list Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
2 |
6265 |
Wed, 15 July 2020 08:45 By: wtolentino ![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) |
|
issue in inserting pdf file in a table oracle 12c, windows |
10 |
10676 |
Wed, 15 July 2020 06:14 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) |
|
insert rows 12c By: DRDBA on Thu, 09 July 2020 |
4 |
12590 |
Fri, 10 July 2020 15:33 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) |
|
Run Time Errors 933 and 512 executing Proc SQL Developer Version 17.3.2.341 |
9 |
15172 |
Fri, 10 July 2020 07:03 By: cfairtp ![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) |
|
Running script present on webserver 10g |
7 |
13325 |
Wed, 08 July 2020 16:23 By: bluetooth420 ![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 the format and display the data type of a string Oracle DB 11g |
12 |
15507 |
Tue, 07 July 2020 11: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) |
|
To store table row count in the same table's comment any version Oracle |
4 |
14123 |
Mon, 06 July 2020 09:49 By: Olexandr Siroklyn ![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) |
Newbie needs help with wm_concat Oracle Database 10g Release 10.2.0.5.0 - Production; PL/SQL Release 10.2.0.5.0 - Production; "CORE 10.2.0.5.0 Production"; TNS for Linux: Version 10.2.0.5.0 - Production; NLSRTL Version 10.2 |
6 |
15489 |
Mon, 06 July 2020 05:51 By: Operator101 ![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) |
|
DB link issue in cloned databases on same host 11.1.0.7.0 By: aloksk on Tue, 28 January 2020 |
8 |
17884 |
Fri, 03 July 2020 03:04 By: Sooqa ![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 query Oracle 12c |
12 |
20797 |
Fri, 03 July 2020 00: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) |
|
Help with the minus operator RDBMS 11.2.0.4 |
0 |
8247 |
Wed, 01 July 2020 05:50 By: BeefStu ![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 substring equal to a 7 digits number (merged) |
12 |
18706 |
Tue, 30 June 2020 17:40 By: annacol ![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) |
|
PLS-00801: internal error [*** ASSERT at file pdz2.c, line 4788; Illegal access (Text) Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production, TNS for Linux: Version 12.2.0.1.0 - Production By: s4.ora on Tue, 30 June 2020 |
0 |
9065 |
Tue, 30 June 2020 03:34 By: s4.ora ![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) |
|
Problem with Sequence-Creation via Trigger Oracle 12.1 on an ODA (Oracle Database Appliance) |
10 |
22312 |
Mon, 29 June 2020 06:33 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-00904: : invalid identifier RDBMS 11.2.0.4 |
4 |
14444 |
Mon, 29 June 2020 06:02 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) |
|
Want to trigger the URL using UTL_HTTP 12.1.0.2.0 |
6 |
19563 |
Sun, 28 June 2020 07:49 By: BlackSwan ![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 a record from existing random records (5 merged) RDBMS 11.2.0.4 |
24 |
34159 |
Fri, 26 June 2020 23:44 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-00904: invalid identifier Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: s4.ora on Thu, 25 June 2020 |
1 |
9310 |
Thu, 25 June 2020 05:15 By: s4.ora ![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) |
|
View and Table created from same query giving different result Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: s4.ora on Tue, 09 June 2020 |
4 |
12716 |
Thu, 25 June 2020 05:06 By: s4.ora ![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) |
|
Loading a CLOB with a KEY By: Mark70 on Mon, 22 June 2020 |
2 |
9213 |
Mon, 22 June 2020 09:53 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) |
|
2 Rows Data into 1 Row |
3 |
11835 |
Fri, 19 June 2020 06:00 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) |
|
Query not returning correct values (merged) Windows 10 Pro. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0, Forms 11g 32 bit |
11 |
18762 |
Wed, 17 June 2020 07:12 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) |
|
'Create table' statement is hanging SQL*Plus: Release 11.2.0.3.0 Production By: aidi-h on Mon, 15 June 2020 |
4 |
12962 |
Tue, 16 June 2020 12:44 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) |
|
get closer to datetime in two tables oracle 12c By: mape on Tue, 16 June 2020 |
3 |
9841 |
Tue, 16 June 2020 06:00 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) |
|
The ESCAPE Option By: amirmg on Wed, 10 June 2020 |
7 |
18530 |
Fri, 12 June 2020 02: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) |
|
Time Portion of Date/Time Value Being Stripped When Passed to Stored Procedure (3 merged) |
7 |
15043 |
Thu, 11 June 2020 03:06 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) |
|
Multiple rows into on "TEMP" table? By: RM33 on Fri, 29 May 2020 |
2 |
10541 |
Wed, 10 June 2020 13:50 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) |
|
Simple UPDATE - should be easy but just can't get it! Oracle 18c - but should apply to any version! By: dragam on Sun, 07 June 2020 |
6 |
11562 |
Wed, 10 June 2020 13:38 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) |
|
Creating a not well-formed XML By: Mark70 on Wed, 10 June 2020 |
1 |
8371 |
Wed, 10 June 2020 05: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) |
|
CASE Statement on a Cursor R12 |
5 |
12548 |
Tue, 09 June 2020 07:39 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) |
|
Commands in SQl |
4 |
13263 |
Mon, 08 June 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) |
|
FORALL with associative array and INDEX BY VARCHAR xe 11g R2 By: hudo on Sat, 06 June 2020 |
3 |
10922 |
Sun, 07 June 2020 05: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) |
|
Adding [CDATA[ element in an XML By: Mark70 on Thu, 04 June 2020 |
2 |
12333 |
Fri, 05 June 2020 00:40 By: _jum ![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) |
|
BLOB msg print in xml format Oracle 12c By: bkbora on Tue, 02 June 2020 |
4 |
10595 |
Wed, 03 June 2020 01: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) |
|
Split Comma seperated Value |
1 |
8187 |
Wed, 03 June 2020 00:03 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |