Interested to Buy Any Domain ? << Click Here >> for more details...
without using count(*) and rownum how can we count total
record in a table
- 5 Answers
- 10166 Views
- AC, HP, I also Faced
- E-Mail Answers
Answer Posted / sanrai
Select max(rownum) From dual
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
11. Display the client number and name and the client number and name of the person who referred that client.
What is java oracle used for?
How to start instance with a minimal initialization parameter file?
What is a trace file and how is it created in oracle?
Why packages are used in oracle?
How will you identify oracle database software release?
Can we protect our pl/sql source code?
What is oracle data type?
What is Java Pool in Oracle?
What is a user account in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to use windows user to connect to the server?
How can I introduce multiple conditions in like operator?
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
What are a collation and state the different types of collation sensitivity?
