how to find count rows in table without count function?
Answer Posted / mani
Select max(rownum) from table_name;
| Is This Answer Correct ? | 35 Yes | 0 No |
Post New Answer View All Answers
What are the different types of record groups in oracle? Explain each of them
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is oracle open database communication (odbc)?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the difference between 10g OEM and 11g OEM?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Can you create a synonym without having a table?
What is connection pool in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
how to handle exceptions in post production
What is the difference between translate and replace?
How to put more than 1000 values into an oracle in clause?
What are the limitations of check constraint?
How to write date and time interval literals in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?