How Connect to a Database in Shell Programming?
Answers were Sorted based on User's Feedback
Answer / ashu
you have a "sqlplus" command to connect to database.
command is as follows:
sqlplus <db_username>/<db_password> @test.sql
| Is This Answer Correct ? | 19 Yes | 6 No |
Answer / sibin kc
You can simply use as follows.
mysql -h <hostname> -u <user name> -p<password> -e "use
psa;select * from domains where domain_name = 'hai.com';"
| Is This Answer Correct ? | 9 Yes | 6 No |
Answer / seshadri sethi
(1)1st give "sqlplus"
(2)then it will show "sqlplus" prompt
(3)give "db username"
(4)give "db password"
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / supraja
mysql -uusername -ppassword -hipaddress database -e "statement"
eg:mysql -uroot -psuppu -h192.168.0.1 supraja -e "select
count(*) from table"
| Is This Answer Correct ? | 2 Yes | 0 No |
What is shell terminal?
Is shell a part of kernel?
How do I run a script on mac?
How do I set bash as default shell mac?
Script S1 (which copies .dat files from one directory1 to another directory2) run continuously. Write Script S2 which kills S1 first, compresses all .dat files in directory1 and directory2 successfully, re-run Script S1 and stops self i.e. S2.
HOW TO CREATE 10 USERS IN UNIX(HP-UX) USING SHELL SHELL SCRIPT?
Explain about echo command?
What are the different types of commonly used shells on a typical linux system?
Explain about debugging?
c program which behaves like a shell(command interpreter). it has its own prompt say "NewShell$".any normal shell command is executed from your shell by starting a child process to execute a system program corrosponding to the command
Hi, i want to zip the files that generates automatically every few minutes (files generated are in .arc extension)....any body write a script for this... thanks in advance
If one dont know how to create a script then how he/she can use the QTP?