pl/sql
枫中畅游
程序员一枚,关注开源,架构,移动开发;
展开
-
SQL 21 天自学通学习笔记 3
1. STARTING WITH 子句 相当于like (**%); 2. order by 子句 3. group by 子句 4. having 子句 SQL> select team,avg(sickleave),avg(annualleave) from orgchart 2 group by team 3 having ...2012-06-17 22:38:33 · 131 阅读 · 0 评论 -
SQL 21 天自学通学习笔记 4
1. insert select 用法: insert into tablename1 (col1,col2) select col1,col2 from tablename2 ; 2. 删除表: drop table ovner.tablename; 3. 创建视图: CREATE VIEW <view_name> [(col...2012-08-05 11:20:27 · 115 阅读 · 0 评论 -
SQL 21 天自学通学习笔记 5
1. 用户操作: 创建: CREATE USER user IDENTIFIED {BY password | EXTERNALLY} [DEFAULT TABLESPACE tablespace] [TEMPORARY TABLESPACE tablespace] [QUOTA {integer [K|M] | UNLIMITED} ON tablespac...2012-08-05 11:38:30 · 110 阅读 · 0 评论