[20210422]如何查看字符的ascii编码.txt
--//在链接http://blog.itpub.net/267265/viewspace-2769217/ => [20210421]如何使用dumpsga转储sga.txt
--//设计到查看字符的ascii编码。
>S:1E9BC408B7D96D495E0098F1E70FAEB7065BC203B03049D487728443FB41l
--//自己做一些总结:
1.方法一:
--//在vim下使用ga,g8命令
>
--//输入ga 在提示栏显示 <>> 62, Hex 3e, Octal 076
--//或者输入:as :ascii 也可以实现。
--//输入g8 在提示栏显示 3e
2.方法二:
--//执行man ascii查看文档,后面还附上了紧凑的表格:
TABLES
For convenience, let us give more compact tables in hex and decimal.
2 3 4 5 6 7 30 40 50 60 70 80 90 100 110 120
------------- ---------------------------------
0: 0 @ P ' p 0: ( 2 < F P Z d n x
1: ! 1 A Q a q 1: ) 3 = G Q [ e o y
2: " 2 B R b r 2: * 4 > H R \ f p z
3: # 3 C S c s 3: ! + 5 ? I S ] g q {
4: $ 4 D T d t 4: " , 6 @ J T ^ h r |
5: % 5 E U e u 5: # - 7 A K U _ i s }
6: & 6 F V f v 6: $ . 8 B L V ' j t ~
7: ' 7 G W g w 7: % / 9 C M W a k u DEL
8: ( 8 H X h x 8: & 0 : D N X b l v
9: ) 9 I Y i y 9: ' 1 ; E O Y c m w
A: * : J Z j z
B: + ; K [ k {
C: , < L \ l |
D: - = M ] m }
E: . > N ^ n ~
F: / ? O _ o DEL
3.反向呢?比如知道3e显示字符呢?
--//我自己定义一些快捷,文本如下:
" xd convert ascii code to character strings
" xr convert char strings to ascii code
" x4 reverse ascii code (4) and convert ascii code to character strings
" r reverse ascii code (4)
noremap <leader>xd Yp!!xxd -r -p<CR>kA = <ESC>J
vnoremap ;xd "ay<ESC>o<ESC>"apo<ESC>"ap!!xxd -r -p<CR>kA = <ESC>J
noremap <leader>xr Yp!!xxd -c 40 -g 1 \|sed -e "s/^0\+: //" -e "s/ 0d 0a.*$//" <CR>kA = <ESC>J
vnoremap ;xr "ay<ESC>o<ESC>"apo<ESC>"ap!!xxd -c 40 -g 1 \|sed -e "s/^0\+: //" -e "s/ 0d 0a.*$//" <CR>kA = <ESC>J
noremap <leader>x4 Yp!!xxd -r -p \|od --width=64 -t x4 \| sed -n "s/^0\+ //p" \|xxd -r -p<CR>kA = <ESC>J
vnoremap ;x4 "ay<ESC>o<ESC>"apo<ESC>"ap!!xxd -r -p\|od --width=64 -t x4 \| sed "s/^0\+ //" \|xxd -r -p<CR>kA = <ESC>J
noremap <leader>r Yp!!xxd -r -p \|od -t x4 \| sed -n "s/^0\+ //p"<CR>kA = <ESC>J
vnoremap ;r "ay<ESC>o<ESC>"apo<ESC>"ap!!xxd -r -p\|od -t x4 \| sed "s/^0\+ //"<CR>kA = <ESC>J
--//通过例子说明:
BBED> set dba 100,51844
DBA 0x1900ca84 (419482244 100,51844)
BBED> x /rcncnnttttncnnnnnccnnncct *kdbr[27]
rowdata[0] @3244
----------
flag@3244: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@3245: 0x00
cols@3246: 22
ckix@3247: 5
col 0[6] @3248: SYSTEM
col 1[2] @3255: 1
col 2[16] @3258: 2D594E86F93B17A1
col 3[1] @3275: 0
col 4[2] @3277: 3
col 5[7] @3280: 2013-08-24 11:37:40
col 6[7] @3288: 2017-02-03 16:39:59
col 7[7] @3296: 2016-08-24 11:45:42
col 8[7] @3304: 2013-08-24 12:07:04
col 9[1] @3312: 0
col 10[0] @3314: *NULL*
col 11[2] @3315: 1
col 12[0] @3318: *NULL*
col 13[0] @3319: *NULL*
col 14[1] @3320: 0
col 15[1] @3322: 0
col 16[22] @3324: DEFAULT_CONSUMER_GROUP
col 17[0] @3347: *NULL*
col 18[1] @3348: 0
col 19[0] @3350: *NULL*
col 20[0] @3351: *NULL*
col 21[62] @3352: S:1E9BC408B7D96D495E0098F1E70FAEB7065BC203B03049D487728443FB41
SYS@book> alter system dump datafile '/u01/tmp/book/60c00000' block 51844;
System altered.
tab 1, row 6, @0xc50
tl: 171 fb: -CH-FL-- lb: 0x0 cc: 22 cki: 5
col 0: [ 6] 53 59 53 54 45 4d
col 1: [ 2] c1 02
col 2: [16] 32 44 35 39 34 45 38 36 46 39 33 42 31 37 41 31
col 3: [ 1] 80
col 4: [ 2] c1 04
col 5: [ 7] 78 71 08 18 0c 26 29
col 6: [ 7] 78 75 02 03 11 28 3c
col 7: [ 7] 78 74 08 18 0c 2e 2b
col 8: [ 7] 78 71 08 18 0d 08 05
col 9: [ 1] 80
col 10: *NULL*
col 11: [ 2] c1 02
col 12: *NULL*
col 13: *NULL*
col 14: [ 1] 80
col 15: [ 1] 80
col 16: [22]
44 45 46 41 55 4c 54 5f 43 4f 4e 53 55 4d 45 52 5f 47 52 4f 55 50 = DEFAULT_CONSUMER_GROUP
--//直接输入\xd就能显示对应字符。
--//44 45 46 41 55 4c 54 5f 43 4f 4e 53 55 4d 45 52 5f 47 52 4f 55 50 = DEFAULT_CONSUMER_GROUP
--//还可以选中字符串,注意一定要在select模式,不对按ctrl+g,然后按;xd
--//44 45 46 41 55 4c 54 5f 43 4f 4e 53 55 4d 45 52 5f 47 52 4f 55 50
44 45 46 41 55 4c 54 5f 43 4f 4e 53 55 4d 45 52 5f 47 52 4f 55 50 = DEFAULT_CONSUMER_GROUP
--//反向操作,输入\xr,就能显示
--//DEFAULT_CONSUMER_GROUP = 44 45 46 41 55 4c 54 5f 43 4f 4e 53 55 4d 45 52 5f 47 52 4f 55 50
--//其它大家可以自行测试。
col 17: *NULL*
col 18: [ 1] 80
col 19: *NULL*
col 20: *NULL*
col 21: [62]
53 3a 31 45 39 42 43 34 30 38 42 37 44 39 36 44 34 39 35 45 30 30 39 38 46
31 45 37 30 46 41 45 42 37 30 36 35 42 43 32 30 33 42 30 33 30 34 39 44 34
38 37 37 32 38 34 34 33 46 42 34 31
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/267265/viewspace-2769425/ ,如需转载,请注明出处,否则将追究法律责任。