liutonglai的专栏

<br />create or replace procedure TestJiaoJi<br />  is<br />   type nt_table_type is table of number;<br />   nt1 nt_table_type:=nt_table_type(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);<br />   nt2 nt_table_type:=nt_table_type(0,0,0,0,0,

<br />create or replace procedure Pro_LabSelect(p_stno_in varchar2,p_labplanid_in integer,p_itemno_in varchar2,p_batchno_in varchar2,p_result_out out integer)<br />is<br /> -- v_nowtime varchar2(20); --时间<br />  v_term varchar2(10);<br />  v_courseid varch

获取表名： Oracle的user_talbes用于记录了用户表信息。select * from user_tables 获取某个表的字段：USER_TAB_COLS中记录了用户表的列信息。下面是别人写的：SELECT USER_TAB_COLS.TABLE_NAME as 表名,USER_TAB_COLS.COLUMN_NAME