DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Password field

  1. #1
    Join Date
    Dec 2000
    Posts
    10

    Question

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Use sqlplus 'hide' option with the sql/plsql programming....See documentation on the same...

  3. #3
    Join Date
    Oct 2000
    Posts
    123
    Would you mind tell me where is the docs p.l?

    Thanks

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.

  5. #5
    Join Date
    Dec 2000
    Posts
    10

    Exclamation

    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

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  


Click Here to Expand Forum to Full Width