how to connect oracle in unix prompt?

Answers were Sorted based on User's Feedback



how to connect oracle in unix prompt?..

Answer / omkar pattajoshi

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

how to connect oracle in unix prompt?..

Answer / sushant

$sqlplus
$scott/tiger

Is This Answer Correct ?    5 Yes 0 No

how to connect oracle in unix prompt?..

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

how to connect oracle in unix prompt?..

Answer / mannu

You have to set the following:

ORACLE_HOME
ORACLE_SID
PATH

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

Can one improve the performance of sql*loader? : aql loader

0 Answers  


What is an index in sql with example?

0 Answers  


How to start the command-line sql*plus?

0 Answers  


Types of cursors and explanation each of them ?

4 Answers   DELL,


What does partition by mean in sql?

0 Answers  






explain advantages of myisam over innodb? : Sql dba

0 Answers  


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  


What are the two parts of design view?

0 Answers  


What is mutating error in pl sql?

0 Answers  


Why triggers are used?

0 Answers  


What does 0 mean in sql?

0 Answers  


Can we call dml statement in function?

0 Answers  


Categories