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

How does unix operating system works?

948


How to check the date in unix?

1003


How many types of files are there in unix?

970


What does a pipe(|) do?

893


What is unix structure?

942


Is unix an operating system?

869


What is unix computer?

977


Is unix a language?

861


What is source unix?

894


What is the core of unix operating system?

912


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

988


Explain pid.

939


What are the main features of unix?

1490


If we are terminated at the middle of the program execution in UNIX,what will happen to the program, it will continue running r terminate r the o/p will be send to your mail?

1411


How do I run a unix script?

926