tora icon indicating copy to clipboard operation
tora copied to clipboard

Export table comments in Schema Browser

Open dandfra opened this issue 8 years ago • 0 comments

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...

dandfra avatar Oct 27 '17 11:10 dandfra