Hello all...

ORacle 9.2

how do i get username@service_name.hostname when i login sqlplus everytime. ?...

For ex: my username = system
host = pedpiora2
service_name= heat

so i should get [email protected]> ...

the reason for this is, i have to login to many DB's and sometimes, i don't know on which database iam working and with what account .

anyhelp is appreciated

Ron