no_data_found

1 no_data_found

2trunc（d,m)

  trunc(12.192,1)=12.1

3 insert into table_a (id,name) value('111','jack');

   insert into table-a(id,name) select b-id,b-name from table-b; 

4  select  case aTest when 'a' then '1'  when 'b' then '2' from tbl;

  (用在赋值）

5 type

 

   type Typ-a is record

( id urowid,

 name varchar2(10)

 usrpwd table.pwd%type

)

(建行）

 

type Typ_result is array(100) of Typ-a;

（建表）

 

type typ_fln is table of tablea.fln%type index by binary_integer;

 

 

6rowtype

 

v_record oritble%rowtype

v_record 与oritble表中字段相对应