DBA笔记
ORACLE达成Select TOP 效果 Seletct * from temp where ROWNUM &g...
扫描右侧二维码阅读全文
11
2008/04

DBA笔记

ORACLE达成Select TOP 效果
Seletct * from temp where ROWNUM > 10 Order By ROWNUM

修改序列的增加幅度
ALTER SEQUENCE [user.]sequence_name
[INCREMENT BY n] (n可以为负数)

SQLLDR用法
--使用分隔符和引用符来分割各个字段,此用法比较适合包含多字段数据的CSV文件
Load data
infile 'data.txt'
badfile 'mytemp.bad'
Append into Table mytemp
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(字段1,字段2,字段3...)

字符串转换成日期
to_date(selltime,'yyyy-mm-dd')

Last modification:November 26th, 2018 at 04:16 pm
If you think my article is useful to you, please feel free to appreciate

Leave a Comment