Interested to Buy Any Domain ? << Click Here >> for more details...
unix command how to dispaly no of records in oracle?
- 5 Answers
- 10615 Views
- SDF, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sandip01
If you want to know how to find all the oracle records
having .ora extension then the ans is...
find / -name "*.ora" - print
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / babi
>wc -l filename
Example:cat>file
1 abc 100
2 def 200
3 ghi 300
4 ijk 500
>wc -l file
4 file
| Is This Answer Correct ? | 2 Yes | 10 No |
Does apple run unix?
What are the criteria for choosing a process for swapping into memory from the swap device?
What are conditions for a machine to support Demand Paging?
Is unix cli or gui?
What is a unix file?
What is unix in simple terms?
Suppose you have a scheduling chain where the process 1 is a predecessor of the process 2 and both of them are scheduled every Monday at 8.00pm. Will I find execution log of process 1 every Tuesday morning? And what about the other one? Why?
How to calculate the number of words in a file?
What does ls lrt in unix?
What does tr H do in unix?
Is it possible to create new a file system in UNIX?
Difference between the fork() and vfork() system call?
Unix Commands 
