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

Advertisements

About Nick Xu

Not a DBA anymore
This entry was posted in Oracle. Bookmark the permalink.

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

  1. latha says:

    Thanks so much

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s