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 |
how you know the ip address of user system?
How do you sort in unix?
What is called in unix?
How to get the nth word of a line in Unix?
What are links and symbolic links in UNIX file system?
Is used to create ordinary files on any unix system?
What do you mean by unix operating system?
What are the three main components of unix architecture?
Which are typical system directories below the root directory?
What are data structures that are used for Demand Paging?
Which unix shell is best?
Name two paging states for a page in memory?