声明:TYPE type_name IS TABLE OF
{column_type | variable%TYPE | table.column%TYPE} [NOT NULL]
[INDEX BY BINARY_INTEGER];
identifier type_name;eg1:TYPE t_nametable IS TABLE OF VARCHAR(2)
INDEX BY BINARY_INTEGER;
引用:t_nametable(1):=’jact’
eg2:
DECLARE
TYPE dept_table_type IS TABLE OF dept%ROWTYPE
INDEX BY BINARY_INTEGER;
dept_table dept_table_type;
引用:dept_table.row1(1):=’jact’;
这是什么意思 ???我刚学pl/sql
定义: TYPE type_name IS RECORD
(field_declaration[, field_declaration]…);
identifier type_name;
这又是????
{column_type | variable%TYPE | table.column%TYPE} [NOT NULL]
[INDEX BY BINARY_INTEGER];
identifier type_name;eg1:TYPE t_nametable IS TABLE OF VARCHAR(2)
INDEX BY BINARY_INTEGER;
引用:t_nametable(1):=’jact’
eg2:
DECLARE
TYPE dept_table_type IS TABLE OF dept%ROWTYPE
INDEX BY BINARY_INTEGER;
dept_table dept_table_type;
引用:dept_table.row1(1):=’jact’;
这是什么意思 ???我刚学pl/sql
定义: TYPE type_name IS RECORD
(field_declaration[, field_declaration]…);
identifier type_name;
这又是????
(First_Name varchar2(25),
Middle_Initial char(1),
Last_name varchar2(30),
Suffix varchar2(5));这个就是你定义的一个数据类型,里面有4个单独的数据类型。
相当于struct
初始化
create type NAME_TY as object
(First_Name varchar2(25) := 'aa',
Middle_Initial char(1) := 'b',
Last_name varchar2(30) := 'cc',
Suffix varchar2(5) := 'dd');
test NAME_TY;--定义变量
变量test.First_Name='aa',test.Middle_Initial='b',test.Last_name='cc',test.Suffix='dd'