Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle rdb problem

 
durgavms4444
Occasional Contributor

oracle rdb problem

sql> att 'f   db';

 select xxxx,yyyy from table limit to 2 rows;

 aaaa                   bbb
 89610300000400000011   z.Ù.-ÃØÇV=.§o´.Ò
 89610300000400000029   .Hm.Xo.y¥Ïû.ÙM.´

i have selected the data inbuilt function called oz_decode_bbb

now check the details


SQL> select aaaa,oz_decode_bbb(bbb) from table limit to 2 rows;

 aaaa
 89610300000400000011   7A95D9992DC3D8C7563D8EA76FB49CD2
 89610300000400000029   95486DA0586F9F79A5CFFB99D94D88B4
2 rows selected

my question:

==============

when i do rmu/unload this table encripted colu,mn is showling blank.. is  there any otherway encripted column to do rmu/unload

 

1 REPLY 1
black_cat
Advisor

Re: oracle rdb problem

Hi, 

you may get better response if your write to the RDB mailing list: oraclerdb@jcc.com.

John