How would you change old and new values in an insert, delete and update triggers?
No Answer is Posted For this Question
Be the First to Post Answer
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
find the second highest salary of the emp table
what are stored procedures?
How to pass a cursor variable to a procedure?
How to rename a tablespace in oracle?
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 the use of record option in exp command.
What is an Oracle index?
What are the different pseudo commands? Explain in general?
What are the common oracle dba tasks?
How to synchronize 2 schema's objects?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?