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

Name the different file types available with unix.

518


What unix is mac os based on?

499


What are the essential features of the unix operating system?

523


Describe the term inode?

613


What is Process id in unix?

548






How would you identify daemons in unix?

534


Is a directory unix?

464


What is the full meaning of unix?

480


How to remove the first line/header from a file in Unix?

545


Describe the responsibilities of shell in brief.

479


Differentiate multiuser from multitask.

572


Is it possible to see information about a process while it is being executed?

756


Discuss the mount and unmount system calls ?

531


Is the Process before and after the swap are the same? Give reason.

718


How to change the password in unix operating system?

485