sqlplus username/userpassword@oracle<<eof >select * from emp; &g

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

Question Posted / nitesh bhope

4 Answers
24607 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

Please Help Members By Posting Answers For Below Questions

What language is bash?

844

What is shell chemistry?

919

write a shell script to check the failed jobs?

4349

What is subshell?

869

What is a file basename?

993

What is the default ubuntu terminal?

1050

What are the disadvantages of shell scripting?

1115

What is the fastest scripting language?

936

What is inside a seashell?

1066

How to get the 3rd element/column from each line from a file?

1140

What does it mean to debug a script?

990

What is a beat in a script?

977

What are the advantages of shell script?

963

What is awk script?

914

Is it possible to substitute "ls" command in the place of "echo" command?

998