平阳腾威

select a.column_name    字段名,        decode(a.data_type,'VARCHAR2',data_type || '(' || a.data_length || ')',        'NUMBER', data_type || '(' || data_precision || ')',        'DATE', data_type,       ...

select 'alter trigger "' || tr.trigger_name || '" disable;'  from user_triggers tr where substr(tr.trigger_name, 0, 4) <> 'BIN$' order by tr.trigger_name; select 'alter table ' || u.table_name |...