Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Unanswered: IP Address of database server in SQL Prompt

    Hi

    How do I get the IP Address of my database server
    in the SQLPrompt in SQL Plus.

    Like ....

    scott@192.9.200.200>

    where 192.9.200.200 is the Ip Address of the Database Server.

    Thanks in Advance ...

    Suddha

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    You could probably write a Java Stored Procedure on the server side that went out and got the information from the OS. Then, in your login.sql you could call that procecure...

    Of course, in a environment with multiple NICs, this becomes a little more difficult...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •