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 |
Explain how and when a DNS request is solved when a user tries to surf to the site www.abcdeg.in .Assume the user machine uses a local name server and sits on another network other than www.abcdef.in.
Enlist common shells with their indicators.
What is alias mechanism?
What is called in unix?
Why was unix invented?
How to calculate the number of words in a file?
Discuss briefly about the directory representation in unix.
Is unix written in c?
What is meant by the term nohup?
What are the hidden files in unix?
Explain different types of Unix systems.
What are internal and external commands in unix?