Answer / basha

Hi this is correct way to connect oracle using unix.

sqlplus username/passord@datasbename

Answer / sashi

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

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

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:

Answer / marigold

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

Answer / debendra nath panigrahi

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

Have you used VI editor?

1 Answers   BMC,

How will you run the script in UNIX?

5 Answers   BMC,

What is file system in UNIX?

6 Answers   BMC,

HOW DO CREATE A NFS FILE SYSTEM

4 Answers   Mind Tree,

What are each of the standard files and what are they normally associated with?

1 Answers   ITCO,

From command line how will you add a user account?

2 Answers  

What is major difference between the Historic Unix and the new BSD release of Unix System V in terms of Memory Management?

1 Answers  

How can u doing testing in Unix environment ?

2 Answers   TCS,

If Media Server fails. What are the steps to be followed? Can anyone please reply for this question Thanks, Ganesh

0 Answers   HCL, IBM,

What does iostat do?

4 Answers   IBM,

What is an incremental backup?

2 Answers  

How to connect oracle database from unix

6 Answers   Cap Gemini, IBM, Wirecard,