INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('111','住户生活水'); INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('112','工业生活水');
or
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('111','住户生活水')
/
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('112','工业生活水')
/
or
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('111','住户生活水')
/
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('112','工业生活水')
/
CREATE TABLE "POWER"
("POWER_NO" CHAR(8 BYTE) NOT NULL,
"POWER_NAME" VARCHAR2(40 BYTE),
CONSTRAINT "KEY_POWER" PRIMARY KEY("POWER_NO"))
/ CREATE TABLE "GROUPALLOW"
( "GROUPALLOW_ID" NUMBER(12) NOT NULL,
"ALLOW_BROWSE" NUMBER(1),
"ALLOW_MODIFY" NUMBER(1),
"ALLOW_PRINT" NUMBER(1),
"ALLOW_SETUP" NUMBER(1),
CONSTRAINT PK_GROUPALLOW PRIMARY KEY ("GROUPALLOW_ID"))
/INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('111','住户生活水')
/
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('112','工业生活水')
/
SQL PLUS我用不习灌,以前是用MS SQL SERVER 的!
有的话直接执行即可
CREATE TABLE "POWER"
("POWER_NO" CHAR(8 ) NOT NULL,
"POWER_NAME" VARCHAR2(40 ),
CONSTRAINT "KEY_POWER" PRIMARY KEY("POWER_NO"));
CREATE TABLE "GROUPALLOW"
( "GROUPALLOW_ID" NUMBER(12) NOT NULL,
"ALLOW_BROWSE" NUMBER(1),
"ALLOW_MODIFY" NUMBER(1),
"ALLOW_PRINT" NUMBER(1),
"ALLOW_SETUP" NUMBER(1),
CONSTRAINT PK_GROUPALLOW PRIMARY KEY ("GROUPALLOW_ID"));
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('111','住户生活水');
INSERT INTO "POWER" ("POWER_NO" ,"POWER_NAME" ) VALUES ('112','工业生活水');commit;
你可以再sqlplus里执行一下就知道了
PL/SQL怎么搞的??
KAO!
谢谢大家了!