to_clob

转换字符为clob类型。

teledb=# select to_clob('teledb') from dual;
 to_clob 
---------
 teledb
(1 row)

teledb=# 

ROWIDTOCHAR

转换rowid值为varchar2类型。

teledb=# \d+ t_rowid
                                  Table "public.t_rowid"
 Column |  Type   | Collation | Nullable | Default | Storage | Stats target | Descripti
on 
--------+---------+-----------+----------+---------+---------+--------------+----------
---
 f1     | integer |           |          |         | plain   |              | 
 f2     | integer |           |          |         | plain   |              | 
Has ROWIDs: yes
Distribute By: SHARD(f1)
Location Nodes: ALL DATANODES

teledb=# SELECT ROWIDTOCHAR(rowid),rowid from t_rowid;
     rowidtochar      |        rowid       
----------------------+----------------------
 XPK3fw==AQAAAAAAAAA= | XPK3fw==AQAAAAAAAAA=
(1 row)

teledb=#

CHARTOROWID

CHARTOROWID(c1)

转换varchar2类型为rowid值，c1，字符串，长度为20的字符串，字符串必须符合rowid 格式。

teledb=# select CHARTOROWID('AAAFd1AAFAAAABSACCAA') a1 from dual;
          a1        
----------------------
 AAAFdw==FAAAABSACCA=
(1 row)

teledb=#