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 are the four components of the unix file system?

844


List a few significant features of unix?

981


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

893


What are the features of unix operating system?

894


What is unix and why is it important?

898


What is positional parameters in unix?

970


List the different types of files that can be made available with unix?

851


What is the full form unix?

920


How is windows different from unix?

916


What is hardlink and softlink in unix?

932


Is unix a kernel?

866


How do you sort in unix?

913


What is the explanation for protection fault?

983


What are the hidden files in unix?

1020


Is unix still around?

840