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


Please Help Members By Posting Answers For Below Questions

Is unix cli or gui?

486


What is grep|sort give example?

531


How would you explain a kernel to a non-technical person?

545


What is unix mtime?

509


What is unix inode?

501






What is utility unix?

544


Enlist common shells with their indicators.

557


What are the main features of korn shell?

525


How to list directories in unix?

559


Is unix a programming language?

508


What is the difference between a single dot and double dot in unix?

722


How to move files from one directory to other in unix?

491


What was unix originally written for?

542


Is darwin unix?

511


How unix is used?

486