oracle 赋值语句,游标,循环查多张表数据:
----声明变量 变量名+类型长度
declare
v_data_value varchar(100);
v_data_value_2 varchar(50):='hello 2';
v_sql varchar(2000);
recordtime date;
------变量赋值
date_value := 'hello world!';
-----定义游标
cursor c_list is select a.name,a.age from t_table_a a order by a.age desc;
begin
for rec in c_list loop
-----注意:就算一rec里面是单个变量,也不能直接取rec去获取对象里面的值
v_data_value :=rec.name;
v_sql :='SELECT * FROM ' || v_data_value;
DBMS_OUTPUT.PUT_LINE(v_sql );
execute immediate v_sql ;
end loop;
commit;
end;