2017年01月_engchina

12月 09月 08月 06月 04月 02月 01月

翻译 PLSQL Package 2

CREATE OR REPLACE PACKAGE PAC1IS -- PROCAプロシージャの仕様の宣言 PROCEDURE PROCA ( PA IN NUMBER);END;/CREATE OR REPLACE PACKAGE BODY PAC1IS -- 変数 V1の宣言 V1 NUMBER; -- PROCBプロシージャの完全な定義 PROCEDURE PROCB ( PB IN NUM

2017-01-27 10:59:59 326

翻译 PLSQL Package

CREATE PACKAGE PAC1IS PROCEDURE PROC1 ( P1 IN VARCHAR2);END;/CREATE PACKAGE BODY PAC1IS PROCEDURE PROC1 ( P1 IN VARCHAR2) ISBEGIN DBMS_OUTPUT.PUT_LINE(P1);END;END;SET SERVERO

2017-01-27 10:55:42 642

翻译 PLSQL Function

CREATE OR REPLACE FUNCTION FUNC_順序番号 --←キーワードはFUNCTION ( P_発番単位 IN VARCHAR2) --←仮パラメータのモードは INだけ RETURN NUMBER --←RETURNするデータ型を宣言するIS V_発番済番号順序.番号%TYPE; V_番号 NUMBER;BEGIN -- 指

2017-01-26 16:57:37 1299

翻译 PLSQL Procudure 实例2

CREATE TABLE 順序 ( 発番単位 VARCHAR2(20) PRIMARY KEY, 番号 NUMBER );/INSERT INTO 順序 VALUES ('注文ID',2 );INSERT INTO 順序 VALUES ('顧客ID',100 );COMMIT;SELECT * FROM 順序;CREATE OR REPLACE PROCEDURE

2017-01-26 16:50:45 928

翻译 PLSQL Procedure 实例1

CREATE TABLE 在庫 ( 製品名 VARCHAR2(20) PRIMARY KEY, 在庫数 NUMBER );CREATE TABLE 注文 ( 注文ID NUMBER PRIMARY KEY, 製品名 VARCHAR2(20), 注文数 NUMBER );CREATE SEQUENCE SEQ_注文ID;INSERT INTO 在庫 VALUES ('テレ

2017-01-26 16:36:45 910 2

翻译 PLSQL Procedure

CREATE OR REPLACE PROCEDURE proc_tax( p1 IN NUMBER, p2 OUT NUMBER)ISBEGIN p2 := p1*1.17;END;/SET serveroutput ONDECLARE v_input NUMBER(5); v_output NUMBER(5);BEGIN v_input :=1

2017-01-26 15:10:16 544

翻译 PLSQL Collection Check Existence

SET serveroutput ONSET verify OFFDECLAREtype a_typeIS TABLE OF VARCHAR2(10) INDEX BY binary_integer; a a_type;BEGIN a(5) := 'five'; a(-3) := 'minus 3'; a(0) := 'zero'; a(7) := 'sev

2017-01-26 15:06:06 420

翻译 PLSQL Collection Sort

SET serveroutput ONSET verify OFFDECLAREtype a_typeIS TABLE OF VARCHAR2(10) INDEX BY binary_integer; a a_type; I binary_integer :=1;BEGIN a(5) := 'five'; a(-3) := 'minus 3'; a(0) :=

2017-01-26 15:01:11 579

翻译 PLSQL Collection

SET serveroutput ONSET verify OFFDECLAREtype a_typeIS TABLE OF VARCHAR2(10) INDEX BY binary_integer; a a_type;BEGIN a(10) := 'ABC'; a(20) := 'DEF'; a(30) := 'GHI'; dbms_output.put_lin

2017-01-26 14:49:50 687

翻译 PLSQL Cursor ROWTYPE TYPE

SET serveroutput ONSET verify OFFDECLARE rec2 emp%rowtype;BEGIN SELECT * INTO rec2 FROM EMP WHERE employee_id = 100; dbms_output.put_line(REC2.employee_id || ' ' || REC2.first_name );END;/

2017-01-26 14:23:09 876

翻译 PLSQL Cursor For Loop handle header and detail

SET serveroutput ONSET verify OFFBEGIN FOR rec1 IN (SELECT * FROM DEPT ) LOOP DBMS_OUTPUT.PUT_LINE(CHR(10) || '### 部門名 : ' || REC1.department_name || ' ####'); -- CHR(10)换行 FOR rec2

2017-01-26 14:14:33 322

翻译 PLSQL Cursor For Loop

定义CursorSET serveroutput ONSET verify OFFDECLARE CURSOR cur_emp IS SELECT employee_id, upper(first_name) upname, salary*12 annsal FROM emp WHERE department_id = &

2017-01-26 14:07:59 934

翻译 PLSQL 明示Cursor 2

SET serveroutput ONSET verify OFFDECLARE CURSOR cur_emp IS SELECT employee_id, upper(first_name) upname, salary*12 annsal FROM emp WHERE department_id = &deptno;

2017-01-26 13:59:16 362

翻译 PLSQL 明示Cursor

SET serveroutput ONSET verify OFFDECLARE CURSOR cur_emp IS SELECT employee_id, first_name FROM emp WHERE department_id = &deptno; rec cur_emp%rowtype;BEGIN OPEN cur_

2017-01-26 13:54:08 334

翻译 PLSQL 异常处理

SET serveroutput ONSET verify ONDECLARE v_empno emp.employee_id%type := &emp_no; v_ename emp.first_name%type; v_deptno dept.department_id%type; v_dname dept.department_name%type;BEGIN SEL

2017-01-26 13:46:51 477

原创 spring framework release site

http://repo.spring.io/release/org/springframework/spring/

2017-01-24 23:53:24 339

原创 thinkpad p50 install nvidia driver

add to the end of file /etc/modprobe.d/blacklist.conf blacklist nouveauoptions nouveau modeset=0ctrl +alt + f1,service lightdm stopinit 3modprobe -r nouveauapt purge *nouve

2017-01-24 23:15:11 1452

原创 Linux Web Server Apache Install

Apache Install$ sudo apt update$ sudo apt install apache2Apache Start$ sudo systemctl start apache2Apache Stop$ sudo systemctl stop apache2

2017-01-17 14:50:40 280

原创 Linux 查找两个文件的不同

admin1.log1 2 31 2 21 3 4admin2.log1 2 31 3 21 3 4grep -Fxvf admin1.log admin2.log1 3 2

2017-01-10 10:55:46 1724

原创 oracle 创建用户和赋予权限

CREATE USER usernameIDENTIFIED BY passwordDEFAULT TABLESPACE USERSTEMPORARY TABLESPACE TEMPPROFILE DEFAULTQUOTA UNLIMITED ON USERS/GRANT ALTER SESSION TO username/GRANT CREATE PR

2017-01-04 10:09:30 450

Introduction to Kubernetes

Overview --- Is your team beginning to use Kubernetes for container orchestration? Do you need guidelines on how to start transforming your organization with Kubernetes and cloud native patterns? Would you like to simplify software container orchestration and find a way to grow your use of Kubernetes without adding infrastructure complexity? Then this is the course for you! Outline --- Welcome & Introduction Container Orchestration Kubernetes Kubernetes Architecture – Overview Installing Kubernetes Setting Up a Single Node Kubernetes Cluster with Minikube Accessing Minikube Kubernetes Building Blocks Authentication, Authorization, Admission Control Services Deploying a Stand-Alone Application Kubernetes Volume Management Deploying a Multi-Tier Application ConfigMaps and Secrets Ingress Advanced Topics – Overview Kubernetes Community

2019-01-12

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

engchina的专栏