[Ilugc] Connect to Oracle database from linux command line ?
- From: rajanvn@xxxxxxxxx (Natarajan V)
- Date: Tue, 6 Dec 2011 11:16:18 +0530
On Tue, Dec 6, 2011 at 9:37 AM, Mohan L <l.mohanphy at gmail.com> wrote:
On Tue, Dec 6, 2011 at 7:28 AM, Karthikeyan S <karthik120 at 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
Other related posts: