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 |
what happens when we create a file system?
How do I log into a remote Unix machine(as a root/normal user)?Please specify with command user and argument.
Could you tell something about the Unix System Kernel?
how can you say that unix operating system provides more security than other operating systems.
How do you create special files like named pipes and device files?
What do you mean by nice value?
What is the number of the masked code ee@?
2 Answers Accenture, Amazon, Amdocs,
What are the events done by the Kernel after a process is being swapped out from the main memory?
How will you run the script in UNIX?
HOW DO CREATE A NFS FILE SYSTEM
what is difference between kernel and shell?
How do you log in to a remote Unix box?