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
Is unix cli or gui?
What is grep|sort give example?
How would you explain a kernel to a non-technical person?
What is unix mtime?
What is unix inode?
What is utility unix?
Enlist common shells with their indicators.
What are the main features of korn shell?
How to list directories in unix?
Is unix a programming language?
What is the difference between a single dot and double dot in unix?
How to move files from one directory to other in unix?
What was unix originally written for?
Is darwin unix?
How unix is used?