Managing Data and Concurrency

- Copyright © 2005, Oracle.
- 8-2 Copyright © 2005, Oracle.
- Identify and administer PL/SQL objects.
- 8-3 Copyright © 2005, Oracle.
- UPDATE employees SET SALARY=6000 2 WHERE EMPLOYEE_ID = 9999;.
- 2 WHERE EMPLOYEE_ID = 9999;.
- SQL PL/SQL Locks.
- 8-4 Copyright © 2005, Oracle.
- 8-5 Copyright © 2005, Oracle.
- 8-6 Copyright © 2005, Oracle.
- 8-7 Copyright © 2005, Oracle.
- 8-8 Copyright © 2005, Oracle.
- 8-9 Copyright © 2005, Oracle.
- 8-10 Copyright © 2005, Oracle.
- PL/SQL.
- Oracle’s Procedural Language extension to SQL.
- PL/SQL Locks.
- 8-11 Copyright © 2005, Oracle.
- 8-12 Copyright © 2005, Oracle.
- Administering PL/SQL Objects.
- Identify problem PL/SQL objects.
- Recommend the appropriate use of PL/SQL.
- Load PL/SQL objects into the database.
- Assist PL/SQL developers in troubleshooting.
- 8-13 Copyright © 2005, Oracle.
- PL/SQL Objects.
- There are many types of PL/SQL database objects:.
- 8-14 Copyright © 2005, Oracle.
- 8-15 Copyright © 2005, Oracle.
- 8-16 Copyright © 2005, Oracle.
- 8-17 Copyright © 2005, Oracle.
- 8-18 Copyright © 2005, Oracle.
- The Oracle database comes with over 350 built-in PL/SQL packages, which provide:.
- 8-19 Copyright © 2005, Oracle.
- 8-20 Copyright © 2005, Oracle.
- 8-21 Copyright © 2005, Oracle.
- 2 SET salary=salary*1.1 3 WHERE employee_id=100;.
- 2 SET salary=salary+100 3 WHERE employee_id=100;.
- SQL PL/SQL.
- 8-22 Copyright © 2005, Oracle.
- 2 SET salary=salary*1.1 3 WHERE employee_id=101;.
- 8-23 Copyright © 2005, Oracle.
- Transaction 1 UPDATE hr.employees SET salary=salary+100 WHERE employee_id=100;.
- Transaction 2 UPDATE hr.employees SET salary=salary+100 WHERE employee_id=101;.
- Transaction 3 UPDATE hr.employees SET salary=salary+100 WHERE employee_id=102;.
- Transaction x UPDATE hr.employees SET salary=salary+100 WHERE employee_id=xxx;.
- 8-24 Copyright © 2005, Oracle.
- 8-25 Copyright © 2005, Oracle.
- 2 SET salary=salary*1.1 3 WHERE employee_id= 106;.
- 2 SET salary=salary*1.1 3 WHERE employee_id= 107;.
- 8-26 Copyright © 2005, Oracle.
- 8-27 Copyright © 2005, Oracle.
- UPDATE employees SET salary=salary+100 WHERE employee_id=100;.
- 9:00:00 UPDATE employees SET salary=salary+100 WHERE employee_id=101;.
- UPDATE employees SET COMMISION_PCT=2 WHERE employee_id=101;.
- 8-28 Copyright © 2005, Oracle.
- 8-29 Copyright © 2005, Oracle.
- 8-30 Copyright © 2005, Oracle.
- 8-31 Copyright © 2005, Oracle.
- 8-32 Copyright © 2005, Oracle.
- SET salary = salary x 1.1 WHERE employee_id = 1000;.
- SET salary = salary x 1.1 WHERE employee_id = 2000;.
- WHERE employee_id = 2000;.
- WHERE employee_id = 1000;.
- 8-33 Copyright © 2005, Oracle.
- 8-34 Copyright © 2005, Oracle

Xem thử không khả dụng, vui lòng xem tại trang nguồn
hoặc xem Tóm tắt