How to retrieve first and last records from a table?
Answer Posted / reddy
select*from emp where rowid in (select min(rowid),max(rowid) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do database buffers contain?
What are the common oracle dba tasks?
What is oracle analytical function?
How to resolve the ORA-39133 error in Oracle?
What are the database administrators utilities available?
What is different types of joins?
Explain oracle’s server parameter file.
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 call a sub procedure?
Why oracle is used?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is a connect identifier?
How many types of auditing in Oracle?
How to execute the package in oracle?
What is the disadvantage of User defind function?