oracle动态创建table关键字过滤
说明：创建table时可使用函数名作为字段名，但不可使用关键字作为字段名。oracle关键字:
ACCESSADDALLALTERANDANYASASCAUDITBETWEENBYCHAR CHECKCLUSTERCOLUMNCOMMENT
COMPRESSCONNECTCREATECURRENT DATEDECIMALDEFAULTDELETEDESCDISTINCTDROPELSE
EXCLUSIVE EXISTSFILEFLOAT FORFROMGRANTGROUPHAVINGIDENTIFIED IMMEDIATEININCREMENT
INDEXINITIALINSERTINTEGERINTERSECT INTOISLEVELLIKELOCKLONGMAXEXTENTSMINUS
MLSLABELMODE MODIFYNOAUDITNOCOMPRESSNOTNOWAITNULLNUMBEROFOFFLINE ONONLINE
OPTIONORORDER PCTFREE PRIOR PRIVILEGES PUBLIC RAW RENAME RESOURCE REVOKE ROW ROWID ROWNUM ROWS
SELECT SESSION SET SHARE SIZE SMALLINT START SUCCESSFUL SYNONYM SYSDATE TABLE THEN TO TRIGGER UID
UNION UNIQUE UPDATE USER VALIDATE VALUES VARCHAR VARCHAR2 VIEW WHENEVER WHERE WITH
oracle函数名:
TO_DATE TO_CHAR ASCII CHR CONCAT INITCAP INSTR LENGTH LOWER UPPER RPAD LPAD LTRIM RTRIM TRIM SUBSTR REPLACE
ABS ACOSASIN ATAN CEIL COS COSH EXP FLOORLNLOGMOD POWER ROUND TRUNC SIGN SIN SIGH TAN TANH TRUNC
ADD_MONTHS LAST_DAY MONTHS_BETWEEN NEW_TIME NEXT_DAY SYSDATE CHARTOROWID CONVERT HEXTORAW RAWTOHEXT ROWIDTOCHAR
TO_MULTI_BYTE TO_NUMBER BFILENAME CONVERT DUMP EMPTY_BLOB EMPTY_CLOB GREATEST LEAST UID USEREVN MAX MIN STDDEV
VARIANCE DUAL
js验证：
var sourceRow=document.getElementById("sourceRow");
if(
sourceRow.value.toLocaleUpperCase()=="ADD"||
sourceRow.value.toLocaleUpperCase()=="ACCESS"||
sourceRow.value.toLocaleUpperCase()=="ALL"||
sourceRow.value.toLocaleUpperCase()=="ALTER"||
sourceRow.value.toLocaleUpperCase()=="AND"||
sourceRow.value.toLocaleUpperCase()=="ANY"||
sourceRow.value.toLocaleUpperCase()=="AS"||
sourceRow.value.toLocaleUpperCase()=="ASC"||
sourceRow.value.toLocaleUpperCase()=="AUDIT"||
sourceRow.value.toLocaleUpperCase()=="BETWEEN"||
sourceRow.value.toLocaleUpperCase()=="BLOB"||
sourceRow.value.toLocaleUpperCase()=="BINARY_FLOAT"||
sourceRow.value.toLocaleUpperCase()=="BINARY_DOUBLE"||
sourceRow.value.toLocaleUpperCase()=="BY"||
sourceRow.value.toLocaleUpperCase()=="CLOB"||
sourceRow.value.toLocaleUpperCase()=="CHAR"||
sourceRow.value.toLocaleUpperCase()=="CHECK"||
sourceRow.value.toLocaleUpperCase()=="CLUSTER"||
sourceRow.value.toLocaleUpperCase()=="COLUMN"||
sourceRow.value.toLocaleUpperCase()=="COMMENT"||
sourceRow.value.toLocaleUpperCase()=="COMPRESS"||
sourceRow.value.toLocaleUpperCase()=="CONNECT"||
sourceRow.value.toLocaleUpperCase()=="CREATE"||
sourceRow.value.toLocaleUpperCase()=="CURRENT"||
sourceRow.value.toLocaleUpperCase()=="DATE"||
sourceRow.value.toLocaleUpperCase()=="DECIMAL"||
sourceRow.value.toLocaleUpperCase()=="DEFAULT"||
sourceRow.value.toLocaleUpperCase()=="DELETE"||
sourceRow.value.toLocaleUpperCase()=="DESC"||
sourceRow.value.toLocaleUpperCase()=="DISTINCT"||
sourceRow.value.toLocaleUpperCase()=="DROP"||
sourceRow.value.toLocaleUpperCase()=="ELSE"||
sourceRow.value.toLocaleUpperCase()=="EXELUSIVE"||
sourceRow.value.toLocaleUpperCase()=="EXISTS"||
sourceRow.value.toLocaleUpperCase()=="FILE"||
sourceRow.value.toLocaleUpperCase()=="FUNCTION"||
sourceRow.value.toLocaleUpperCase()=="FLOAT"||
sourceRow.value.toLocaleUpperCase()=="FOR"||
sourceRow.value.toLocaleUpperCase()=="FROM"||
sourceRow.value.toLocaleUpperCase()=="GRANT"||
sourceRow.value.toLocaleUpperCase()=="GROUP"||
sourceRow.value.toLocaleUpperCase()=="HAVING"||
sourceRow.value.toLocaleUpperCase()=="IDENTIFIED"||
sourceRow.value.toLocaleUpperCase()=="IMMEDIATE"||
sourceRow.value.toLocaleUpperCase()=="IN"||
sourceRow.value.toLocaleUpperCase()=="INCREMENT"||
sourceRow.value.toLocaleUpperCase()=="INDEX"||
sourceRow.value.toLocaleUpperCase()=="INITIAL"||
sourceRow.value.toLocaleUpperCase()=="INSERT"||
sourceRow.value.toLocaleUpperCase()=="INTEGER"||
sourceRow.value.toLocaleUpperCase()=="INTERSECT"||
sourceRow.value.toLocaleUpperCase()=="INTO"||
sourceRow.value.toLocaleUpperCase()=="IS"||
sourceRow.value.toLocaleUpperCase()=="LEVEL"||
sourceRow.value.toLocaleUpperCase()=="LIBRARY"||
sourceRow.value.toLocaleUpperCase()=="LIKE"||
sourceRow.value.toLocaleUpperCase()=="LOCK"||
sourceRow.value.toLocaleUpperCase()=="LONG"||
sourceRow.value.toLocaleUpperCase()=="MAXEXTENTS"||
sourceRow.value.toLocaleUpperCase()=="MINUS"||
sourceRow.value.toLocaleUpperCase()=="MLSLABEL"||
sourceRow.value.toLocaleUpperCase()=="MODE"||
sourceRow.value.toLocaleUpperCase()=="MODIFY"||
sourceRow.value.toLocaleUpperCase()=="NOAUDIT"||
sourceRow.value.toLocaleUpperCase()=="NOCOMPRESS"||
sourceRow.value.toLocaleUpperCase()=="NVARCHAR2"||
sourceRow.value.toLocaleUpperCase()=="NCLOB"||
sourceRow.value.toLocaleUpperCase()=="NOT"||
sourceRow.value.toLocaleUpperCase()=="NOWAIT"||
sourceRow.value.toLocaleUpperCase()=="NULL"||
sourceRow.value.toLocaleUpperCase()=="NUMBER"||
sourceRow.value.toLocaleUpperCase()=="OF"||
sourceRow.value.toLocaleUpperCase()=="OFFLINE"||
sourceRow.value.toLocaleUpperCase()=="ON"||
sourceRow.value.toLocaleUpperCase()=="ONLINE"||
sourceRow.value.toLocaleUpperCase()=="OPTION"||
sourceRow.value.toLocaleUpperCase()=="OR"||
sourceRow.value.toLocaleUpperCase()=="ORDER"||
sourceRow.value.toLocaleUpperCase()=="PROCEDURE"||
sourceRow.value.toLocaleUpperCase()=="PACKAGE"||
sourceRow.value.toLocaleUpperCase()=="PCTFREE"||
sourceRow.value.toLocaleUpperCase()=="PRIOR"||
sourceRow.value.toLocaleUpperCase()=="PRIVILEGES"||
sourceRow.value.toLocaleUpperCase()=="PUBLIC"||
sourceRow.value.toLocaleUpperCase()=="RAW"||
sourceRow.value.toLocaleUpperCase()=="RENAME"||
sourceRow.value.toLocaleUpperCase()=="RESOURCE"||
sourceRow.value.toLocaleUpperCase()=="REVOKE"||
sourceRow.value.toLocaleUpperCase()=="ROW"||
sourceRow.value.toLocaleUpperCase()=="ROWID"||
sourceRow.value.toLocaleUpperCase()=="ROWNUM"||
sourceRow.value.toLocaleUpperCase()=="ROWS"||
sourceRow.value.toLocaleUpperCase()=="SELECT"||
sourceRow.value.toLocaleUpperCase()=="SEQUENCE"||
sourceRow.value.toLocaleUpperCase()=="SESSION"||
sourceRow.value.toLocaleUpperCase()=="SET"||
sourceRow.value.toLocaleUpperCase()=="SHARE"||
sourceRow.value.toLocaleUpperCase()=="SIZE"||
sourceRow.value.toLocaleUpperCase()=="SMALLINT"||
sourceRow.value.toLocaleUpperCase()=="START"||
sourceRow.value.toLocaleUpperCase()=="SUCCESSFUL"||
sourceRow.value.toLocaleUpperCase()=="SYNONYM"||
sourceRow.value.toLocaleUpperCase()=="SYSDATE"||
sourceRow.value.toLocaleUpperCase()=="TABLE"||
sourceRow.value.toLocaleUpperCase()=="TIMESTAMP"||
sourceRow.value.toLocaleUpperCase()=="TRIGGER"||
sourceRow.value.toLocaleUpperCase()=="THEN"||
sourceRow.value.toLocaleUpperCase()=="TO"||
sourceRow.value.toLocaleUpperCase()=="TYPE"||
sourceRow.value.toLocaleUpperCase()=="TRIGGER"||
sourceRow.value.toLocaleUpperCase()=="UID"||
sourceRow.value.toLocaleUpperCase()=="UNION"||
sourceRow.value.toLocaleUpperCase()=="UNIQUE"||
sourceRow.value.toLocaleUpperCase()=="UPDATE"||
sourceRow.value.toLocaleUpperCase()=="USER"||
sourceRow.value.toLocaleUpperCase()=="VALIDATE"||
sourceRow.value.toLocaleUpperCase()=="VALUES"||
sourceRow.value.toLocaleUpperCase()=="VARCHAR"||
sourceRow.value.toLocaleUpperCase()=="VARCHAR2"||
sourceRow.value.toLocaleUpperCase()=="VIEW"||
sourceRow.value.toLocaleUpperCase()=="WHENEVER"||
sourceRow.value.toLocaleUpperCase()=="WHERE"||
sourceRow.value.toLocaleUpperCase()=="WITH"
){
alert("字段 "+sourceRow.value+" 为系统保留字段或数据库关键字，禁止使用！";);
return false;
}
页:
[1]