Interfacing with Oracle on the command line

I wanted a command line client to access an Oracle server. sqlplus64 is the stock Oracle client. Connect to your server with the following command:

sqlplus64 username/password@//

If you want to see all the tables in the current DB:

select table_name from user_tables;

If you want to see the field names/types of a given table

desc tablename

Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
Logged IP:
To prevent spam please submit by clicking the kitten: