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 |
how to face veritas NetBAckup interview, where did i find all materials regrding veritas and give details on veritas certification
13 Answers 3i Infotech, ABC, Accenture, ACS, CTS, Genpact, GSK, HP, IBM, Lapiz, Lapiz Digital, Satyam, Symantec, TCS, Veritas,
The very first process created by the kernal that runs till the kernal process is haltes is
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 is default permissions for others in a file?
How would you change all occurrences of a value using VI?
what is the time for incident, problem and change management tickets?
What is the difference between internal and external commands?
13 Answers BPL, DOEACC, Engro, Kuvempu University, NIIT, TCS,
What is an incremental backup?
How to set Windows as Default OS when Dual Booting Ubuntu?
I am trying to unmount a remote file system,but I do not unmount that file system.How can i know the user name (i.e.,user who is using that file system).....write the command with argument
What is a Map?
What are the main differences between Apache 1.x and 2.x?