oracle数据库基本语句有哪些

create database databasename

drop database dbname

exp demo/demo@orcl buffer=1024 file=d：back.dmp full=y

exp demo/demo@orcl file=d:backup1.dmp owner=(system,sys)

exp demo/demo@orcl file=d:backup2.dmp tables=(teachers,students)

exp demo/demo@orcl file=d：back.dmp tables=（table1） query=" where filed1 like 'fg%'"

imp demo/demo@orcl file=d:back.dmp full=y ignore=y log=D:implog.txt

imp demo/demo@orcl file=d:backup2.dmp tables=(teachers,students)

create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)

select * into table_new from table_old (使用旧表创建新表)

create table tab_new as select col1,col2… from tab_old definition only<仅适用于Oracle>

drop table tabname

alter table tablename rename to newtablename

alter table tablename add (ID int);

alter table tablename add (ID varchar2(30) default '空' not null);

alter table tablename modify (ID number(4));

alter table tablename rename column ID to newID;

alter table tablename drop column ID;

alter table tabname add primary key(col)

alter table tabname drop primary key(col)

create [unique] index idxname on tabname(col….)

drop index idxname

create view viewname as select statement

drop view viewname

select <列名> from <表名> [where <查询条件表达试>] [order by <排序的列名>[asc或desc]]

insert into 表名 values(所有列的值);
insert into test values(1,'zhangsan',20);

insert into 表名(列) values(对应的值);
insert into test(id,name) values(2,'lisi');

update 表 set 列=新的值 [where 条件] -->更新满足条件的记录
update test set name='zhangsan2' where name='zhangsan'

update 表 set 列=新的值 -->更新所有的数据
update test set age =20;

delete from 表名 where 条件 -->删除满足条件的记录
delete from test where id = 1;

truncate table 表名

drop table 表名

insert into table1 (select * from table2);

create table table1 select * from table2 where 1>1;

create table table1 select * from table2;

create table table1 as select id, name from table2 where 1>1;