yang呜呜

select userenv('language') from dual;    查看oracle字符集   alter user scott account unlock; 解锁   select username,lock_date from dba_users where username='scott';    查看锁定时间   select b.owner,b.object_

select to_char(date,'yyyy-mm-dd hh:mi:ss') from dual;   select to_date('2017-12-12 12:12:12' ,'yyyy-mm-dd hh24:mi:ss') from dual;

CREATE OR REPLACE Procedure insert_nkb (        id     in     varchar2,        name      in     varchar2,        class  in     varchar2 ) is   begin        Insert into nkb08(id, name, class)