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 |
why unix command can be divided into internal and external command
How to put a job in background & bring it to foreground?
What is the difference between grep & find?
hi.when will u come to klnce 4 campus interviews??/
How to find the version details of unix? if any application is installed in unix OS how to find the version of that application is it possilbe or not? pls let me know cmd in detail.
what is difference between kernel and shell?
. 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
What is a Map?
What UNIX command will control the default file permissions when files are created?
How to setup display for a remote system?
How does the inode map to data block of a file?
HOW DO CREATE A NFS FILE SYSTEM