TAILIEUCHUNG - Oracle Built−in Packages- P5

Oracle Built−in Packages- P5: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk externally. The DBMS_APPLICATION_INFO package lets an application register itself in a way that can be monitored at runtime through the V SESSION and V SQLAREA virtual tables. Chapter 8 Managing Large Objects With Oracle8 Oracle finally offers native robust support for large objects. Oracle LOBs can be stored in a column in a table or as an attribute of an object type. The database supports objects of up to four gigabytes of data including character text graphic images video or raw data. The DBMS_LOB package provides procedures and functions to access and manipulate LOBs within PL SQL programs. Chapter 9 Datatype Packages This chapter introduces you to several packages that specialize in working with specific types of Oracle data. The DBMS_ROWID package allows you to work with the two different ROWID formats available in Oracle8 extended new to Oracle8 and restricted traditional Oracle7 ROWIDs . The UTL_RAW package offers a set of functions allowing you to perform concatenation substring bit-wise logical analysis byte translation and length operations on RAW data. The UTL_REF package new in Oracle8 Release provides a PL SQL interface to select and modify objects instances of an object type in an object table without having to specify or know about the underlying database table. Chapter 10 Miscellaneous Packages You can t find a neat category for eveything can you This chapter collects together a variety of useful packages you are sure to dip into on a regular basis. DBMS_UTILITY is the actual miscellaneous package. It offers programs to free unused user memory parse comma-delimited lists calculate the elapsed time of PL SQL programs and much more. You never know what you ll find popping up next in DBMS_UTILITY DBMS_DESCRIBE contains a single procedure DESCRIBE_PROCEDURE which you can use to get information about the parameters of a stored program. DBMS_DDL contains programs to recompile stored code analyze objects in .

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản