كل كلمات امتحان الـ IELTS اللى هتحتاجها
12 years ago
This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.
I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.
DECLARE
emp EMPLOYEE_TYP;
emp_ref REF EMPLOYEE_TYP;
BEGIN
SELECT Ref(e)
INTO emp_ref
FROM employee_tab e
WHERE e.employee_id = 370;
UPDATE employee_tab e
SET e.address = Address_typ('8701 College','Oakland','CA','94321')
WHERE Ref(e) = emp_ref;
END;
/
Updating Rows in an Object Table With a REF Modifier
Hany Freedom is a fan of |
0 comments:
Post a Comment