Oracle数据表与查询

conn system/orcl as sysdba

create tablespace ts1 datafile 'd:\ts8_1.dbf' size 10M;

create user u3 identdified by wy default tablespace ts1;

grant dba to u3;

conn u3/wy

创建表

create table student(id char(5),name varchar(10),address varchar2(50));

插入数据

insert into student values('1','lisi','山西太原迎泽大街256号');

复制表

create table t1 as select * from student;

修改表结构

alter table student add telephone char(15);

查看表结构

desc student;