摘要:
INSERT INTO "TEST1"."TEST" ( "id", "name" )VALUES ( '10', (case '1' when '1' then 'yes' when '0' then 'no' end) ); 阅读全文
摘要:
1、win键+R键,输入cmd,打开命令提示符。 2、输入:sqlplus /nolog 3、输入conn /as sysdba 4、输入alter user system identified by 新密码; 阅读全文
摘要:
创建函数 CREATE OR REPLACE FUNCTION get_timestamp_cha(endtime in TIMESTAMP, starttime in TIMESTAMP) RETURN INTEGER AS str VARCHAR2(50); misecond INTEGER; 阅读全文