How to get localhost in windiws.......
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to get localhost in windiws.......

  1. #1
    Join Date
    May 2003
    Location
    Bangalore , India
    Posts
    31

    How to get localhost in windiws.......

    How to get localhost of oracle 8.1.7 in windiws 2000 through PL/SQL code...
    Last edited by mohit_sharan; 06-16-2003 at 07:24 AM.
    Mohit Sharan
    DBA
    Bangalore.
    Cell No : 91-9845211820

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    Re: How to get localhost in windiws.......

    Originally posted by mohit_sharan
    How to get localhost of oracle 8.1.7 in windiws 2000 through PL/SQL code...
    Don't know if this is the right answer :
    select sys_context('USERENV','TERMINAL') from dual;
    or
    select sys_context('USERENV','IP_ADDRESS') from dual ;
    HTH
    Giani

  3. #3
    Join Date
    May 2003
    Location
    Bangalore , India
    Posts
    31
    Hi,

    I got the answer . The query is :

    select host_name from v$instance;
    Mohit Sharan
    DBA
    Bangalore.
    Cell No : 91-9845211820

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