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 four components of the unix file system?
List a few significant features of unix?
How would you explain a kernel to a non-technical person?
What are the features of unix operating system?
What is unix and why is it important?
What is positional parameters in unix?
List the different types of files that can be made available with unix?
What is the full form unix?
How is windows different from unix?
What is hardlink and softlink in unix?
Is unix a kernel?
How do you sort in unix?
What is the explanation for protection fault?
What are the hidden files in unix?
Is unix still around?