查看使用率SQL> select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable, number_of_files as "number"from v$flash_recovery_area_usage;FILE_TYPE USED RECLAIMABLE number-----------...【阅读全文】
游标语法:CURSOR 游标名 IS SELECT ...;例子:****************************形式一****************************SET SERVEROUTPUT ONDECLARE A ...; B ...;CURSOR temp IS SELECT aa , bb from dual;...【阅读全文】