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 |
which is the best book for learning unix and linux?
How to list only the directories inside a directory?
what is the time for incident, problem and change management tickets?
what happens when we create a file system?
Which is the most commonly used replacement algorithm?
0 Answers Aditi Placement Service,
in unix how to change old name to new name
What is the main advantage of creating links to a file instead of copies of the file?
how can you say that unix operating system provides more security than other operating systems.
The UNIX shell is.... a).does not come with the rest of the system b).forms the interface between the user and the kernal c) does not give any scope for programming d) deos not allow calling one program from with in another e) all of the above
What is an incremental backup?
i am prepairing for 2+ yrs exp in oracle/unix production support,can u tell me which type issue comes in server plz help
In detail elaborate the system? What is driver?