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

    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'