/*
create table plsql101_person(
name varchar2(200) not null
)
*/
/*
alter table plsql101_person add first_name varchar2(100);
*/
/*
alter table plsql101_person add last_name varchar2(100);
*/
/*
alter table plsql101_person Modify (first_name not null);
*/
/*
alter table plsql101_person add birthday date;
*/
/*
insert into plsql101_person values ('aa','test',null,'15-10 月-03');
*/
/*
delete plsql101_person;
*/
/*
insert into plsql101_person values('aa','test','10-10月-01','te')
*/
/*
delete from plsql101_person t where t.name='aa'
*/
/*
//错误,不能加*
delete * from plsql101_person t where t.name='aa'
*/
/*
create table sm_emp_check(
empid varchar2(3),
name varchar2(10),
salary number(8,2) check (salary >100 and salary <1000)
)
*/
/*
insert into sm_emp_check values('fd','fdsa',200)
*/
/*
alter table sm_emp_check disable constraint SYS_C003219
*/
/*
alter table sm_emp_check enable constraint SYS_C003219
*/
简单SQL初学者学习使用
最新推荐文章于 2024-04-30 16:39:18 发布