换为rowid类型

sql>selectrowid,rowidtochar(rowid),enamefromscott.emp;

rowidrowidtochar(rowid)ename

----------------------------------------------

aaaafkaacaaaaeqaaaaaaafkaacaaaaeqaaasmith

aaaafkaacaaaaeqaabaaaafkaacaaaaeqaaballen

aaaafkaacaaaaeqaacaaaafkaacaaaaeqaacward

aaaafkaacaaaaeqaadaaaafkaacaaaaeqaadjones

43.convert(c,dset,sset)

将源字符串sset从一个语言字符集转换到另一个目的dset字符集

sql>selectconvert(‘strutz‘,‘we8hp‘,‘f7dec‘)”conversion”fromdual;

conver

------

strutz

44.hextoraw

将一个十六制构成的字符串转换为二制

45.rawtohext

将一个二制构成的字符串转换为十六制

46.rowidtochar

将rowid数据类型转换为字符类型

47.to_char(date,‘format‘)

sql>selectto_char(sysdate,‘yyyy/mm/ddhh24:mi:ss‘)fromdual;

to_char(sysdate,‘yy

-------------------

2004/05/0921:14:41

48.to_date(string,‘format‘)

将字符串转化为oracle中的一个日期

49.to_multi_byte

将字符串中的单字节字符转化为多字节字符

sql>selectto_multi_byte(‘‘)fromdual;

to

--

50.to_number

将给的字符转换为数字

sql>selectto_number(‘1999‘)yearfromdual;

year

---------

1999

51.bfilename(dir,file)

指定一个外二制文件

sql>insertintofile_tb1values(bfilename(‘lob_dir1‘,‘image1.gif‘));

52.convert(‘x‘,‘desc‘,‘source‘)

将x字段或变量的源source转换为desc

sql>selectsid,serial#,username,decodemand,

20,‘none‘,

32,‘insert‘,

43,

5‘select‘,

66,‘update‘,

77,‘delete‘,

88,‘drop‘,

9‘other‘)cmdfromv$sessionwheretype!=‘background‘;

sidserial#usernamecmd

------------------------------------------------------

11none

21none

31none

41none

51none

61none

71275none

81275none