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 |
What are different types of shells?
Is this the command to connect oracle from unix? sqlplus -s username/password. Then what is the -S here...????
How do you list the files in an UNIX directory while also showing hidden files?
What is a Map?
What is a Region?
How to setup display for a remote system?
How will you run the script in UNIX?
what is the time for incident, problem and change management tickets?
interprocess command in unix be achieved by a)pipes b)messages c)semaphores d)shared memory e)all
Am using Mac OS 10.4.11 on an Imac (PPC) Internal hard disk got named disk0s3 and will not mount. What commands can be used in TERMINAL to rename the internal hard disk to C96?
What are the events done by the Kernel after a process is being swapped out from the main memory?
What is default permissions for others in a file?