unix command how to dispaly no of records in oracle?
- 5 Answers
- 9112 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 |
how to use grep command to list find the records of a file containg 10 different strings
What are my options if I want to turn on security with a non-root server ID in a UNIX® environment?
Is unix written in c?
How do I run a unix script?
What is unix structure?
How to null a file in unix?
What are the different versions of unix?
How do we change file access permissions?
What are the advantages of unix operating system?
What does unix like mean?
Define a single-user system.
How do I find the port number of pid in unix?
Unix Commands 
