Thursday 23 April 2009

database name from oracle connection

I always get lost in oracle world. I connect from database to database all of the time and forget where I am. I know that this is going to make me delete records from the wrong table... I know...

select ora_database_name from dual

Tells me where I am. I wanna change my prompt to be this, but that will need to wait.

No comments: