
Oracle
人生难得几回搏
这个作者很懒,什么都没留下…
展开
-
oracle导出导入语句
数据库备份exp ssm/ssm@emsorcl file=d:\dbbackup\%date:~11,3%.dmp log=d:\dbbackup\%date:~11,3%.log数据库导入imp ssm/ssm@emsorcl file=d:\dbbackup\backup.dmp full=y原创 2015-04-01 13:36:25 · 447 阅读 · 0 评论 -
oracle递归查询
oracle递归查询Oracle中start by prior子句用法 connect by 是结构化查询中用到的,其基本语法是: select ... from tablename start with 条件1 connect by 条件2 where 条件3; 例: select * from table start with org_id = 'HBHqfWGWPy' connect by原创 2015-05-20 16:46:39 · 989 阅读 · 0 评论