摘要:
--检查约束 create table test1( id number(10) primary key, email varchar2(10) check (email like '%@%') ) drop table test1 insert into test1 values(1,'12@6.com'); select * from test1 create ... 阅读全文
摘要:
--备份表数据 select * from t_owners; --创建备份表 create table t_owners_copy ( id number, name varchar2(100), addressid number, housenumber varchar2(100), watermeter varchar2(100), adddate da... 阅读全文