ArcerZhang`s Technology Blog

摘要： 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 阅读全文

摘要： 1、不与Linux交互，直接添加用户密码View Code [root@DG1 shell]# useradd user01[root@DG1 shell]# echo 123456 | /usr/bin/passwd --stdin user01更改用户 user01 的密码 。passwd： 所有的身份验证令牌已经成功更新。2、批量添加、删除用户脚本批量添加#!bin/sh# Author:ArcerZhang <E-mail:arcerzhang@163.com># The script to add user# /etc/passwd infoecho "plea 阅读全文

摘要： 方法一、使用命令ntpdate time-a.nist.gov方法二、本地安装ntpdate客户端在本地安装ntpdate客户端，更新时用ntpdate cn.pool.ntp.org如果你的机子不支持域名，则可以用 ping cn.pool.ntp.org 得到该域名的IP地址。然后用 ntpda... 阅读全文

摘要： 课程大纲Shell编程语法Shell编程调试Shell编程实例 阅读全文

摘要： Autonomous TransactionsAutonomous Transaction(AT)，通过PRAGMA AUTONOMOUS_TRANSACTION;指明当前的事务操作只针对自身有效，不涉及到其他事务.Trapping User-Defined ExceptionsExamples:User-Defined ExceptionDECLARE v_deptno NUMBER := 500; v_name VARCHAR2(20) := 'Testing'; e_invalid_department EXCEPTION;BEGIN ... 阅读全文

摘要： Exception TypesPredefined Oracle Server --Implicitly raisedNon-predefined Oracle Server --Implicitly raisedUser-defined --Explicitly raisedSyntax to Trap ExceptionsSyntaxEXCEPTION WHEN exception1 [OR exception2...] THEN statement1; statemen... 阅读全文

摘要： ObjectivesAfter completing this lesson,you should be able to do the following:Define PL/SQL execeptionsRecognize unhandled exceptionsList and use different types of PL/SQL execption handlersTrap unanticipated errors.Describe the effect of exception propagation in nested blocksCustomize PL/SQL except 阅读全文

摘要： AgendaAfter completing this training,you should be able to do the following:How to install OpenSSQLThe basic of encryption/decryptionIntroduction of SSLHow to configure Apache with SSL.Configuration of CA on server side and client side.SSL attack and common implementaion mistakes.Lab EnvironmentInst 阅读全文

摘要： FOR Loops RulesReference the counter only within the loop;it is undefined outside the loop.Do not reference the counter as the target of an assignment.Neither loop bound should be NULL.Use the REVERSE keyword to force the loop to decrement from the upper bound to the lower bound.You must still make 阅读全文

摘要： Logic TablesBuild a simple Boolean condition with a comparision operator.ANDTRUEFALSENULLTRUETRUEFALSENULLFALSEFALSEFALSEFALSENULLNULLFALSENULL ORTRUEFALSENULLTRUETRUETRUETRUEFALSETRUEFALSENULLNULLTRUENULLNULLNOTTRUEFALSEFALSETRUENULLNULLBoolean Expression or Logincal ExpressionWhat is the valu... 阅读全文