How can you use check constraints for self referential integrity?
No Answer is Posted For this Question
Be the First to Post Answer
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
Explain can a view based on another view?
what diffrence between function and procedure?
What is a connect identifier?
How to call a stored function in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is save point in oracle database?
How to define and use table alias names in oracle?
What is the relationship among database, tablespace and data file?
What is Data Dictionary Cache in Oracle?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is the difference between 10g OEM and 11g OEM?