How to open a Database using Unix Command Please Do Reply

Answers were Sorted based on User's Feedback



How to open a Database using Unix Command Please Do Reply..

Answer / shradha

sqlplus user/password@host

Is This Answer Correct ?    23 Yes 3 No

How to open a Database using Unix Command Please Do Reply..

Answer / pavithra

Answer for Mysql:

mysql -u uname -h hostname -ppwd

Is This Answer Correct ?    23 Yes 6 No

How to open a Database using Unix Command Please Do Reply..

Answer / my name

isql -Uuname -Ppswd -Ddbname -Sdbservername -c

Is This Answer Correct ?    6 Yes 0 No

How to open a Database using Unix Command Please Do Reply..

Answer / srinivas panguluri

Answer for DB2:

db2 connect to database_name user schema_name using password

For rest of the SQL queries add db2 as alias

ex: db2 select * from tablename.

Is This Answer Correct ?    5 Yes 1 No

How to open a Database using Unix Command Please Do Reply..

Answer / navneet

sqlplus/enter
username
password

Is This Answer Correct ?    4 Yes 0 No

How to open a Database using Unix Command Please Do Reply..

Answer / pradeep

in sybase
isql_r -S Servername -U username -P Password
go
//write your query

Is This Answer Correct ?    0 Yes 0 No

How to open a Database using Unix Command Please Do Reply..

Answer / arvind kumar

Sudo -U Postgres psql Database_name;
It will prompt you for password give correct password and
you can access the given database if it exist.

Is This Answer Correct ?    1 Yes 2 No

How to open a Database using Unix Command Please Do Reply..

Answer / kiruthiga

for state database replica in unix(SVM command)

metadb -i

Is This Answer Correct ?    0 Yes 1 No

How to open a Database using Unix Command Please Do Reply..

Answer / srihari

vi or editor command

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Unix Commands Interview Questions

what is the use of nice command?

4 Answers  


What does the command '$ls | wc –l > file1' do?

0 Answers  


How to create hardlinks and softlinks on files?

2 Answers  


How do you copy a directory with many files and folders into another directory?

2 Answers  


What are awk commands?

0 Answers  






Write a command that will output the sorted contents of a file named in.txt and place the output in another file named out.txt, while at the same time excluding duplicate entries.

1 Answers  


Is ‘du’ a command? If so, what is its use?

0 Answers  


What does this command do,"$more readme.txt“?

0 Answers  


Which unix command lists files/folders in alphabetical order?

0 Answers  


how to find largest file?

14 Answers   HCL, Microsoft, Thomson Reuters,


fork in unix ?

4 Answers   BFL,


How to see unused port number in Solaris?

2 Answers   HCL,


Categories