Interested to Buy Any Domain ? << Click Here >> for more details...
how do you write sql queries using shell script
for eg:- we have databae table like EMPNO,ENAME,SAL,DEPTNO
columns in EMP table how you display EMPNO,SAL FIELDS from emp
in SHELL SCRIPT please explain with an example
- 4 Answers
- 24815 Views
- I also Faced
- E-Mail Answers
Answer Posted / alpkumar
Do you mean something like this .. how do you use queries
in conjunction with shell scripts..If so, usually the
general practice which goes on is that -- write a query on
what ever database you are working with with the relevant
sql syntax.. call this query from the shell script.
For this, in our program we should start using the commands
that the database company will be providing to use in unix
environement.. So use these unix commands for connecting to
the database, calling the specific query which we had
created..,.etc ...So look out for the commands which will
be available from database provider..to use in unix/linux
flavours and accomplish your script to perform the action
automating in generating reports and mailing them (or what
ever you wanna do.. )
| Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
How to print the first array element?
What is awk in shell scripting?
What does echo $0 do?
Determine the output of the following command: name=shubham && echo ‘my name is $name’.
Explain about stdin, stdout and stderr?
What is shell scripting used for?
What is an sh file?
Explain about gui scripting?
What is shell variable?
Differentiate between ‘ and ” quotes.
What is $1 in shell scripting?
shell script for reverse the string
In my bash shell I want my prompt to be of format '$"present working directory":"hostname"> and load a file containing a list of user-defined functions as soon as I log in, how will you automate this?
What is the first line in a shell script?
What is c in shell script?
