|
|
Topic |
Replies |
Views |
Last message |
![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 |
5560 |
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 |
8961 |
Wed, 04 November 2020 10:17 By: autenrip ![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 subtract dates between different rows Oracle 12 |
4 |
5341 |
Tue, 03 November 2020 23:43 By: talhaparvaiz@yahoo.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) |
|
ORA-02315: incorrect number of arguments for default constructor Oracle 12.2 |
3 |
4909 |
Tue, 03 November 2020 12:49 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 query By: Sql ia on Mon, 02 November 2020 |
6 |
5525 |
Tue, 03 November 2020 05:34 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) |
|
ORA-29268, 400 - Bad Request trying to send Tweet using REST Api from PL/SQL using UTL_HTTP. |
6 |
10509 |
Tue, 03 November 2020 05:32 By: scotthillierfrontera ![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) |
|
Joining multiple tables with case |
4 |
4820 |
Mon, 02 November 2020 12:40 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) |
|
How to display only one row with max no. of count? Oracle 11g database |
4 |
5093 |
Mon, 02 November 2020 09:32 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) |
|
Improve Performance of Insert and Update on same table 12.1.0.2.0 By: Shre on Mon, 19 October 2020 |
4 |
5576 |
Fri, 30 October 2020 10:51 By: Shre ![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) |
|
What is the proper termination for a stored procedure created from C# code? Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows |
3 |
4955 |
Wed, 28 October 2020 14:22 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) |
|
A query that works in SquirrelSLQL fails in C# Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows |
4 |
6123 |
Wed, 28 October 2020 08:13 By: Darth Waiter ![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-1403 when trying to select after Insert Oracle 10g |
4 |
5636 |
Wed, 28 October 2020 07:54 By: pjizquierdo ![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 to retrieve lines based on a static value |
12 |
7796 |
Tue, 27 October 2020 18: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) |
|
temp table not returning data in WITH 18.10 |
11 |
8161 |
Sun, 25 October 2020 22:29 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) |
|
Get Distinct Data Oracle |
4 |
4939 |
Sun, 25 October 2020 12:51 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 Partition with Online / Update global indexes clause 11.2.0.4 By: azeem87 on Fri, 09 October 2020 |
19 |
12055 |
Thu, 22 October 2020 13:40 By: azeem87 ![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_char date with and without format 11.2.0.1.0 |
2 |
4084 |
Thu, 22 October 2020 06:35 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) |
|
Tree order, Sum of valid values Oracle 12.2.0. |
2 |
4091 |
Tue, 20 October 2020 12:39 By: vasudevaviswa ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
How to generate a spool file without an extension name (.lst,.txt etc...) SQL |
6 |
9722 |
Fri, 16 October 2020 08:15 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) |
|
Pivot using SQL in Oracle Oracle SQL Dev Version 17.3.1.279 |
1 |
3464 |
Thu, 15 October 2020 10:23 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-06502 Oracle 12 C windows By: anncao on Tue, 13 October 2020 |
3 |
3895 |
Tue, 13 October 2020 18:51 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 Unix Time format to readable format |
9 |
7561 |
Mon, 12 October 2020 06:09 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) |
|
Matrix Report Out put Oracle 10 G, Windows7 |
5 |
4624 |
Sun, 11 October 2020 23:41 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) |
|
REgexp_substr function to extract sub string |
2 |
3907 |
Sun, 11 October 2020 14:50 By: talhaparvaiz@yahoo.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) |
|
RANK issue in SQL By: aj123tx on Thu, 08 October 2020 |
3 |
4372 |
Sat, 10 October 2020 06:56 By: aj123tx ![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) |
|
Improve efficiency of script 19.2.1.247 By: Dan22 on Tue, 06 October 2020 |
7 |
9051 |
Fri, 09 October 2020 03:30 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) |
|
Duplicate delete condition 11.2 By: ritmo2k on Wed, 07 October 2020 |
6 |
5350 |
Thu, 08 October 2020 07:46 By: ritmo2k ![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) |
|
OBJECT TYPE Body creation ERROR Oracle 19C, Window |
3 |
3627 |
Thu, 08 October 2020 05: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) |
|
Join Unique Tables By: selami on Wed, 07 October 2020 |
2 |
3716 |
Wed, 07 October 2020 07:36 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) |
|
Loop with Dates PL/SQL (Windows/Current Oracle vers) By: Adjanti on Mon, 05 October 2020 |
4 |
4068 |
Tue, 06 October 2020 10:36 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 Generator Using MODEL Clause, # Repeats Table-Based? |
2 |
3948 |
Tue, 06 October 2020 09:39 By: Art Metzer ![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) |
|
Test Oracle SQL |
2 |
3479 |
Tue, 06 October 2020 01: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) |
|
extract string and compare |
3 |
3317 |
Mon, 05 October 2020 15:24 By: desmond30 ![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) |
|
Pass cursor to Procedure 12.1 By: ora9a on Sun, 04 October 2020 |
5 |
3846 |
Mon, 05 October 2020 05:06 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) |
|
Group pivot column 11.2.0.1.0 |
13 |
5194 |
Mon, 05 October 2020 01:46 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 column for the set of records By: mist598 on Tue, 29 September 2020 |
5 |
4971 |
Tue, 29 September 2020 07:12 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 the next occurrence of an event based on another event SQL Developer 19.2.1 By: ac24 on Sat, 26 September 2020 |
2 |
4987 |
Sat, 26 September 2020 08:52 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) |
|
How to get a substring from a character on By: Mark70 on Fri, 25 September 2020 |
4 |
5510 |
Fri, 25 September 2020 10: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) |
|
Can't connect with new user created By: Mark70 on Tue, 30 June 2020 |
6 |
13371 |
Fri, 25 September 2020 03:45 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) |
|
Date format with UTC By: Mark70 on Thu, 18 June 2020 |
4 |
13354 |
Fri, 25 September 2020 03:44 By: Mark70 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |