10 2014 档案

多表插入
摘要：insert allwhen sum_orders = 1000 and sum_orders <1000 theninto mediums_customerselseinto large_customersselect customer_id,sum(order_total) sum_orders... 阅读全文

posted @ 2014-10-30 10:58 kenwong 阅读(304) 评论(0) 推荐(0)

oracle常用命令
摘要：--登录：sys/ken@orcl as sysdba1、建立表空间、授予权限/*分为四步 *//*第1步：创建临时表空间 */create temporary tablespace user_temp tempfile 'D:\oracle\oradata\Oracle9i\user_temp... 阅读全文

posted @ 2014-10-20 17:19 kenwong 阅读(142) 评论(0) 推荐(0)

导航