头表

-- Create table
create global temporary table TPLINK.XXTP_MAIL_HEADER_TMP
(
mail_id NUMBER not null,
header_id NUMBER not null,
text CLOB,
wsize VARCHAR2(240),
fonts VARCHAR2(240),
color VARCHAR2(240),
fonts_type VARCHAR2(240)
)
on commit preserve rows;
-- Create/Recreate primary, unique and foreign key constraints
alter table TPLINK.XXTP_MAIL_HEADER_TMP
add primary key (HEADER_ID);