unix command how to dispaly no of records in oracle?
- 5 Answers
- 9457 Views
- SDF, TCS, I also Faced
- E-Mail Answers
Answer Posted / david
hey guys ..you are not getting the question .what the actual
question is ......
you have to display the no of records from the oracle table
by unix command ....
and the answer is ...
vi script.sh
sqlplus sys/123 as sysdba << abc
spool on
spool file_name
select * from scott.emp;
spool off
abc
exit
a=cat file_name|wc -l
echo this is ur $a no. of records in oracle's emp records...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the main features of korn shell?
How to print/display the last line of a file in Unix?
What do you understand by the term filters?
Which language unix is written?
Which language is used in unix?
How to create files in unix?
What do you understand by unix shell?
What is ps1 and ps2 in unix?
What does the swapping system do if it identifies the illegal page for swapping?
What are the components of unix kernel?
How to check logs in unix?
What is unix kernel?
How do you determine and set the path in unix?
Why is it that it is not advisable to use root as the default login?
How to find out what processes are running in the background in unix?
