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 we Update a table with out using UPDATE command?
In Oracle 10g, "g" Stands for what?
if i am using dml statement in function. then i am writing select statement what was the output
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is an oracle database table?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What is an Integrity Constrains ?
what is index?
Explain the family trees and connection by clause
How to run queries on external tables?
How many types of cluster table in Oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.