1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to connect oracle in unix prompt?

Question Posted / shanmugavelu.raman

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

Explain some predefined exceptions.

0 Answers  

Why commit is not used in triggers?

0 Answers  

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

what is variable in package specification

3 Answers  




explain access control lists. : Sql dba

0 Answers  

What is a common use of group by in sql?

0 Answers  

How do I create a memory optimized filegroup?

0 Answers  

What pl/sql package consists of?

0 Answers  

What is minus?

0 Answers  

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

For more SQL PLSQL Interview Questions Click Here
Categories