Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is unix operating system?

1013


List a few significant features of unix?

1131


Who developed unix operating system?

991


How to remove the directory in unix?

955


Name the different file types available with unix.

962


How would you display the last line of a file?

964


What are the core concepts of unix

1039


How does the kernel differentiate device files and ordinary files?

1077


What methodology can be utilized to modify the password in unix?

969


Differentiate multiuser from multitask.

1061


What is the difference between unix and windows operating system?

1025


Why is it that it is not advisable to use root as the default login?

1038


Is unix only for supercomputers?

927


What does $? Mean in unix?

1048


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

908