toad中sql中如何定义变量?
例
define sc='690126';
select * from stud where id='&sc';
select * from zck where id='&sc';
例
define sc='690126';
select * from stud where id='&sc';
select * from zck where id='&sc';
sc varchar2(20) := '690126';
begin
select * from stud where id = sc; --查询的结果需要定义游标去接收。
end;