how to find count rows in table without count function?
- 3 Answers
- 6189 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 load data through external tables?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to select an oracle system id (sid)?
What is rowid and rownum in oracle?
How do I escape a reserved word in oracle?
How to connect to oracle using service name instead of sid?
How would you go about verifying the network name that the local_listener is currently using?
How to recover a dropped table in oracle?
How to create a new table in your schema?
Query to retrieve record for a many to many relationship ?
Can we commit inside a function in oracle?
What is a cursor variable?
What are the different types of synonyms?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
if you ctreate table identity
