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
- 24788 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 redirect both standard output and standard error to the same location?
What are different types of shell?
Explain about sourcing commands?
What can scripts do?
How to open a read-only file in the shell?
What makes c shell a more preferable option than the bourne shell?
How will you print the login names of all users on a system?
What is difference between bash and shell?
Write a script to print the first 10 elements of fibonacci series.
How do I run a powershell script?
What are the advantages of shell script?
Explain about gui scripting?
Can we run shell script in windows?
How can the contents of a file inside jar be read without extracting in a shell script?
How to print all the arguments provided to the script?
