常用sql语句(未完待续...)

对scott用户解锁
alter user scott account unlock

怎么样查看oracle版本
select banner from sys.v_$version

取固定条数
select * from organization where rownum<4 order by datetime (oracle) [rownum 关键字]