Question

is it possible to run dbms_metadata.get_ddl and exclude column default value and virtual columns?

score 25 · Answer 1 · 2024-03-13T09:52:29.820000

25

Views

is it possible to run dbms_metadata.get_ddl and exclude column default value and virtual columns?

Published on 13 March 2024 at 09:52

score 88 · Answer 2 · 2023-07-06T18:50:46.810000

88

Views

How to remove Flashback Archive statements from Oracle's dbms_metadata.fetch_ddl output

Published on 06 July 2023 at 18:50

score 357 · Answer 3 · 2023-05-21T20:59:14.460000

357

Views

Oracle Get DDL without extra details and sort - to use for version control

Published on 21 May 2023 at 20:59

score 15 · Answer 4 · 2023-05-19T00:55:27.173000

15

Views

How can I get user creation code using DBMS_METADATA?

Published on 19 May 2023 at 00:55

score 130 · Answer 5 · 2023-02-25T00:55:36.913000

130

Views

Want to limit results from dbms_metadata.get_granted_ddl for object_grant in Oracle

Published on 25 February 2023 at 00:55

score 249 · Answer 6 · 2022-04-01T15:13:16.760000

249

Views

How do i use DBMS_METADATA.SET_FILTER to exclude all TMP_ tables except TMP_BAR?

Published on 01 April 2022 at 15:13

score 2.4k · Answer 7 · 2021-11-16T13:57:45.583000

2.4k

Views

How to decrypt the password which is encrypted by oracle?

Published on 16 November 2021 at 13:57

score 119 · Answer 8 · 2021-10-12T10:26:25.870000

119

Views

ORA-31607 on DBMS_METADATA.PUT(CLOB): Either (1) FETCH_XML was called

Published on 12 October 2021 at 10:26

score 354 · Answer 9 · 2021-08-21T17:51:43.823000

354

Views

how to access index (DDL) of the table in pl/sql using DBMS_METADATA.GET_DDL

Published on 21 August 2021 at 17:51

score 870 · Answer 10 · 2021-07-28T15:12:08.907000

870

Views

Oracle SQL Spool dbms_metadata.get_ddl different in 19c

Published on 28 July 2021 at 15:12

score 262 · Answer 11 · 2020-07-22T21:59:50.040000

262

Views

How to remove Primary Key from DBMS_METADATA?

Published on 22 July 2020 at 21:59

score 304 · Answer 12 · 2020-04-17T07:43:42.373000

304

Views

How to save Oracle DDL in an automated fashion

Published on 17 April 2020 at 07:43

score 1.1k · Answer 13 · 2020-03-06T21:27:31.937000

1.1k

Views

How to i read the contents of Oracle stored procedures using Python

Published on 06 March 2020 at 21:27

score 277 · Answer 14 · 2020-03-04T14:26:19.690000

277

Views

Using python cx_Oracle, how do I call DBMS_METADATA.SET_TRANSFORM_PARAM, which has multiple declarations?

Published on 04 March 2020 at 14:26

score 1.2k · Answer 15 · 2020-02-29T07:38:59.463000

1.2k

Views

Oracle's dbms_metadata.get_ddl for type DIRECTORY: invalid input value for parameter SCHEMA

Published on 29 February 2020 at 07:38

score 881 · Answer 16 · 2019-08-14T07:08:07.420000

881

Views

How can i ignore create portioned script from create table script using get_ddl in oracle?

Published on 14 August 2019 at 07:08

score 57 · Answer 17 · 2019-06-03T13:49:25.997000

57

Views

How to configure dbms_metadata.get_ddl to add 'ASC' after every column of the index?

Published on 03 June 2019 at 13:49

score 1.4k · Answer 18 · 2019-05-17T14:02:45.940000

1.4k

Views

ORA-00904: "DBMS_METADATA"."GET_DDL": invalid identifier

Published on 17 May 2019 at 14:02

score 326 · Answer 19 · 2019-04-29T10:21:29.213000

326

Views

how to convert DBMS_METADATA Oracle to Postgres?

Published on 29 April 2019 at 10:21

score 767 · Answer 20 · 2018-03-08T05:59:47.553000

767

Views

How to get exact table definition in PlSql

Published on 08 March 2018 at 05:59

List Question

is it possible to run dbms_metadata.get_ddl and exclude column default value and virtual columns?

How to remove Flashback Archive statements from Oracle's dbms_metadata.fetch_ddl output

Oracle Get DDL without extra details and sort - to use for version control

How can I get user creation code using DBMS_METADATA?

Want to limit results from dbms_metadata.get_granted_ddl for object_grant in Oracle

How do i use DBMS_METADATA.SET_FILTER to exclude all TMP_ tables except TMP_BAR?

How to decrypt the password which is encrypted by oracle?

ORA-31607 on DBMS_METADATA.PUT(CLOB): Either (1) FETCH_XML was called

how to access index (DDL) of the table in pl/sql using DBMS_METADATA.GET_DDL

Oracle SQL Spool dbms_metadata.get_ddl different in 19c

How to remove Primary Key from DBMS_METADATA?

How to save Oracle DDL in an automated fashion

How to i read the contents of Oracle stored procedures using Python

Using python cx_Oracle, how do I call DBMS_METADATA.SET_TRANSFORM_PARAM, which has multiple declarations?

Oracle's dbms_metadata.get_ddl for type DIRECTORY: invalid input value for parameter SCHEMA

How can i ignore create portioned script from create table script using get_ddl in oracle?

How to configure dbms_metadata.get_ddl to add 'ASC' after every column of the index?

ORA-00904: "DBMS_METADATA"."GET_DDL": invalid identifier

how to convert DBMS_METADATA Oracle to Postgres?

How to get exact table definition in PlSql

Trending Questions

Popular # Hahtags

Popular Questions