This blog post gives a piece of simple SQL that will allow you to automatically copy the comments from one database view to another. In the case of this example we are copying the column comments from a standard oracle view to a materialised view which has the same name except with "_MV" suffix.The PL/SQL block is;declare v_ViewName varchar2(30) := 'XXX';begin for v_Comment in (select acc.COLUMN_NAME, REPLACE(REPLACE(acc.COMMENTS, chr(13), ''), chr(10), '') comments ...
Monday, September 6, 2010
Subscribe to:
Posts (Atom)
