unix command how to dispaly no of records in oracle?
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 |
What are unix options?
How to get the last word from a line in Unix file?
What are the requirements for a swapper to work?
Differentiate between absolute and related path?
What are the phases of swapping a page from the memory?
Explain what are the unix system calls for i/o?
How can you edit a large file without opening it in unix?
How to know the present working directory in unix?
What was unix originally written for?
Which is the shell of unix?
Explain the method of changing file access permission?
What are the various ids in unix processes?