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 |
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How to add Foreign key in a table after the creation of the table?
Can a trigger call a stored procedure?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is plpgsql language?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Could you please provide oca (oracle 10g) dumps for my certification ?
How to create an array in pl/sql?
IF i write before / after insert / update trigger and i do rollback what will happen?
How do you break a loop in pl sql?
Can you have multiple SPs with the same name on a database?
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)