s_image.sql

来自「SQL 语言二次开发实际经典开发实例希望对初学者有帮助」· SQL 代码 · 共 32 行

DROP TABLE S_IMAGE;
/
CREATE TABLE S_IMAGE (
 ID             NUMBER(7) 	NOT NULL,
 FORMAT		VARCHAR2(25),
 USE_FILENAME	VARCHAR2(25),
 FILENAME	VARCHAR2(25),
 IMAGE		LONG RAW
 );
/

INSERT INTO S_IMAGE VALUES (1001,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1002,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1003,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1011,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1012,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1013,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1291,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1296,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1829,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1381,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1382,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1119,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1223,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1367,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1368,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1369,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1480,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1482,'JTIFF','Y','',NULL);
INSERT INTO S_IMAGE VALUES (1486,'JTIFF','Y','',NULL);