Oracle 条件语句

SQL> set serverout on
SQL> declare
  2    rc sys_refcursor;
  3  begin
  4    if to_char(sysdate,'SS') < 30 then
  5       dbms_output.put_line('First half of minute - we go get SYS');
  6       open rc for select * from dba_tables where owner = 'SYS';
  7    else
  8       dbms_output.put_line('Second half of minute - we go get SCOTT');
  9       open rc for select * from dba_tables where owner = 'SCOTT';
 10    end if;
 11  end;
 12  /
Second half of minute - we go get SCOTT

PL/SQL procedure successfully completed.

SQL>
SQL> /
First half of minute - we go get SYS

PL/SQL procedure successfully completed.
复制