how to find count rows in table without count function?
- 3 Answers
- 5665 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / anil kumar
select sum(1) from table_name;
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to create a new table in oracle?
How will you identify oracle database software release?
What are ddl statements in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to retrieve data from an explicit cursor?
What is a subquery in oracle?
How to assign data of the deleted row to variables?
What is the difference between truncate & delete command?
How to rename a column in an existing table?
How to create a table interactively?
How translate command is different from replace?
What is blob datatype?
Explain the use of record option in exp command.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How remove data files before opening a database?
