On Tue, Dec 6, 2011 at 9:37 AM, Mohan L <l.mohan...@gmail.com> wrote: > On Tue, Dec 6, 2011 at 7:28 AM, Karthikeyan S <karthik...@gmail.com> wrote: >> Is it possible to connect to Oracle database from Linux command line ?
Yes. SQL*Plus and SQL*LDR are the Oracle command line tools available on all platforms including Linux. The command names would be "sqlplus" - for normal query and results and "sqlldr" for bulk data loads from flat files(AKA ETL) . > Read the following post. > 1). Shell Scripting for the Oracle Professional : > www.dba-oracle.com/Shell-Script-sec.pdf > 2). Unix Shell Script to Execute Oracle SQL Query : > http://www.thegeekstuff.com/2010/07/unix-shell-script-to-execute-oracle-sql-query/ Good documentation. It describes how to access Oracle from a Shell Script. If you just want to use it as querying tool, you can skip the script and use the SQLPLUS directly. with regards, Natarajan _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
