可以通过oracle中的cast_to_varchar2这个函数进行转换。
select replace(utl_raw.cast_to_varchar2(fid),chr(10)) from tflow
SELECT dbms_lob.substr(fid) FROM tflow
*******************************************************************
*******************************************************************
给oracle表中添加注释:
-- Add comments to the table
comment on table EGS_WD_FILE is '临时表';
-- Add comments to the columns
COMMENT ON COLUMN EGS_WD_FILE.FILENAME IS '文件夹名称';
COMMENT ON COLUMN EGS_WD_FILE.FILENO IS '文件夹编号';
COMMENT ON COLUMN EGS_WD_FILE.FILEID IS '文件夹ID';
可以通过以下语句查询:
select * from user_tab_comments where comments is not null;
select * from user_col_comments where comments is not null;