oracle查询中变量赋值 with as语句问题

Question

--说明：就是变量newdate如何作为查询的一列显示。下面的代码要怎么写才不报错？statc_dt 是date类型
declare
newdate date:=sysdate;
begin
select max(statc_dt) into newdate from crm_cust;
end;

select client_name,'&newdate' from client

Answer 1

declare
newdate date:=sysdate;
begin
select max(statc_dt) into newdate from crm_cust;
end;
select client_name,(select max(statc_dt) from crm_cust) as 新日期 from client
或者
declare
newdate date:=sysdate;
begin
select max(statc_dt) into newdate from crm_cust;
end;
select client_name,(select statc_dt from crm_cust where statc_dt='&newdate') as 新日期 from client;
如果有用，请给点积分，最近确实紧缺。。。