Sponsored Content
Full Discussion: How to connect to oracle ??
Top Forums Shell Programming and Scripting How to connect to oracle ?? Post 302101724 by suntac on Thursday 4th of January 2007 03:40:00 AM
Old 01-04-2007
remove email and website refs

Quote:
Originally Posted by inquirer
Code:
sqlplus <user>/<password> <<eof
select <column name> from <table>;
eof

there are other ways to do this. kindly use the search function first.

hope this helps.
Please remember that you will need the Oracle client software installed onto your system. You can download the software from the Oracle website.

http://www.oracle.com/technology/sof...10g/index.html



Regards, Johan Louwers.

removed email and website refs

Last edited by blowtorch; 01-04-2007 at 07:36 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to connect ORACLE using PERL

Hi Friends, I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement. Could anyone pls let me know. I've tried below command which i found in some website, But it throws some error.:confused: Executed: perl -e 'use DBI; print... (1 Reply)
Discussion started by: Vijayakumarpc
1 Replies

2. Shell Programming and Scripting

How to connect oracle from unix

Hi All, I am trying to connect oracle from unix mechine but i am getting an error like Ksh: sqlplus: not found Any one please tell me how to connect oracle from unix mechine. I would appreciate if any one send the query. Regards, Ravi kumar.Gongati (2 Replies)
Discussion started by: ravi gongati
2 Replies

3. Solaris

Connect Oracle from NATted IP

We have a Sun solaris 9 server (say A), with oracle 9 installed and running, at one place(say X). We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the... (0 Replies)
Discussion started by: skbpk_in
0 Replies

4. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies

5. Shell Programming and Scripting

Unix - Oracle DB Connect

Hello, Returing to Unix scripts after a long while, This might be a simple question for most of you , I need to connect from a .sh script to oracle, select XYZ.nextval from dual , , meaning either get the Current Val or Next Val for a sequence. How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies

6. UNIX for Dummies Questions & Answers

Not able to connect Oracle

In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found".. (6 Replies)
Discussion started by: ripudaman.singh
6 Replies

7. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

8. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

9. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

10. Shell Programming and Scripting

Connect to Oracle database

could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever. requirement: 1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
lp-shell(1)						      General Commands Manual						       lp-shell(1)

NAME
lp-shell - Open an interactive launchpadlib shell. SYNOPSIS
lp-shell [-a] [-cPROGRAM] [--python] [--ipython] [service] [LP API version] DESCRIPTION
lp-shell opens an interactive Python shell with a launchpadlib.Launchpad object "lp" which is ready for use. It authenticates against Launchpad with the consumer name "udt-lp-shell". When using lp-shell with the -a option it will use the anonymous login from launchpadlib.Launchpad. By default lp-shell connects to the "production" Launchpad service using the "1.0" LP API version. If you want to connect to another Launchpad service, call lp-shell with the service name as the second argument. lp-shell supports all ser- vices known by launchpadlib Python module. Currently known are (list can be incomplete or outdated): "production", "staging", "dogfood". A different LP API version can be selected by passing the API version to use as the third argument. Current supported are: "beta", "1.0" and "devel". OPTIONS
-a Login anonymously into Launchpad. -c PROGRAM Don't enter a shell but only run the specified Python program and exit. --ipython Use an ipython shell if available (default). --python Use a regular python shell. AUTHORS
lp-shell was written by Martin Pitt <martin.pitt@ubuntu.com>. It is released under the terms of the GNU General Public License, version 2 or (at your option) any later version. lptools 27 March 2010 lp-shell(1)
All times are GMT -4. The time now is 05:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy