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
- 24615 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 do you find out What is your shell?
What is meant by $1 in shell script?
Is shell scripting useful?
Explain about stdin, stdout and stderr?
How do I open the shell in cmd?
How to pass an argument to a script?
What is an sh file?
What are the various stages of a linux process it passes through?
What is bash shell command?
What lives in a shell?
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
How do I start a shell script?
What language is bash?
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 does the sh command do?
