Get the “Current Directory” of an Oracle SqlPlus Session

I might be a very very late comer but I am starting to pick up Oracle and this is my first post about this platform. My current playground is my local win7 workstation with an Oracle Express Edition installed. And I’d like to know from which directory I launched my SqlPlus session. Here is the command to get it:

SQL> host cd

Output like the below should be expected:

C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin

Courtesy to the below Oracle forum post here.

However, if you are in a Linux/Unix system, you shall use the below command in sqlplus prompt:

SQL> host pwd


Posted

in

by

Tags:

Comments

One response to “Get the “Current Directory” of an Oracle SqlPlus Session”

  1. latha Avatar
    latha

    Thanks so much

Leave a Reply

Your email address will not be published. Required fields are marked *