show parameter cur%
顯示參數
alter system set flush sharedpool ;
顯示當前用戶 oracle 當前回話下面
SQL> show user ;
USER 為"HR"
plsql 數字 輸出 格式化 column format 輸出 千
SQL> col pc format 999,999,999,999,999.9
SQL> select 8*333 pc from dual;
PC
----------------------
2,664.0
----------------------
2,664.0
攝入 數字oracle
SQL> select round( 8*333.99999 , 2 ) pc from dual;
PC
----------------------
2,672.0
plsql 命令
根據字段 不同 時候換行.
SQL> break on job_id skip 2 ;
SQL> select first_name , job_id from employees
2 where rownum < 10 order by job_id ;
FIRST_NAME JOB_ID
-------------------- ----------
Steven AD_PRES
Neena AD_VP
Lex
Nancy FI_MGR
SELECT DECODE(TOTALQ, 0, 'No Requests',
WAIT/TOTALQ || ' HUNDREDTHS OF SECONDS') "AVERAGE WAIT TIME PER REQUESTS"
FROM V$QUEUE
WHERE TYPE = 'COMMON';