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@//1.2.3.4/database_name

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: 54.196.62.132
To prevent spam please submit by clicking the kitten: