摘要：
Settting Up Your EnviromentSetting up the SCOTT/TIGER SchemaExecuting the ScriptCreating the Schema without the ScriptSetting Your EnvironmentSetting up Autotrace in SQL*PlusInitial Setupcd [ORACLE_HOME]/rdbms/adminlog into SQL*Plus as SYSTEMrun @utlxplanrun CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN 阅读全文
摘要：
Compoments of a PL/SQL PackagePackage Specification是必须要有的，Package body是可以没有的（bodyless）；但是如果你在package specification中声明了cursor，subprogram等，那么就必须要有package body,来实现上面的cursor、subprogram声明.Internal and External Visibility of a Package`s ComponentsDeveloping PL/SQL Packages:OverviewCreating the Package Spe 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to do the followingDescribe packages and list their componentsCreate a package to group together related variables,cursors,constants,exceptions,procedures,and fuctions.Designate a package construct as either public or privateInvoke a package 阅读全文
摘要：
Course ObjectivesAfter completing this course,you should be able to do the following:Create,execute,and maintain-Package constructs-Database triggersManage PL/SQL subprograms and triggersUse a subset of Oracle-supplied packages to generate screen and file outputIdentify various techniques that impac 阅读全文