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
Leave A Reply
All content licensed under the Creative Commons License