show parameter cur%
顯示參數(shù)
alter system set flush sharedpool ;
顯示當(dāng)前用戶 oracle 當(dāng)前回話下面
SQL> show user ;
USER 為"HR"
plsql 數(shù)字 輸出 格式化 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
攝入 數(shù)字oracle


PC
----------------------
2,672.0
plsql 命令
根據(jù)字段 不同 時候換行.



FIRST_NAME JOB_ID
-------------------- ----------
Steven AD_PRES
Neena AD_VP
Lex
Nancy FI_MGR




when t.bssign_ = 0 and t.ordbs_ in ('B','S') then 'true'
else 'false'
end) ;
閱讀全文









UPDATE STATEMENT, GOAL = CHOOSE
UPDATE Object owner=IDMP Object name=TEMP_TEST_PM_ORDER
TABLE ACCESS FULL Object owner=IDMP Object name=TEMP_TEST_PM_ORDER
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
























































UPDATE STATEMENT, GOAL = CHOOSE
UPDATE Object owner=IDMP Object name=TEMP_TEST_PM_ORDER
TABLE ACCESS FULL Object owner=IDMP Object name=TEMP_TEST_PM_ORDER
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE
INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE
from col =199012
select *
from col='199012'
查的字段 col 是數(shù)字的 還是用col =199012 快.
from user_col_comments c
where c.table_name = upper('acc_fundcap') 閱讀全文
datalink 提示 ora-12154 tns 無法處理服務(wù)名
2 遠(yuǎn)程控制的機器 tns file添加了 , 然后連接到其他的機器上的 在其他機器上創(chuàng)建 datalink 和 synonym .不查詢的時候不報錯..一旦查詢了 就開始說tns 沒沒找到.
閱讀全文
set echo on
set echo off
表示打開或者關(guān)閉查詢的顯示
三個環(huán)境變量的設(shè)置
echo 是否現(xiàn)實執(zhí)行的命令內(nèi)容
feedback 是否現(xiàn)實 * rows selected
pagesize 頁面大小設(shè)置
可分開寫
set echo on/off
set feedback on/off
set pagesize 999
set echo on,則顯示出文件中的每條命令和該命令執(zhí)行的結(jié)果,如果設(shè)為set echo off,則只顯示命令執(zhí)行的結(jié)果,而不顯示出命令本身。