Describe the different type of Integrity Constraints
supported by ORACLE ?

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


Please Help Members By Posting Answers For Below Questions

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1732


What is a package in oracle?

560


what are bitmap indexes? How does they work?

1709


Explain integrity constraint?

636


What does sharding mean?

529






What the is the diff between local index and global index. give some example.

1124


How to delete all rows a table in oracle?

617


What are oracle functions?

541


How to invoke the original export import utilities?

497


How to shutdown your 10g xe server?

607


What is an oracle database?

604


How to connect to oracle using service name instead of sid?

544


What is proxy method?

534


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?

1449


What is columnar storage what is the advantage?

536