unix command how to dispaly no of records in oracle?

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

More Unix General Interview Questions

Explain what is inode?

0 Answers  


How to find a file in unix?

0 Answers  


What is output of the following?

1 Answers   ABC,


How to log out in unix?

0 Answers  


How to display n-th line of a file in Unix?

0 Answers  






Interviewer: Lets say there is a partition of 100GB. When i tried to create a file using touch command, under any directory, it was unable to create the file- '100% full disk space'. I calculated the size of each and every directory on that partition mannually by adding each file size & in came out to be total size 50GB. Then where is the remaining 50GB ? why it is showing disk space 100% full in 'df -h' command?

2 Answers   Infosys,


What are the criteria for choosing a process for swapping out of the memory to the swap device?

0 Answers  


What are system variables in unix?

0 Answers  


What are unix options?

0 Answers  


How can you edit a large file without opening it in unix?

0 Answers  


What are links and symbolic links in UNIX file system?

0 Answers  


What is $# in unix?

0 Answers  


Categories