说明:创建table时可使用函数名作为字段名,但不可使用关键字作为字段名。
oracle关键字:
ACCESS ADD ALL ALTER AND ANY AS ASC AUDIT BETWEEN BY CHAR CHECK CLUSTER COLUMN COMMENT
COMPRESS CONNECT CREATE CURRENT DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP ELSE
EXCLUSIVE EXISTS FILE FLOAT FOR FROM GRANT GROUP HAVING IDENTIFIED IMMEDIATE IN INCREMENT
INDEX INITIAL INSERT INTEGER INTERSECT INTO IS LEVEL LIKE LOCK LONG MAXEXTENTS MINUS
MLSLABEL MODE MODIFY NOAUDIT NOCOMPRESS NOT NOWAIT NULL NUMBER OF OFFLINE ON ONLINE
OPTION OR ORDER 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 ACOS ASIN ATAN CEIL COS COSH EXP FLOOR LN LOG MOD 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;
}
oracle关键字:
ACCESS ADD ALL ALTER AND ANY AS ASC AUDIT BETWEEN BY CHAR CHECK CLUSTER COLUMN COMMENT
COMPRESS CONNECT CREATE CURRENT DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP ELSE
EXCLUSIVE EXISTS FILE FLOAT FOR FROM GRANT GROUP HAVING IDENTIFIED IMMEDIATE IN INCREMENT
INDEX INITIAL INSERT INTEGER INTERSECT INTO IS LEVEL LIKE LOCK LONG MAXEXTENTS MINUS
MLSLABEL MODE MODIFY NOAUDIT NOCOMPRESS NOT NOWAIT NULL NUMBER OF OFFLINE ON ONLINE
OPTION OR ORDER 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 ACOS ASIN ATAN CEIL COS COSH EXP FLOOR LN LOG MOD 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;
}