How to connect oracle database from unix
Answers were Sorted based on User's Feedback
Answer / basha
Hi this is correct way to connect oracle using unix.
sqlplus username/passord@datasbename
| Is This Answer Correct ? | 66 Yes | 9 No |
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 |
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 |
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 |
Answer / debendra nath panigrahi
sqlpus -s username/passwd >>eof
select * from emp;
| Is This Answer Correct ? | 2 Yes | 7 No |
If Media Server fails. What are the steps to be followed? Can anyone please reply for this question Thanks, Ganesh
How to remove weird filenames?
What are the main differences between Apache 1.x and 2.x?
What is a FIFO?
what is output mkvg pvname
win 3.1 is a
What are permissions in UNIX?
Explain the read, write, and execute permissions on a UNIX directory.
In detail elaborate the system? What is driver?
How many VI editor modes do you know?
why unix command can be divided into internal and external command
What is a daemon?