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 |
Explain about Inodes?
If Media Server fails. What are the steps to be followed? Can anyone please reply for this question Thanks, Ganesh
What is default permissions for others in a file?
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
What is the number of the masked code ee@?
2 Answers Accenture, Amazon, Amdocs,
what is difference between milestone and run-levels in Solaris ?
What is the difference between internal and external commands?
13 Answers BPL, DOEACC, Engro, Kuvempu University, NIIT, TCS,
what is the time for incident, problem and change management tickets?
. 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
Is this the command to connect oracle from unix? sqlplus -s username/password. Then what is the -S here...????
differentiate between named & unnamed pipe.
11 Answers Cisco, IIT, ISEC,
What are the main differences between Apache 1.x and 2.x?