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;
如果有用，请给点积分，最近确实紧缺。。。

select client_name,' & newdate & ' from client
这样变量坐字段名？

declare
newdate date:=sysdate;
begin
select max(statc_dt) into ' & newdate & ' from crm_cust;
end;
select client_name,' & newdate & ' from client
试一下

declare
newdate date:=sysdate;
begin
select max(statc_dt) into ' & newdate & ' from crm_cust;
end;
select client_name,' & newdate & ' from client

select client_name,(select max(statc_dt) from crm_cust) as newdate from client