ORACLE中 用Forall与bulk collect快速复制表数据

　　4相关附助SQL:

　　select 'type TYPE_' || column_name || ' is table of ' || table_name || '.' ||

　　column_name || '%type'

　　from dba_tab_columns

　　where table_name = 'EMPLOYEES'

　　and owner = 'HYF'

　　select 'V_' || column_name || ' TYPE_' || column_name ||';'

　　from dba_tab_columns

　　where table_name = 'EMPLOYEES'

　　and owner = 'HYF'

　　select 'V_' || column_name || ','

　　from dba_tab_columns

　　where table_name = 'EMPLOYEES'

　　and owner = 'HYF'

　　select 'V_' || column_name || '(i),'

　　from dba_tab_columns

　　where table_name = 'EMPLOYEES'

　　and owner = 'HYF'