fanyuanwaifdl的专栏

create tablespace mytestdatafile 'E:\oracle\product\10.2.0\oradata\orcl\client_whrd.dbf' size 200m autoextend on next 10m maxsize unlimiteddrop tablespace mytestINCLUDING CONTENTS AND DATAFI

索引失效时：logid为索引名称alter index logid rebuild Nologging

alter system set global_names=false scope=both

instrinstr(lie,'asdf') //在列lie中找asdf出现的位置默认为从1开始且第一次出现的位置 如：instr(lie,'asdf',1,1)substrsubstr(lie,2,12) //在列lie中从第二个字段开始找12位instr 和substr中的 开始位置包含decodedecode(lie,'','',lie||'asdf')

#oracle version database settingsjdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcljdbc.username=testjdbc.password=testhibernate.dialect=org.hibernate.

----------------------------------------------------------------------------------------------------------------------------rem windows环境下Oracle数据库的自动备份脚本。rem 可以将本批处理设成windows任务计划下自动执行。@echo

-- 删除重复数据里面前面保存的重复数据 /*+parallel*/ 优化速度delete /*+parallel*/  table1  awhere rowid not in(select max(rowid) from table1 b  where a.id=b.id  and a.col=b.col )--查询非数值类型的数据(数值类型的包括全角数字)１２３４５1234

drop PROCEDURE if EXISTS fanyuanwaifdl;create PROCEDURE fanyuanwaifdl(in rootid VARCHAR(50),in innerccode VARCHAR(50))begin -- 开始存储过程declare root_id varchar(50); -- 自定义变量1declare inner_code va

UPDATE (SELECT @rownum:=@rownum+3 as rn,id,order_ from (SELECT id,col1,col2,order_ from table where 1=1ORDER BY col asc) h, (SELECT @rownum:=0) t)t1,table t2 set t2.col1=t1.col1 wh...