how to connect oracle in unix prompt?
Answers were Sorted based on User's Feedback
HI,
This is not a big job
$ su orcale10g
$sql plus
username/password-scott/tiger
If not connected just mail me on my mail id
omkarp.joshi@yahoo.co.uk
| Is This Answer Correct ? | 11 Yes | 5 No |
Answer / vipul garg
Hi,
$ sqlplus sys/sys as sysdba
If connect a instance then
first set environment variable as :
$ export ORACLE_SID = instance_name
$ sqlplus username/password@servicename
Regards
Vipul Garg
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mannu
You have to set the following:
ORACLE_HOME
ORACLE_SID
PATH
| Is This Answer Correct ? | 4 Yes | 6 No |
How is pl sql different from sql?
what is explain plan?, given an example...
How do rank () and dense_rank () differ?
What does select top 1 do in sql?
Types of locks in database ?
What is a record in pl/sql?
Does sql support programming?
What is meant by temporal data?
What are the different types of triggers?
what is meant by DML?
What is user define exception and example
What is Data Concarency and Consistency?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)