| |
|
Topic |
Replies |
Views |
Last message |
 |
|
xml to json conversion
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
1 |
3136 |
Fri, 04 September 2020 05:11
By: Solomon Yakobson  |
|
|
Oracle: create a partition by reference (partition by reference(fk)) on non referenced table |
1 |
6989 |
Tue, 01 September 2020 04:57
By: John Watson |
|
|
Oracle Procedure with table name as parameter
Oracle 11g |
11 |
11459 |
Fri, 28 August 2020 06:01
By: sunilpatro08 |
|
|
Future PriceCalculation based on 3 columns
Oracle 11 By: buzzi7 on Wed, 19 August 2020 |
2 |
9800 |
Thu, 27 August 2020 00:18
By: Michel Cadot |
|
|
row_number with duplicity
12.1.0.2.0 By: mape on Wed, 26 August 2020 |
3 |
3391 |
Wed, 26 August 2020 07:58
By: mape |
|
|
Find out how long is the field or column |
2 |
6469 |
Mon, 24 August 2020 08:51
By: Bill B |
|
|
ORA-29279: SMTP permanent error (split from hijacked topic) By: samsam on Sat, 22 August 2020 |
2 |
8180 |
Sat, 22 August 2020 13:28
By: EdStevens |
|
|
Select and load CLOB column data into another table
Oracle 11g |
3 |
8842 |
Wed, 19 August 2020 08:10
By: Michel Cadot |
|
 |
SQL CASE or IF Else Condition
DB 12C By: wasimK on Mon, 17 August 2020 |
2 |
4652 |
Mon, 17 August 2020 13:38
By: Solomon Yakobson |
|
|
regexp_substr fix string unable to handle.
Oracle, 11g, Windows 7 |
16 |
5130 |
Sun, 16 August 2020 23:28
By: nitesh.erp@gmail.com |
|
|
dbms_output.put_line synchronize
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
4 |
3842 |
Fri, 14 August 2020 13:15
By: Michel Cadot |
|
|
min / max date of grouped status of a values ? (merged)
oracle enterprise rdbms 18.3, linux64 By: flat on Thu, 13 August 2020 |
6 |
4187 |
Thu, 13 August 2020 09:33
By: flat |
|
|
update foreign key of all the referenced table of table |
0 |
3348 |
Mon, 10 August 2020 23:26
By: sinha73 |
|
|
Errors running Proc that compiles fine
SQL Developer Version 17.3.2.341 \ Build 341.0937 |
9 |
9170 |
Fri, 07 August 2020 15:44
By: Solomon Yakobson |
|
|
INSERT WHEN NOT EXIST
12c |
6 |
6140 |
Fri, 07 August 2020 03:23
By: deepakdot |
|
|
- PDML disabled because single fragment or non partitioned table used
Oracle 12c |
3 |
7190 |
Thu, 06 August 2020 10:12
By: Solomon Yakobson |
|
|
Converting XML to JSON using Apex
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
2 |
7850 |
Wed, 05 August 2020 20:44
By: wantmannu |
|
|
set default values to current epoch (2 merged)
Oracle 11.2.0.4.0 enterprise, CentOS 7.2 |
4 |
3741 |
Wed, 05 August 2020 06:29
By: weekend79 |
|
|
 Need Help in Query (merged)
Oracle 12.1.2.0 |
1 |
5115 |
Sat, 01 August 2020 12:29
By: Michel Cadot |
|
|
How to get a Output as mentioned below
Product: Oracle Database 18c EE Extreme Perf ,Version:18.0.0.0.0 , Os: Windows 10 |
5 |
9488 |
Wed, 29 July 2020 03:19
By: gsaravanan |
|
|
Query is taking 41 minute in Production environment
Oracle 12.1.0.1 |
7 |
9344 |
Mon, 27 July 2020 06:25
By: EdStevens |
|
|
Select Query suggestion
Oracle 12c By: akssre on Thu, 23 July 2020 |
11 |
10546 |
Sat, 25 July 2020 10:40
By: akssre |
|
|
Unable to retrieve a record containing NULL value
Oracle forms 11g -32 bit on Windows 7 professional |
7 |
6556 |
Fri, 24 July 2020 13:14
By: buggleboy007 |
|
|
API for Progress Line By: GHDSSS on Fri, 24 July 2020 |
1 |
3499 |
Fri, 24 July 2020 10:25
By: Michel Cadot |
|
|
select with while
Oracle 12c By: mape on Wed, 22 July 2020 |
4 |
4584 |
Wed, 22 July 2020 12:23
By: EdStevens |
|
|
ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle |
1 |
4478 |
Wed, 22 July 2020 04:31
By: Michel Cadot |
|
|
XML over 64K By: Mark70 on Tue, 21 July 2020 |
1 |
4485 |
Tue, 21 July 2020 09:57
By: Michel Cadot |
|
 |
ear multivalue json as rows
oracle 19 |
2 |
4738 |
Tue, 21 July 2020 01:54
By: wjuteau |
|
|
Sorting of columns in alternative order.
11g |
4 |
7424 |
Sat, 18 July 2020 15:18
By: Michel Cadot |
|
|
creating a materialized view throws "ORA-01031: insufficient privileges"
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
5 |
9825 |
Wed, 15 July 2020 12:56
By: wtolentino |
|
|
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 |
7540 |
Wed, 15 July 2020 10:33
By: Michel Cadot |
|
|
REGEXP_LIKE to match string in a list
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
2 |
4968 |
Wed, 15 July 2020 08:45
By: wtolentino |
|
|
issue in inserting pdf file in a table
oracle 12c, windows |
10 |
8842 |
Wed, 15 July 2020 06:14
By: Michel Cadot |
|
|
insert rows
12c By: DRDBA on Thu, 09 July 2020 |
4 |
10847 |
Fri, 10 July 2020 15:33
By: EdStevens |
|
|
Run Time Errors 933 and 512 executing Proc
SQL Developer Version 17.3.2.341 |
9 |
13132 |
Fri, 10 July 2020 07:03
By: cfairtp |
|
|
Running script present on webserver
10g |
7 |
11302 |
Wed, 08 July 2020 16:23
By: bluetooth420 |
|
|
Identify the format and display the data type of a string
Oracle DB 11g |
12 |
13091 |
Tue, 07 July 2020 11:10
By: Michel Cadot |
|
|
To store table row count in the same table's comment
any version Oracle |
4 |
12144 |
Mon, 06 July 2020 09:49
By: Olexandr Siroklyn |
|
|
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 |
12935 |
Mon, 06 July 2020 05:51
By: Operator101 |
|
|
DB link issue in cloned databases on same host
11.1.0.7.0 By: aloksk on Tue, 28 January 2020 |
8 |
15539 |
Fri, 03 July 2020 03:04
By: Sooqa |
]
Blog
Search
Help
Members
Register
Login
Home