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
- 24019 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitesh bhope
sqlplus username/userpassword@oracle<<eof
>select * from emp;
>select empno,ename,sal,deptno;
........what ever commands u wanna execute of sql u can
write here
>hit ctrl+d
these are called as here documents
| Is This Answer Correct ? | 11 Yes | 10 No |
Post New Answer View All Answers
What is the use of "$#" in shell scripting?
What is a boot block?
What is the difference between scripting and coding?
What are the different types of shell scripting?
What is bash command used for?
Please give me example of " at command , contrab command " how to use
Explain about login shell?
What is the first line in a shell script?
How do you find out What is your shell?
What is awk in shell scripting?
Determine the output of the following command: [ -z “” ] && echo 0 || echo 1
What is awk script?
Write a script to print the first 10 elements of fibonacci series.
Can shell script run on windows?
How do we delete all blank lines in a file?
