说明:创建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;
}
分享到:
相关推荐
Pipelined 是Oracle的一个关键字
JSP+oracle实现小型多关键字检索模块
Oracle关键字(保留字)的总结,搬运而来,挣点积分,感谢下载
主要介绍了Oracle 实现 一个关键字 匹配多个 字段的方法,本文给大家提供两个方案,非常不错,具有一定的参考借鉴价值 ,需要的朋友可以参考下
Oracle关键字用法整合
oracle数据库中包含的所有关键字收集
oracle关键字,一些常用关键字
主要给大家介绍了关于mybatis中使用oracle关键字出错的解决方法,文中通过示例代码将解决的方法介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面来一起看看吧。
没毛病,本人亲测oracle实现多字段匹配一个关键字查询
oracle实现多字段匹配一个关键字查询的两种方法
1)从T_GIRL表中查出全部的记录,按身高降序select id,name,yz,sc,height from T_GIRL order by height
ORACLE Rename Table的语法
详细描述了在oracle中创建方案的3种方法,包括利用图形界面和sql语句
Table dropped — 建立表K,字段名为UID(oracle关键字) SQL> CREATE TABLE k(UID INT); CREATE TABLE k(UID INT) ORA-00904: : invalid IDENTIFIER — 字段名加””表创建成功 SQL> CREATE TABLE k(“UID” INT);...
oracle 创建dblink的详细步骤,以及使用oracle快照快速的刷新,保持本地与远程数据库的同步
oracle过滤数字oracle过滤数字
oracle手动创建数据库
本文通过图表和实例的阐述在Oracle数据库创建新表时Storage的参数具体含义。
Oracle ERP R12 Table
oracle数据库创建脚本 #!/bin/sh OLD_UMASK=`umask` umask 0027 mkdir -p /oradata mkdir -p /u01/app/oracle/admin/tdrb/adump mkdir -p /u01/app/oracle/admin/tdrb/dpdump mkdir -p /u01/app/oracle/admin/tdrb...