摘要: > ORA-00932: inconsistent datatypes: expected - got CLOB select * from QH_VIEW_LGAREAPRODUCT where dbms_lob.instr(LGYEAR,'2015') >0 dbms_lob.instr()函数 阅读全文
posted @ 2020-07-30 16:23 star521 阅读(923) 评论(0) 推荐(0) 编辑
摘要: 1.oracle数据库linux服务器下登陆使用 su - oracle sqlplus / as sysdbaconnect yonghuming/mima as sysdba 1. oracle 查询所有的schemeselect username from dba_users; 2. orac 阅读全文
posted @ 2020-07-30 16:02 star521 阅读(1104) 评论(0) 推荐(0) 编辑