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

Does inner join remove duplicates?

0 Answers  

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

How does postgresql compare to "nosql"?

0 Answers  

What is sql and also describe types of sql statements?

0 Answers  




When are we going to use truncate and delete?

0 Answers  

What is a pragma statement?

0 Answers  

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

Why do we need unique key in a table?

0 Answers  

Is mariadb a nosql database?

0 Answers  

Why do we need view in sql?

0 Answers  

What is exception? What are the types of exceptions?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories