predata.sql

来自「delphi通过OCI访问ORACLE」· SQL 代码 · 共 35 行

CREATE TABLE TEST(F1 VARCHAR2(10), F2 NUMBER(9, 4), 
    F3 VARCHAR2(200), F4 FLOAT(126), F5 FLOAT(126), F6 FLOAT(
    63));

INSERT INTO TEST(F1, F2, F3, F4, F5, F6) 
  VALUES('kkkkkkkkkk', 77777.7878, 'one', 12121212121212121212,0,0.0000000000000000006);
INSERT INTO TEST(F1, F2, F3, F4, F5, F6) 
  VALUES('qqqqqqqqqq', 77777.7878, 'two', 12121212121212121212,1,0.0000000000000000006);
INSERT INTO TEST(F1, F2, F3, F4, F5, F6) 
  VALUES('cccccccccc', 77777.7878, 'three', 12121212121212121212,2,0.0000000000000000006);
INSERT INTO TEST(F1, F2, F3, F4, F5, F6) 
  VALUES('gggggggggg', 77777.7878, 'four', 12121212121212121212,3,0.0000000000000000006);
INSERT INTO TEST(F1, F2, F3, F4, F5, F6) 
  VALUES('iiiiiiiiii', 77777.7878, 'five', 12121212121212121212,4,0.0000000000000000006);


CREATE TABLE TESTFLOAT (F1 NUMBER(1) NOT NULL, F2 
    NUMBER(2) NOT NULL, F3 NUMBER(3) NOT NULL, F4 NUMBER(4) NOT 
    NULL, F5 NUMBER(5) NOT NULL, F6 NUMBER(6) NOT NULL, F7 
    NUMBER(7) NOT NULL, F8 NUMBER(8) NOT NULL, F9 NUMBER(9) NOT 
    NULL, F10 NUMBER(10) NOT NULL, F11 NUMBER(11) NOT NULL, 
    F12 NUMBER(12) NOT NULL, F20 NUMBER(20) NOT NULL, FN 
    NUMBER(38) NOT NULL);                    `


CREATE TABLE TEST2(F1 CHAR(2000) NOT NULL, F2 
    VARCHAR2(4000) NOT NULL, F3 NCHAR(2000) NOT NULL, F4 
    NVARCHAR2(4000) NOT NULL, F5 NUMBER(38, 15) NOT NULL, F6 
    NUMBER(38, 100) NOT NULL, F7 NUMBER NOT NULL, F8 NUMBER NOT 
    NULL, F9 DATE NOT NULL, F10 ROWID NOT NULL, F11 RAW(2000) 
    NOT NULL, F12 LONG RAW NOT NULL, F13 BLOB NOT NULL, F14 
    CLOB NOT NULL, F15 NCLOB NOT NULL, F16 UROWID NOT NULL, 
    F17 FLOAT(126) NOT NULL);