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 put a job in background & bring it to foreground?
What steps are required to perform a bare-metal recovery?
What is the number of the masked code ee@?
2 Answers Accenture, Amazon, Amdocs,
how to raise a suncase?pls explain step by step?
Name key files or directories on a Windows system that should always be backed up?
What scripting languages do you know?
What are the files in /etc directory?
What is the difference between internal and external commands?
13 Answers BPL, DOEACC, Engro, Kuvempu University, NIIT, TCS,
How do I log into a remote Unix machine(as a root/normal user)?Please specify with command user and argument.
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
how can we create the script in crontab at mid night on sunday,satuarday,fiday 0n monyh october,november,january? please give me answer if anybody knows ? because on important purpose.
very first process created by kernell?