左思右想,觉得每天可能能学到很多新东西,或者巩固了以前的知识,但是过久了就会忘,于是决定把每天积累的知识记录下来,可以定期去REVIEW,加深印象,也能在以后看到自己逐渐成长的过程。
新知识点1:
--oracle服务器在windows域控下的问题
之前没有问题,今天连本地test bed突然出现问题。
idle-UnknownIP>conn sys/a12345 as sysdba;
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
idle-UnknownIP>conn sys/a12345@orcl as sysdba;
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
idle-UnknownIP>conn / as sysdba;
ERROR:
ORA-01041: internal error. hostdef extension doesn't exist
tnsping orcl 结果ok
修改sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) 改成 SQLNET.AUTHENTICATION_SERVICES= (NONE)后
conn sys/a12345 as sysdba;
conn sys/a12345@orcl as sysdba;
都能连上了
sys@ORCL-10.1.16.14>select * from v$version where rownum=1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
新知识点2:
今天talend里面一个job报错:
java.sql.SQLException: Fail to convert to internal representation
经查是因为数据类型不匹配所致,数据库字段类型为VARCHAR2,talend里面为BigDecimal,修改为String 解决。
今天talend里面一个job报错:
java.sql.SQLException: Fail to convert to internal representation
经查是因为数据类型不匹配所致,数据库字段类型为VARCHAR2,talend里面为BigDecimal,修改为String 解决。
巩固知识点1:
lag,lead函数
nat@ORCL-10.1.16.14>WITH t AS (SELECT LEVEL lv FROM dual CONNECT BY LEVEL<7)
lag,lead函数
2 SELECT lv lv1,LEAD(lv,1) OVER(ORDER BY lv) lv2,LEAD(lv,2) OVER(ORDER BY lv) lv3 from t;
LV1 LV2 LV3
---------- ---------- ----------
1 2 3
2 3 4
3 4 5
4 5 6
5 6
6
6 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24383181/viewspace-711870/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24383181/viewspace-711870/