unix command how to dispaly no of records in oracle?
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 core concepts of unix
How do you go to a directory in unix?
What is unix operating system explain various components of unix operating system?
What is difference between find and grep in unix?
What are the components of unix kernel?
What is the ‘nohup’ in unix?
What is unix file?
Why is unix better than windows?
Explain about the directory representation in UNIX?
What does ls lrt in unix?
How do I show hidden files in unix?
Why is it that it is not advisable to use root as the default login?
How to stop an infinite loop in unix?
Is mac unix like?
What is disk block allocation in unix?