[20160303]顯示bbed x命令格式.txt

[20160303]顯示bbed x命令格式.txt

--使用bbed顯示資料資訊時要選對型別，隨手寫一個指令碼
prompt
PROMPT DISPLAY BBED EXAMINE(X) FORMAT
prompt

SELECT REPLACE (wmsys.wm_concat (c1), ',') c80
  FROM (  SELECT data_type
                ,column_name
                ,DECODE
                 (
                    data_type
                   ,'NUMBER', 'n'
                   ,'CHAR', 'c'
                   ,'VARCHAR', 'c'
                   ,'VARCHAR2', 'c'
                   ,'DATE', 't'
                   ,' '
                 )
                    c1
            FROM dba_tab_cols
           WHERE owner = UPPER(nvl('&1',user)) AND TABLE_NAME = UPPER( '&2')
        ORDER BY column_id);
 
 
SCOTT@book> select rowid,emp.* from emp where rownum=1;
ROWID                   EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
------------------ ---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
AAAVREAAEAAAACXAAA       7369 SMITH      CLERK           7902 1980-12-17 00:00:00        800                    20

SCOTT@book> @ &r/rowid AAAVREAAEAAAACXAAA
    OBJECT       FILE      BLOCK        ROW DBA                  TEXT
---------- ---------- ---------- ---------- -------------------- ----------------------------------------
     87108          4        151          0 4,151                alter system dump datafile 4 block 151 ;

SCOTT@book> @ &r/bbedcol scott emp

DISPLAY BBED EXAMINE(X) FORMAT

old  16:            WHERE owner = UPPER(nvl('&1',user)) AND TABLE_NAME = UPPER( '&2')
new  16:            WHERE owner = UPPER(nvl('scott',user)) AND TABLE_NAME = UPPER( 'emp')
C80
--------------------------------------------
nccntnnn

BBED> set dba 4,151
        DBA             0x01000097 (16777367 4,151)

BBED> p *kdbr[0]
rowdata[529]
------------
ub1 rowdata[529]                            @8150     0x2c

BBED> x /rnccntnnn
rowdata[529]                                @8150
------------
flag@8150: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8151: 0x01
cols@8152:    8

col    0[3] @8153: 7369
col    1[5] @8157: SMITH
col    2[5] @8163: CLERK
col    3[3] @8169: 7902
col    4[7] @8173: 1980-12-17 00:00:00
col    5[2] @8181: 800
col    6[0] @8184: *NULL*
col    7[2] @8185: 20

--這樣操作方便許多!