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
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How a tablespace is related to data files?
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 set a transaction to be read only in oracle?
What are the differences between char and varchar2 in oracle?
How to define an anonymous procedure without variables?
How to create a single index for multiple columns?
What are the oracle built-in data types?
What are the uses of Database Trigger ?
What are the general rules on data consistency?
What is columnar storage what is the advantage?
Explain the use of indexes option in imp command.
What is the data type of dual table?
What is meant by joins? List out the types of joins.
How does oracle handle read consistency?