unix command how to dispaly no of records in oracle?

Categories >> Software >> Operating Systems >> Unix >> Unix General
Suggest New Category

Question Posted / dinesh

5 Answers
10474 Views
SDF, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

unix command how to dispaly no of records in oracle?..

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

unix command how to dispaly no of records in oracle?..

Answer / guest

use sqlplus command

Is This Answer Correct ?

1 Yes

0 No

unix command how to dispaly no of records in oracle?..

Answer / guest

use sqlplus command

Is This Answer Correct ?

1 Yes

0 No

unix command how to dispaly no of records in oracle?..

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

unix command how to dispaly no of records in oracle?..

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

Post New Answer