How to rebuild an index in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is primary key and foreign key when and where have to use
Explain constraining triggers.
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
How to retrieve data from an cursor to a record?
How to get a list of all tables in the database?
Which is better Oracle or MS SQL? Why?
What is an oracle recycle bin?
How to delete a user account in oracle?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
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
what is the use of rank function?