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 |
. 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 the difference between hard link & softlink?
What are different types of shells?
What are the processes that are not bothered by the swapper? Give Reason.
HOW DO CREATE A NFS FILE SYSTEM
how to check GDE,EME,Java,Oracle9i Enterprise Edition Release versions Versions on unix system
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
in unix how to change old name to new name
What is a FIFO?
What is the main advantage of creating links to a file instead of copies of the file?
How to setup display for a remote system?
Name key files or directories on a Windows system that should always be backed up?