Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 8241 Views
- I also Faced
- E-Mail Answers
Answer Posted / prna
SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle?
How to select some rows from a table in oracle?
List the parts of a database trigger.
What is oracle rownum?
Explain a private synonyms?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What are temporal data types 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.
Can a formula column be obtained through a select statement ?
Explain what are synonyms used for?
What is merge in oracle?
How do I connect to oracle?
Query to retrieve record for a many to many relationship ?
What is not equal to in oracle?
