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

Describe the term directory?

1449


Differentiate swapping and paging.

895


What is positional parameters in unix?

1054


Write a shell script that requests the user's age and then echoes it, along with some suitable comment.

1432


What is unix buffer cache?

993


Explain system bootup in unix.

977


Discuss the mount and unmount system calls ?

1069


What is file structure in unix?

931


How zip the file in unix?

1032


i m putting 2.6yrs fake exp in oracle/unix production support i want to know some real time issues,like tell me the challenging issue u ever faced? my project is credit card application plz help me!

13381


Explain file system in unix.

990


Explain a path in unix.

963


What is unix kernel explain it?

946


What is unix directory structure?

942


What is the use of unix?

997