without using count(*) and rownum how can we count total
record in a table
Answers were Sorted based on User's Feedback
simple..!!! Findout the primary key of the table..
then..
select count(primary_key_column) from table;
thats all; becos count vil work with non-null values.
primary key cant b null..
so.. v can use count on primary key...
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / rajesh
SQL> SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';
TABLE_NAME NUM_ROWS
------------------------------ ----------
EMP 14
Is This Answer Correct ? | 3 Yes | 0 No |
Is a rollback possible to any savepoint?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
How to load data from external tables to regular tables?
what is the difference between rollback & commit? can a foreign key has null value?
select trunc(round(156.00,-1),-1) from dual;
how to retrieve daily sal from emp table in oracle 10g
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is an Oracle sequence?
Why does oracle 9i treat an empty string as null?
How can we find the size of a database?
How to select some columns from a table in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?