2013年4月27日
Book-<Apress.Expert.Oracle.Database.Architecture.2nd.Edition.2010>
摘要： 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 阅读全文
posted @ 2013-04-27 23:39 ArcerZhang 阅读(190) 评论(0) 推荐(0)
PL/SQL高级-Creating Packages (01)
摘要： 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 阅读全文
posted @ 2013-04-27 18:14 ArcerZhang 阅读(497) 评论(0) 推荐(0)
PL/SQL高级-Creating Packages (00)
摘要： 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 阅读全文
posted @ 2013-04-27 11:53 ArcerZhang 阅读(146) 评论(0) 推荐(0)
PL/SQL高级-Overview
摘要： 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 阅读全文
posted @ 2013-04-27 10:46 ArcerZhang 阅读(406) 评论(0) 推荐(0)