sql prompt current directory

Have you ever had a SQL*Plus window open, and did not remember what it’s current directory was? This tip will show a method to set your SQL*Plus prompt to include the current directory. The SET SQLPROMPT command can be used