Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / basanti
select * from(select rownum,ename from employee order by rownum desc) where rownum<=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to save query output to a local file?
Please explain joins in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Describe an oracle table?
What happens to indexes if you drop a table?
How to delete a column in an existing table?
What is a sub query? What are its various types?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the parameter mode that can be passed to a procedure?
How to find the duplicate rows count from employees table in oracle?
Respected sir, Please send me technical questions related to oracle apps..
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.
What is a data dictionary and how can it be created?
What is a dead lock in oracle?
Explain temporal data types in oracle
