Interested to Buy Any Domain ? << Click Here >> for more details...
With out using count() function. How to the find total
number of rows in a table?
- 6 Answers
- 13133 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramachandran
select rownum from tablename;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is schema in sql example?
What are the three pl sql block types?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is a parameter query?
Is sql free?
What are sql*plus environment variables?
Enlist the characteristics of pl/sql?
Can I join the same table twice?
does sql support programming? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is a sql schema used for?
what is bcp? When is it used?
Is full outer join same as cross join?
What do you mean by query optimization?
What is the difference between cross join and natural join?
