Password field

Hi there,
I would like to make one of my table field as "password" field. To make the question clear... I would like the entries appear as "******" instead of the actual characters..

I know the way to do it in Access but couldn't find the method in Oracle. Could you please help me out with this.

Ta..

Cheers,
krishna

Use sqlplus 'hide' option with the sql/plsql programming....See documentation on the same...

Would you mind tell me where is the docs p.l?

Thanks

See my posting with thread name '8.1.7 docs' dated last week on dba forum. It has a link to the technet docs site.

Hi,
Thanks for your reply sreddy.. but it will be more helpful if you could explain ur answer a bit about using "hide".. Thanks..

Regards,
krishna

See the usage in the following script: I have just cut and paste part of script for example.


select to_char(sysdate,'DD-MON-YYYY HH24:MI') c from dual;
accept REMOTESCHEMA char prompt 'Enter remote username:'
accept REMOTEPASSW char prompt 'Enter remote password:' hide
accept connstring char prompt 'Enter remote connectstring:'
spool tblsdiff

PROMPT
PROMPT
PROMPT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PROMPT TABLE DATA DIFFERENCES &todaysdate
PROMPT
PROMPT this schema: &thisuser
PROMPT remote schema: &remoteschema.@&connstring
PROMPT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PROMPT
PROMPT

create database link &prex.lnk connect to &REMOTESCHEMA identified
by &REMOTEPASSW using '&CONNSTRING';