var last_create_time varchar2(19)
begin
select
to_char(max(created), 'yyyy-mm-dd hh24:mi:ss') into :last_create_time
from
user_objects;
end;
/
begin
dbms_output.put_line('Last creation time: ' || :last_create_time);
end;
/
Datatypes
A bind variable can be set to one of the following data types: