bbed—- dump controlfile to find dbid and dbname

Posted: 三月 5, 2011 in oracle

http://www.eygle.com/faq/Faq_convert.htm

1.BBED dump control file ,dbid and db_name
  dbid 8
  dbname 9-10 

SQL> select utl_raw.cast_to_varchar2(‘4f52434c00000000’) from dual;

UTL_RAW.CAST_TO_VARCHAR2(‘4F52434C00000000’)
——————————————————————————–
ORCL

SQL>  select to_number(‘4bccdf02′,’xxxxxxxx’) from dual;

TO_NUMBER(‘4BCCDF02′,’XXXXXXXX’)
——————————–
                      1271717634

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s