oracl 和db2 常用语法比较: 1、取前N条记录 Oracle:Select * from TableName where rownum <= N; DB2:Select * from TableName fetch first N rows only; 2、取得系统日期 Oracle:Select sysdate from dual; DB2:Select current timestamp from sysibm.sysdummy1; 3、空值转换 Oracle:Select
创建数据库:
> use userinfo
数据库删除:
db.dropDatabase()
> show dbs # 显示当前系统中的所有数据库
> use userinfo # 转到userinfo数据库
switched to db userinfo
> db.dropDatabase()
{dropped:userinfo,ok:1}
> show dbs
创建集合:
语法:db.createCollection(name,options)