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 is unix operating system?
List a few significant features of unix?
Who developed unix operating system?
How to remove the directory in unix?
Name the different file types available with unix.
How would you display the last line of a file?
What are the core concepts of unix
How does the kernel differentiate device files and ordinary files?
What methodology can be utilized to modify the password in unix?
Differentiate multiuser from multitask.
What is the difference between unix and windows operating system?
Why is it that it is not advisable to use root as the default login?
Is unix only for supercomputers?
What does $? Mean in unix?
How to copy files from one directory to other in unix?