Modifying SQL*Plus Command Prompt on UNIX

Does anyone have a method to modify the UNIX SQL*Plus command prompt which includes elements such as UNIX hostname and Oracle userid. For example, I would like to set the prompt to look like the following:

    userid_at_hostname:SQL>

where userid is the account the user is logged in to Oracle with and hostname is dynamically set based on the host the user is running SQL*Plus on.

What would the glogin.sql or login.sql statements be to accomplish this?

Would appreciate any help. Thanks. Received on Sun Jul 23 1995 - 00:00:00 CEST