Get HTML - html_special_entity_codes_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_special_entity_codes_t.sql -- -- Author: Steve Roach -- -- Date: 17-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table HTML_SPECIAL_ENTITY_CODES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 17-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE html_special_entity_codes CASCADE CONSTRAINTS / CREATE TABLE html_special_entity_codes ( special_entity_code VARCHAR2(6) NOT NULL ,character VARCHAR2(1) NOT NULL ,description VARChAR2(100) NOT NULL ) / COMMENT ON TABLE html_special_entity_codes IS 'A conversion table that matches the special entity codes to the characters they represent.' / COMMENT ON COLUMN html_special_entity_codes.special_entity_code IS 'The common special entity code without the ampersand and semi-colon - case sensitive.' / COMMENT ON COLUMN html_special_entity_codes.character IS 'The character represented by the code.' / COMMENT ON COLUMN html_special_entity_codes.description IS 'A description of the code.' /