oracle基本语句

1.select 

select * from user;

2.Update

update user set name=‘zhangsan‘ where id=‘1‘;  更新名字为zhangsan

update user set name=‘lisi‘,age=‘12‘ where id=‘2‘;更新名字和年龄

（同时更新时，将各个列名用逗号分开）

3.insert into

insert into user values("1","lisi","2")

insert into user(name,age) values("lisi","12")

4.delete 

delete from user where id=2.

oracle基本语句

标签：