Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 7271 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 raw datatype?
What do you understand by database schema and what does it hold?
What is the sql query to concatenate column values from multiple rows in oracle?
What happens if you use a wrong connect identifier?
How to call a stored function in oracle?
What is the difference between substr & instr functions?
What is null value 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.
Explain the use of consistent option in exp command.
How to open and close an explicit cursor in oracle?
What are the advantages of oracle?
How to view all columns in an existing table?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Which environment variables are absolutely critical in order to run the OUI?
What are the different types of partitions in oracle?
