oracle动态表名

set serveroutput on
declare
    n number;
    sql_stmt varchar2(50);
    t varchar2(20);
begin
    execute immediate 'alter session set nls_date_format=''YYYYMMDD''';
    t := 't_' || sysdate;
    sql_stmt := 'select count(*) from ' || t;
    execute immediate sql_stmt into n;
    dbms_output.put_line('The number of rows of ' || t || ' is ' || n);
end;

评论

1 楼 happyxing 2010-06-21  

问题相同，我也纠结