create table picdd (ddid INTEGER not null,pid integer not null,name VARCHAR2(50) not null,constraint PK_picdd primary key (pid))
DROP TABLE picdd
create index table_1_fk on table (id ASC)
alter table pictest(表名) add piccc(字段名) varchar(50) default 0(默认值为0) not null(不能为空)
在oracle中not null需要放在default中
alter table pictest(表名) drop column piccc(字段名)
CREATE SEQUENCE pic_Sequence
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;
CREATE TRIGGER pic BEFORE
insert ON pic FOR EACH ROW
begin
select pic_Sequence.nextval into:New.picid from dual;
end;
select * from table where id='1';
uodate table set name='赵永恩' where id='2';
insert into table(id,name) values('2','赵永恩吗');
delete from table where id='1';
create OR replace view v_qikan_2011(title,msg) AS SELECT qikan.title , qikan.msg from qikan