tora
tora copied to clipboard
Export table comments in Schema Browser
This is not an issue, but a small enhancement. I wanted to extraxt, with the table schema, also the comments on the column. So I changed the Oracle DbmsMetadataGetDll this way:
SELECT concat(concat(dbms_metadata.get_ddl(:typ<char[100]>, :nam<char[100]>, :sch<char[100]>),chr(10)),case when :typ<char[100]> = 'TABLE' then dbms_metadata.get_dependent_ddl('COMMENT', :nam<char[100]>, :sch<char[100]>) else empty_clob() end) FROM dual
I dind't find a better place to attach small user personalization, so here it is...