sql 命令

清空表中一列数据】

sql=" update 表 set 字段1=null"

 

找出所有数据为空的表

-- Created on 2010-3-15 by YUZQ

declare

  -- Local variables here

  i           integer ;

  v_row_count number ;

begin

  -- Test statements here

  for v_sql in ( select 'select count(*) from ' || g.table_name as sqlstring

                  from user_all_tables g

                 where g.table_name like 'T_%' ) loop

 

    execute immediate v_sql.sqlstring

      into v_row_count;

 

    if v_row_count > 0 then

      dbms_output.put_line(v_sql.sqlstring);

    end if ;

 

  end loop ;

 

end ;