Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to convert long2 varchar into varchar2 in oracle". In daily operation, I believe many people have doubts about how to convert long2 varchar into varchar2 in oracle. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts of "how to convert long2 varchar into varchar2 in oracle"! Next, please follow the small series to learn together!

SQL> desc dbms_metadata_util

…...

FUNCTION LONG2VARCHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

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

LENGTH NUMBER IN

TAB VARCHAR2 IN

COL VARCHAR2 IN

ROW ROWID IN

…...

create table t1 (name long);

insert into t1 values('a');

insert into t1 values('b');

insert into t1 values('c');

commit;

SQL> select sys.dbms_metadata_util.long2varchar(100,'scott.t1','name',rowid) from scott.t1;

SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(100,'SCOTT.T1','NAME',ROWID)

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

a

b

c

SQL> select * from scott.t1 where sys.dbms_metadata_util.long2varchar(100,'scott.t1','name',rowid) = 'a';

NAME

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

a

At this point, the study of "how to convert long to varchar2 in oracle" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.