We want to create a Dynamic SQL, which creates a NEW_table. NEW_Table Name, Its columns, column size, and each column comments are in another Metadata table. So this SQL have to read from this metadata table and create the NEW_table.
?
This Dynamic SQL should be in wrapper script or Stored procedure, which will be executed from an ETL. We can provide more details on the table & columns names. Environment is Oracle 10g.