Oracle DDL Python Scripting

Question

I have a Oracle database, that contains metadata of Database Tables. Example.

Table- Entity Entity Property
Emp Table
Position Table

Table Attributes
Attributes Table_Name
Emp_Name Emp
Emp_No Emp
Emp_Add Emp
Postion_id Position
Position_Name Position

I want a python script which you create DDL for the above tables. For example, the output should contain like this tables
create table 'emp','details'
create table 'position','details'

For Attributes, I would like the script to output like this
put 'emp','1','details:Emp_Name','1'
put 'emp','1','details:Emp_No','1'

Please, advise me.

Pavel Zimogorov · Accepted Answer · 2016-04-01 13:32:04Z

1

Maybe you should pay attention on DBMS_METADATA package.

For example:

select DBMS_METADATA.GET_DDL('TABLE', 'EMP') from dual;

link on documentation.
It is available for all Oracle users.

answered Apr 1, 2016 at 13:32

Pavel Zimogorov

1,45211 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3470294 Over a year ago

We are building the table structure from the entries from another table. The DBMS_METADATA will not work in this case.

Collectives™ on Stack Overflow

Oracle DDL Python Scripting

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related