1、創建測試表,
create table test_val(id varchar2(20),remark varchar2(20));
2、插入測試數據;
insert into test_val select level, 'lvl_'||level remark from dual connect by level<=100;
commit;
3、編寫語句,將表中的記錄數賦值給變量;
declare
v_int number;
begin
execute immediate 'select count(*) from test_val' into v_int;end;
4、將變量值打印,查看結果;
dbms_output.put_line(v_int);