-
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';
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|