//if判断语句: declare i number:=2; begin if i>0 then dbms_output.put_line('good1!'); elsif i>1 then dbms_output.put_line('good2!'); else dbms_output.put_line('good3!'); end if; end; / //再问一个sql如何查看当前用户当天创建的所有表信息: SELECT object_name, created FROM all_objects WHERE owner = 'SYSTEM' AND object_type = 'TABLE' and created>=trunc(sysdate)
declare
i number:=2;
begin
if i>0 then
dbms_output.put_line('good1!');
elsif i>1 then
dbms_output.put_line('good2!');
else
dbms_output.put_line('good3!');
end if;
end;
/
//再问一个sql如何查看当前用户当天创建的所有表信息:
SELECT object_name, created
FROM all_objects
WHERE owner = 'SYSTEM' AND object_type = 'TABLE'
and created>=trunc(sysdate)