1、ut.put_line(v_list(5); END; 1-22 PL/SQL表和可变数组的区别 VARRAY集合中的元素的数量是有限的，Index_by则 是没有限制的。 Index_by表的下标可以有间隔， VARRAY集合的下标 之间没有间隔。 Index_by表不能存储在数据库中，但嵌套表和 VARRAY可以被存储在数据库中。 Index_by表初始化是自动进行的，VARRAY就必须使 用内建的构造函数，构造函数和集合的名字相同 。 1-23 表和数组属性 属性返回类型描述有效范围 Exists(n)boolean指定索引为n的元素在集合中是 否存在 表、可变数组 countnumbe
2、r返回集合中元素的数目表、可变数组 limitnumber返回集合中最大元素数可变数组 First strings strings_table; int number; BEGIN int := 1; strings(int) := element1; if strings.exists(int) then dbms_output.put_line(strings(int); else dbms_output.put_line(no data!); return; end if; 1-25 表和数组属性 例： strings(2) := element2; strings(3) := elem
3、ent3; strings(4) := element4; strings(5) := element5; strings(6) := element6; dbms_output.put_line(strings.count); dbms_output.put_line(strings.first); dbms_output.put_line(strings.last); dbms_output.put_line(strings.next(2); dbms_output.put_line(strings.prior(4); strings.delete(1,3); -dbms_output.p
4、ut_line(strings(2); END; 1-26 PL/SQL运算符和表达式 关系运算符 运算符 意义 = 等于 , != , = , = 不等于 大于 =大于等于 1-27 PL/SQL运算符和表达式 一般运算符 运算符 意义 +加号 -减号 *乘号 /除号 :=赋值号 | 连接符 .范围运算符 1-28 PL/SQL运算符和表达式 逻辑运算符 运算符 意义 IS NULL 空值 BETWEEN AND介于两者之间 IN 在一个值列表之中 AND逻辑与 OR逻辑或 NOT取返,如 IS NOT NULL, NOT IN 1-29 PL/SQL中的变量赋值 在PL/SQL编程中，变量
5、赋值是一个值得注意的地方，它的语法如下： variable := expression ; variable 是一个PL/SQL变量, expression 是一个PL/SQL 表达式. BOOLEAN 型变量赋值： 布尔值只有TRUE, FALSE及 NULL 三个值。 空值加数字仍是空值：NULL + = NULL 。 空值加（连接）字符，结果为字符：NULL | = 1-30 PL/SQL中的变量赋值 例：DECLARE done BOOLEAN; /* the following statements are legal: */ BEGIN done := FALSE; WHILE N
6、OT done LOOP Null; END LOOP; END; 1-31 PL/SQL中的变量作用范围及可见性 PL/SQL的变量作用范围特点是： 变量的作用范围是在所引用的程序单元（块、子程序、包）内。即从声 明变量开始到该块的结束 一个变量（标识）只能在所引用的块内是可见的 当一个变量超出了作用范围，PL/SQL引擎就释放用来存放该变量的空间 （因为它可能不用了） 在子块中重新定义该变量后，它的作用仅在该块内 1-32 PL/SQL中的变量作用范围及可见性 例： DECLARE v_Number NUMBER(3 , 2); BEGIN DECLARE v_Character VARC
7、HAR2(10); BEGIN END; END; v_Number的作用域 v_Character的作用域 1-33 PL/SQL中的注释 在PL/SQL里，可以使用两种符号来写注释： PL/SQL允许用双来写注释，它的作用范围是只能在一行有效。 例： V_Sal NUMBER(12,2); - 工资变量 使用 /* */ 来加一行或多行注释。 例： /*/ /* 文件名： department_salary.sql */ /*/ 1-34 PL/SQL简介 例：简单数据查询例子 DECLARE emp_id emp.empno%TYPE :=7788; emp_name emp.ename
8、%TYPE; wages emp.sal%TYPE; BEGIN SELECT ename, NVL(sal,0) + NVL(comm,0) INTO emp_name, wages FROM emp WHERE empno = emp_id; DBMS_OUTPUT.PUT_LINE(emp_name|-|to_char(wages); END; 1-35 PL/SQL简介 例：简单数据插入例子 /* 本例子仅是一个简单的插入，不是实际应用。 */ DECLARE v_ename VARCHAR2(20) := Bill; v_sal NUMBER(7,2) :=1234.56; v_de
9、ptno NUMBER(2) := 10; v_empno NUMBER(4) := 8888; BEGIN INSERT INTO emp ( empno, ename, JOB, sal, deptno , hiredate ) VALUES ( v_empno, v_ename, Manager, v_sal, v_deptno, TO_DATE(1954.06.09,yyyy.mm.dd) ); COMMIT; END; 1-36 PL/SQL简介 例：简单数据删除例子 /* 本例子仅是一个简单的删除例子，不是实际应用。 */ DECLARE v_empno number(4) :=
10、8888; BEGIN DELETE FROM emp WHERE empno=v_empno; COMMIT; END; PROPRIETARY LEGEND: THIS IS CONFIDENTIAL AND PROPRIETARY INFORMATION OF TELEDYNE CONTROLS AND MAY NOT BE USED OR DISCLOSED BY THE RECIPIENT WITHOUT THE PRIOR WRITTEN CONSENT OF TELEDYNE CONTROLS AND THEN ONLY IN ACCORDANCE WITH SPECIFIC W
11、RITTEN INSTRUCTIONS OF TELEDYNE CONTROLS. BY RECEIPT HEREOF, IN ADDITION TO ANY OBLIGATION THE RECIPIENT HAS UNDER ANY CONFIDENTIALITY AGREEMENT WITH TELEDYNE CONTROLS, NEITHER RECIPIENT NOR ITS AGENTS, REPRESENTATIVES OR EMPLOYEES WILL COPY, REPRODUCE OR DISTRIBUTE THIS INFORMATION, IN WHOLE OR IN
12、PART, AT ANY TIME, WITHOUT THE PRIOR WRITTEN CONSENT OF TELEDYNE CONTROLS AND THAT IT WILL KEEP CONFIDENTIAL ALL INFORMATION CONTAINED HEREIN. PMAT Zhenzhou Yuan November 2017 Use shall be in accordance with the Title page of this presentation. 11/27/2017 2 PMAT 2000 Portable Maintenance Access Term
13、inal 2000 Aka P2K OS Windows 2000/XP/Win 7 Data Loader PDL615 DATALOADING 615A LOADSTAR Loadable Software Airplane Parts (LSAP) Management Operation Mode Standalone Network via LSE (LoadStar Server Enterprise) Introduction Use shall be in accordance with the Title page of this presentation. 11/27/20
14、17 3 PMAT 2000 Applications MSD LoadStar 615 Loader615A LoaderFloppy Removable Media Local Folder Use shall be in accordance with the Title page of this presentation. 11/27/2017 4 ARINC 615 Loader Refer to as “Low speed loading” Via ARINC 429 bus To CDLC Connector in the cockpit To connector at the
15、back of MDDU, patch cable available ARINC 615A Loader Refer to as “High speed loading” Via Ethernet bus To CDLC Connector in the cockpit (FMGC only) To connector in the E/E Bay PMAT 2000 Loaders Use shall be in accordance with the Title page of this presentation. 11/27/2017 5 Top Cover Panel PMAT 20
16、00 operates from 115VAC-250VAC, 50Hz-400Hz, via the AC power cable P/N: 80044-4 or Internal Batteries (2 fully charged batteries= 5 hrs of operation) PMAT 2000 Hardware 80000-05 Use shall be in accordance with the Title page of this presentation. 11/27/2017 6 PMAT 2000 Main Menu Use shall be in acco
17、rdance with the Title page of this presentation. 11/27/2017 7 PMAT 2000 Configuration Use shall be in accordance with the Title page of this presentation. 11/27/2017 8 Archived Data Access activity logs in Archived Data. Each session of ARINC 615 dataloader, 615A Dataloader and MCDP is recorded and
18、logged with date/time stamp. Sessions can be viewed, deleted or transferred to removable media. Any downloaded data from a session can be accessed from Archived Data. Use shall be in accordance with the Title page of this presentation. 11/27/2017 9 Log Files Logs and Download files can be viewed on
19、the PMAT 2000, deleted or transferred off the PMAT 2000. Download files and logs are linked. On the download file maintenance page you will see both the files and the corresponding log file. LoadStar Use shall be in accordance with the Title page of this presentation. 11/27/2017 11 LoadStar default
20、display Use shall be in accordance with the Title page of this presentation. 11/27/2017 12 LoadStar - Admin Use shall be in accordance with the Title page of this presentation. 11/27/2017 13 LoadStar Admin - Models Use shall be in accordance with the Title page of this presentation. 11/27/2017 14 Lo
21、adStar Admin - Tails Use shall be in accordance with the Title page of this presentation. 11/27/2017 15 LoadStar Admin - LRU For Ver 33 and before, “665/DLUR” was “777 System” “Regular” for 615 s/w, “665/DLUR” with ID “0” for 615A s/w Use shall be in accordance with the Title page of this presentati
22、on. 11/27/2017 16 LoadStar Ver 34 and on Install Software Use shall be in accordance with the Title page of this presentation. 11/27/2017 17 LoadStar Pre Ver 34 - Install Software Use shall be in accordance with the Title page of this presentation. 11/27/2017 18 LoadStar Install Software Use shall b
23、e in accordance with the Title page of this presentation. 11/27/2017 19 LoadStar Install Software If the LSP does not contain definition for the Part Number, Folder Name will be used by default: Use shall be in accordance with the Title page of this presentation. 11/27/2017 20 LoadStar Install Softw
24、are Use shall be in accordance with the Title page of this presentation. 11/27/2017 21 LoadStar Install Software Use shall be in accordance with the Title page of this presentation. 11/27/2017 22 LoadStar Install Software Use shall be in accordance with the Title page of this presentation. 11/27/201
25、7 23 LoadStar Install Software - NewLoads Use shall be in accordance with the Title page of this presentation. 11/27/2017 24 LoadStar Install Software Confirm PN again, LSP PN can be changed here: Use shall be in accordance with the Title page of this presentation. 11/27/2017 25 LoadStar Install Sof
26、tware Use shall be in accordance with the Title page of this presentation. 11/27/2017 26 LoadStar Install Software Use shall be in accordance with the Title page of this presentation. 11/27/2017 27 Software can be on Floppy, CD or USB Drive LoadStar can import multiple software parts at a time Scann
27、ing CD or USB Drive will take a long time, if there are many files on them Good practice to copy the s/w part onto an empty USB Drive At the root directory of the USB drive, create a folder and name it the software part number Create sub folders for each of the floppies, name them Disk001, Disk002 I
28、f LoadStar does not find the software part number in the files, then by default will take the folder name as the software part number. LoadStar Install Software Use shall be in accordance with the Title page of this presentation. 11/27/2017 28 LoadStar Library Management Use shall be in accordance w
29、ith the Title page of this presentation. 11/27/2017 29 LoadStar Locate Load Use shall be in accordance with the Title page of this presentation. 11/27/2017 30 LoadStar Delete Load Use shall be in accordance with the Title page of this presentation. 11/27/2017 31 LoadStar Verify Library Use shall be
30、in accordance with the Title page of this presentation. 11/27/2017 32 LoadStar Backup Library Use shall be in accordance with the Title page of this presentation. 11/27/2017 33 LoadStar Restore Library Use shall be in accordance with the Title page of this presentation. 11/27/2017 34 LoadStar Run Re
31、ports 615 Data Loading Use shall be in accordance with the Title page of this presentation. 11/27/2017 36 PDL615 Data loading From MSD Select the PDL615 Dataloading button from the Main Menu. Select the PMAT 2000 Mass Storage option. Select Next to display the next screen. Use shall be in accordance
32、 with the Title page of this presentation. 11/27/2017 37 PDL615 Data loading From MSD Use shall be in accordance with the Title page of this presentation. 11/27/2017 38 PDL615 Data loading From MSD Use shall be in accordance with the Title page of this presentation. 11/27/2017 39 PDL615 Data loading
33、 From MSD 615A Data Loading Use shall be in accordance with the Title page of this presentation. 11/27/2017 41 615A Data Loading Use shall be in accordance with the Title page of this presentation. 11/27/2017 42 615A Data Loading Use shall be in accordance with the Title page of this presentation. 1
34、1/27/2017 43 615A Data Loading Use shall be in accordance with the Title page of this presentation. 11/27/2017 44 615A Data Loading No Targets Found Check Connection Type or Cable Use shall be in accordance with the Title page of this presentation. 11/27/2017 45 615A Data Loading Use shall be in acc
35、ordance with the Title page of this presentation. 11/27/2017 46 Network Interface Card (NIC) There are 2 NICs one use the RJ45 connector the other one use the 53 pin connector On Control Panel, 3 adapters can be seen For 615 Loading When PDL615 starts, all NICs are disabled When PDL615 quits, all NICs are enabled again For 615A Loading When 615A loader st
