金仓数据库字段_kingbase数据库建表及插数据

kingbase数据库建表及插数据

一、建表

CREATE TABLE   KB表名(

T_ID                  bigint,

T_NUMERIC     numeric(10,5),

T_DATE             date,

T_TIMESTAMP    timestamp,

T_VARCHAR    varchar(20),

T_CHAR    char(20),

T_CLOB  clob,

T_TEXT text,

T_BLOB  blob,

T_XML xml,

T_REAL real,

T_BIT  bit(2000),

T_BOOL  bool,

PRIMARY KEY (T_ID)

);

二、插入数据

CREATE PROCEDURE  PRO_KB表名() as

DECLARE

v_id integer :=1;

i_date bigint  :=200101010000;

I_time bigint  :=200101010000;

v_date  date;

v_time  timestamp;

BEGIN

FOR i IN 1..10 LOOP

SELECT to_date(to_char(i_date),'yyyymmddhh24miss') into v_date from dual;

SELECT to_timestamp(to_char(i_time),'yyyymmddhh24miss') into v_time from dual;

INSERT IN