How to connect oracle database from unix

Answers were Sorted based on User's Feedback



How to connect oracle database from unix..

Answer / basha

Hi this is correct way to connect oracle using unix.

sqlplus username/passord@datasbename

Is This Answer Correct ?    66 Yes 9 No

How to connect oracle database from unix..

Answer / sashi

In Unix prpomt type the command
sqlplus -s username/passwd <<EOD
select * from emp;
EOD

Is This Answer Correct ?    56 Yes 14 No

How to connect oracle database from unix..

Answer / jaga

oracle need to install on unix. and database has to
configured in /oracle/network/admin/listener.ora file.
then use sqlplus dbname@sa/sa

Is This Answer Correct ?    43 Yes 13 No

How to connect oracle database from unix..

Answer / dba

The other answers will work, but would allow other users to see the passwords using ps or history.

sqlplus /nolog
@ > connect username/password@database

or

sqlplus username@database
Enter password:

Is This Answer Correct ?    13 Yes 3 No

How to connect oracle database from unix..

Answer / marigold

Set ORACLE_HOME & ORACLE_SID environment variable.
Then use sqlplus username@ORACLE_SID

Is This Answer Correct ?    0 Yes 0 No

How to connect oracle database from unix..

Answer / debendra nath panigrahi

sqlpus -s username/passwd >>eof
select * from emp;

Is This Answer Correct ?    2 Yes 7 No

Post New Answer

More Unix AllOther Interview Questions

. Using sed and grep, write a command which lists files and directories with following properties: (i) created in 1999 (ii) with user's as owner and group

0 Answers  


What is the difference between hard link & softlink?

2 Answers  


What are different types of shells?

7 Answers   BMC,


What are the processes that are not bothered by the swapper? Give Reason.

1 Answers  


HOW DO CREATE A NFS FILE SYSTEM

4 Answers   Mind Tree,






how to check GDE,EME,Java,Oracle9i Enterprise Edition Release versions Versions on unix system

1 Answers  


I am new to Unix and Unix Shell scripting could you guide me on how to go about these subjects and where to start from with concern to Oracle?. I also would like to know where does UNIX shell Scripting help in terms of development of a application in Oracle? I have no clue in the subject so do help me. Thank You Neelima

0 Answers  


in unix how to change old name to new name

5 Answers  


What is a FIFO?

2 Answers  


What is the main advantage of creating links to a file instead of copies of the file?

5 Answers   Cisco, ING,


How to setup display for a remote system?

3 Answers  


Name key files or directories on a Windows system that should always be backed up?

2 Answers  


Categories