50分求一 Oracle SQL 语句 或 函数 先用变量将SQ_Staff.currval取出存下来再插入不行吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select :"SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM SCOTT.EMP"insert:"INSERT INTO SCOTT.EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES(:EMPNO, :ENAME, :JOB, :MGR, :HIREDATE, :SAL, :COMM, :DEPTNO)"delete:"DELETE FROM SCOTT.EMP WHERE (EMPNO = :EMPNO )"create table:CREATE TABLE "SCOTT"."EMP" ("EMPNO" NUMBER(4) NOT NULL, "ENAME" VARCHAR2(10 byte), "JOB" VARCHAR2(9 byte), "MGR" NUMBER(4), "HIREDATE" DATE, "SAL" NUMBER(7, 2), "COMM" NUMBER(7, 2), "DEPTNO" NUMBER(2), CONSTRAINT "FK_DEPTNO" FOREIGN KEY("DEPTNO") REFERENCES "SCOTT"."DEPT"("DEPTNO"), CONSTRAINT "PK_EMP" PRIMARY KEY("EMPNO") USING INDEX TABLESPACE "SYSTEM" STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) PCTFREE 10 INITRANS 2 MAXTRANS 255) TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) LOGGING 先取SQ_Staff.nextval再insert,很容易解决的啊. 记得看过SQ_Staff.nextval 并一定合适 取得数值可能不是你要的如果有人修改了序列的生成Oracle可以设置自增的 asp.net怎么防止按钮连续点击? 求sql 将时间相差一天的两条记录组成一条记录 查找xml中的节点数据,并填充dataset 在Vs2005中如何添加CDO引用 请教:用户控件和自定义控件的定义及区别? 奇特的页面跳转小问题 求一个SQL语句,短路了~~ 一个关于datagrid的问题 <form runat=server>设置了action,但是为什么还是提交到自身 终于出来了,在此谢谢大家的帮助!源码公开,要的来拿! 请指点一个sql语句!急用! 如何在一个页面中定义另一个页面中的控件属性???
"SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM SCOTT.EMP"
insert:
"INSERT INTO SCOTT.EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES(:EMPNO, :ENAME, :JOB, :MGR, :HIREDATE, :SAL, :COMM, :DEPTNO)"
delete:
"DELETE FROM SCOTT.EMP WHERE (EMPNO = :EMPNO )"create table:
CREATE TABLE "SCOTT"."EMP" ("EMPNO" NUMBER(4) NOT NULL, "ENAME"
VARCHAR2(10 byte), "JOB" VARCHAR2(9 byte), "MGR" NUMBER(4),
"HIREDATE" DATE, "SAL" NUMBER(7, 2), "COMM" NUMBER(7, 2),
"DEPTNO" NUMBER(2),
CONSTRAINT "FK_DEPTNO" FOREIGN KEY("DEPTNO")
REFERENCES "SCOTT"."DEPT"("DEPTNO"),
CONSTRAINT "PK_EMP" PRIMARY KEY("EMPNO")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING