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 |
what is the order of pre-defined exceptions.
What is using in sql?
what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 Answers Fiserv, Herbinger, Synechron,
What do you understand by pl/sql packages?
Does mysql support pl sql?
How can I make sql query run faster?
which will fire first ? Trigger or Constraint
24 Answers i2, IBM,
What is server name sql?
How to use sql statements in pl/sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the purpose of using pl/sql?
How do I count rows in sql query?
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)