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 |
select top 3 sal from each dept?
17 Answers IBM, TCS,
What is difference between select statement and cursor
If a View on a single base table is manipulated will the changes be reflected on the base table?
Why left join is used in sql?
what is the difference between primary key and unique key? : Sql dba
what are enums used for in mysql? : Sql dba
Does view contain data?
What is Pragma EXECPTION_INIT ? Explain the usage ?
How do I save the results of sql query in a file?
How run sql*plus commands that are stored in a local file?
display null value rows with out using null function?
Which certification is best for sql?
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)