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 |
How can I introduce multiple conditions in like operator?
Explain the difference between sql and oracle?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
What are the types of trigger in oracle?
How do you bind variables in oracle?
7. Repeat query (7) but also display all clients who have never ordered anything.
if you ctreate table identity
How do we switch from init.ora file to asp file?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
How to change user password in oracle?
How to delete a user account in oracle?