how to connect oracle in unix prompt?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scope and visibility in PL/SQL?

602


How to add a column ‘salary’ to a table employee_details?

593


How exception handling is done in advance pl/sql?

501


What is plpgsql language?

534


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

513






Can there be 2 primary keys in a table?

559


How do I run a sql trace?

522


What is a constraint?

567


what are all the common sql function? : Sql dba

587


What are the datatypes available in pl/sql ?

614


What does inner join mean?

558


Is hadoop a nosql?

577


What is pls_integer in pl sql?

541


Why does sql need a server?

564


Does sql between include endpoints?

554