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 commands simpler rather than complex task
what is mean by kernal?
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
interprocess command in unix be achieved by a)pipes b)messages c)semaphores d)shared memory e)all
How to set Windows as Default OS when Dual Booting Ubuntu?
What is a daemon?
which is the best book for learning unix and linux?
HOW DO CREATE A NFS FILE SYSTEM
What does iostat do?
i am prepairing for 2+ yrs exp in oracle/unix production support,can u tell me which type issue comes in server plz help
what happens when we create a file system?
differentiate between named & unnamed pipe.
11 Answers Cisco, IIT, ISEC,