oracle
小月月~~
喜爱运动,看推理小说
展开
-
oracle简单操作
<br />---创建表空间---<br />create tablespace sde<br />datafile 'f:/oracle/sde.ora' size 100M<br />extent management local<br />segment space management auto<br />-----创建用户---------<br />create user sde identified by sde<br />default tablespace sde <br />------原创 2010-09-13 00:33:00 · 235 阅读 · 0 评论 -
ORACLE插入多行
<br />CREATE TABLE test_table( <br />id VARCHAR2(500), <br />name VARCHAR2(500), <br />old NUMBER(38) <br />) <br />INSERT INTO test_table( <br />SELECT '01 ', 'aaa ',10 FROM DUAL UNION ALL <br />SELECT '02 ', 'bbb ',20 FROM D原创 2010-09-13 00:33:00 · 518 阅读 · 0 评论