oracle中用怎么用SQL语句插入多条数据答:很简单,在原来的基础上前面加个begin,后面加个end;这样多条语句就可以串联执行了 begin insert into 表(id,name,age) values(1,'a',18);insert into 表(id,name,age) values(1,'a',18);insert into 表(id,name,age) values(1,'a',18);insert into 表(id,name,age...
怎样给oracle视图加一个主键答:oracle是可以为视图加主键,写法:create or replace view mylist(myid,insize,outsize,statrtime,endtime,jobid,imeiid,ip,useragent UNIQUE RELY DISABLE NOVALIDATE,CONSTRAINT id_pk PRIMARY KEY (myid) RELY DISABLE NOVALIDATE) as select job.dm_session_id as myid, http.dm_request_...