Mysql,Oracle,SqlServer三大数据库【关键字一览表】

发布时间:2017-03-08 SQLSERVER数据库 ORACLE 数据库 SQL SERVER MYSQL

为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字,接下来会列出mysql、oracle、sqlserver三个数据库各自的保留关键字。

SQLServer

下表列出了 SQL Server 保留关键字。

addEXTERNALPROCEDURE
ALLFETCHPUBLIC
ALTERFILERAISERROR
AndFILLFACTORREAD
ANYFORREADTEXT
AsFOREIGNRECONFIGURE
ASCFREETEXTREFERENCES
AUTHORIZATIONFREETEXTTABLEREPLICATION
BACKUPfromRESTORE
BEGINFULLRESTRICT
BETWEENFUNCTIONRETURN
BREAKGOTOREVERT
BROWSEGRANTREVOKE
BULKGROUPRIGHT
BYHAVINGROLLBACK
CASCADEHOLDLOCKROWCOUNT
CaseIDENTITYROWGUIDCOL
CHECKIDENTITY_INSERTRULE
CHECKPOINTIDENTITYCOLSAVE
closeIFSCHEMA
CLUSTEREDINSECURITYAUDIT
COALESCEINDEXSELECT
COLLATEINNERSEMANTICKEYPHRASETABLE
COLUMNINSERTSEMANTICSIMILARITYDETAILSTABLE
COMMITINTERSECTSEMANTICSIMILARITYTABLE
COMPUTEINTOSESSION_USER
CONSTRAINTisSET
CONTAINSJOINSETUSER
CONTAINSTABLEKEYSHUTDOWN
CONTINUEKILLSOME
CONVERTLEFTSTATISTICS
CREATELIKESYSTEM_USER
CROSSLINENOTABLE
CURRENTLOADTABLESAMPLE
CURRENT_DATEMERGETEXTSIZE
CURRENT_TIMENATIONALTHEN
CURRENT_TIMESTAMPNOCHECK目标
CURRENT_USERNONCLUSTEREDTOP
CURSORNOTTRAN
DATABASENULLTRANSACTION
DBCCNULLIFTrigger
DEALLOCATEOFTRUNCATE
DECLAREOFFTRY_CONVERT
DEFAULTOFFSETSTSEQUAL
deleteONUNION
DENYOPENUNIQUE
DESCOPENDATASOURCEUNPIVOT
DISKOPENQUERYUPDATE
DISTINCTOPENROWSETUPDATETEXT
DISTRIBUTEDOPENXMLUSE
DOUBLEOPTIONUSER
DROPORVALUES
DUMPORDERVARYING
ElseOUTERView
ENDOVERWAITFOR
ERRLVLPERCENTWHEN
ESCAPEPIVOTWHERE
EXCEPTPLANWHILE
EXECPRECISIONWITH
EXECUTEPRIMARYWITHIN GROUP
EXISTSPRINTWRITETEXT
EXITPROC

此外,ISO 标准定义了保留关键字列表。 不要使用 ISO 保留关键字作为对象名和标识符。 ODBC 保留关键字列表(如下表所示)与 ISO 保留关键字列表相同。

注意

ISO 标准保留关键字有时可能比 SQL Server 限制更多,有时则更少。 例如,ISO 保留关键字列表包含 INT。 SQL Server 不必将此区分为保留关键字。

Transact-SQL 保留关键字可用作数据库或数据库对象(如表、列、视图等)的标识符或名称。 使用带引号的标识符或分隔标识符。 不限制将保留关键字用作变量和存储过程参数的名

ODBC 保留关键字

保留了下列关键字以用于 ODBC 函数调用。这些关键字根本不约束 SQL 语法;然而,为确保与支持核心 SQL 语法的驱动程序兼容,应用程序应避免使用这些关键字。

Mysql
ACCESSIBLE (R)ACCOUNT[a]ACTION
ADD (R)AFTERAGAINST
AGGREGATEALGORITHMALL (R)
ALTER (R)ALWAYS[b]ANALYSE
ANALYZE (R)AND (R)ANY
AS (R)ASC (R)ASCII
ASENSITIVE (R)ATAUTOEXTEND_SIZE
AUTO_INCREMENTAVGAVG_ROW_LENGTH
BACKUPBEFORE (R)BEGIN
BETWEEN (R)BIGINT (R)BINARY (R)
BINLOGBITBLOB (R)
BLOCKBOOLBOOLEAN
BOTH (R)BTREEBY (R)
BYTECACHECALL (R)
CASCADE (R)CASCADEDCASE (R)
CATALOG_NAMECHAINCHANGE (R)
CHANGEDCHANNEL[c]CHAR (R)
CHARACTER (R)CHARSETCHECK (R)
CHECKSUMCIPHERCLASS_ORIGIN
CLIENTCLOSECOALESCE
CODECOLLATE (R)COLLATION
COLUMN (R)COLUMNSCOLUMN_FORMAT
COLUMN_NAMECOMMENTCOMMIT
COMMITTEDCOMPACTCOMPLETION
COMPRESSEDCOMPRESSION[d]CONCURRENT
CONDITION (R)CONNECTIONCONSISTENT
CONSTRAINT (R)CONSTRAINT_CATALOGCONSTRAINT_NAME
CONSTRAINT_SCHEMACONTAINSCONTEXT
CONTINUE (R)CONVERT (R)CPU
CREATE (R)CROSS (R)CUBE
CURRENTCURRENT_DATE (R)CURRENT_TIME (R)
CURRENT_TIMESTAMP (R)CURRENT_USER (R)CURSOR (R)
CURSOR_NAMEDATADATABASE (R)
DATABASES (R)DATAFILEDATE
DATETIMEDAYDAY_HOUR (R)
DAY_MICROSECOND (R)DAY_MINUTE (R)DAY_SECOND (R)
DEALLOCATEDEC (R)DECIMAL (R)
DECLARE (R)DEFAULT (R)DEFAULT_AUTH
DEFINERDELAYED (R)DELAY_KEY_WRITE
DELETE (R)DESC (R)DESCRIBE (R)
DES_KEY_FILEDETERMINISTIC (R)DIAGNOSTICS
DIRECTORYDISABLEDISCARD
DISKDISTINCT (R)DISTINCTROW (R)
DIV (R)DODOUBLE (R)
DROP (R)DUAL (R)DUMPFILE
DUPLICATEDYNAMICEACH (R)
ELSE (R)ELSEIF (R)ENABLE
ENCLOSED (R)ENCRYPTION[e]END
ENDSENGINEENGINES
ENUMERRORERRORS
ESCAPEESCAPED (R)EVENT
EVENTSEVERYEXCHANGE
EXECUTEEXISTS (R)EXIT (R)
EXPANSIONEXPIREEXPLAIN (R)
EXPORTEXTENDEDEXTENT_SIZE
FALSE (R)FASTFAULTS
FETCH (R)FIELDSFILE
FILE_BLOCK_SIZE[f]FILTER[g]FIRST
FIXEDFLOAT (R)FLOAT4 (R)
FLOAT8 (R)FLUSHFOLLOWS[h]
FOR (R)FORCE (R)FOREIGN (R)
FORMATFOUNDFROM (R)
FULLFULLTEXT (R)FUNCTION
GENERALGENERATED[i] (R)GEOMETRY
GEOMETRYCOLLECTIONGET (R)GET_FORMAT
GLOBALGRANT (R)GRANTS
GROUP (R)GROUP_REPLICATION[j]HANDLER
HASHHAVING (R)HELP
HIGH_PRIORITY (R)HOSTHOSTS
HOURHOUR_MICROSECOND (R)HOUR_MINUTE (R)
HOUR_SECOND (R)IDENTIFIEDIF (R)
IGNORE (R)IGNORE_SERVER_IDSIMPORT
IN (R)INDEX (R)INDEXES
INFILE (R)INITIAL_SIZEINNER (R)
INOUT (R)INSENSITIVE (R)INSERT (R)
INSERT_METHODINSTALLINSTANCE[k]
INT (R)INT1 (R)INT2 (R)
INT3 (R)INT4 (R)INT8 (R)
INTEGER (R)INTERVAL (R)INTO (R)
INVOKERIOIO_AFTER_GTIDS (R)
IO_BEFORE_GTIDS (R)IO_THREADIPC
IS (R)ISOLATIONISSUER
ITERATE (R)JOIN (R)JSON[l]
KEY (R)KEYS (R)KEY_BLOCK_SIZE
KILL (R)LANGUAGELAST
LEADING (R)LEAVE (R)LEAVES
LEFT (R)LESSLEVEL
LIKE (R)LIMIT (R)LINEAR (R)
LINES (R)LINESTRINGLIST
LOAD (R)LOCALLOCALTIME (R)
LOCALTIMESTAMP (R)LOCK (R)LOCKS
LOGFILELOGSLONG (R)
LONGBLOB (R)LONGTEXT (R)LOOP (R)
LOW_PRIORITY (R)MASTERMASTER_AUTO_POSITION
MASTER_BIND (R)MASTER_CONNECT_RETRYMASTER_DELAY
MASTER_HEARTBEAT_PERIODMASTER_HOSTMASTER_LOG_FILE
MASTER_LOG_POSMASTER_PASSWORDMASTER_PORT
MASTER_RETRY_COUNTMASTER_SERVER_IDMASTER_SSL
MASTER_SSL_CAMASTER_SSL_CAPATHMASTER_SSL_CERT
MASTER_SSL_CIPHERMASTER_SSL_CRLMASTER_SSL_CRLPATH
MASTER_SSL_KEYMASTER_SSL_VERIFY_SERVER_CERT (R)MASTER_TLS_VERSION[m]
MASTER_USERMATCH (R)MAXVALUE (R)
MAX_CONNECTIONS_PER_HOURMAX_QUERIES_PER_HOURMAX_ROWS
MAX_SIZEMAX_STATEMENT_TIME[n]MAX_UPDATES_PER_HOUR
MAX_USER_CONNECTIONSMEDIUMMEDIUMBLOB (R)
MEDIUMINT (R)MEDIUMTEXT (R)MEMORY
MERGEMESSAGE_TEXTMICROSECOND
MIDDLEINT (R)MIGRATEMINUTE
MINUTE_MICROSECOND (R)MINUTE_SECOND (R)MIN_ROWS
MOD (R)MODEMODIFIES (R)
MODIFYMONTHMULTILINESTRING
MULTIPOINTMULTIPOLYGONMUTEX
MYSQL_ERRNONAMENAMES
NATIONALNATURAL (R)NCHAR
NDBNDBCLUSTERNEVER[o]
NEWNEXTNO
NODEGROUPNONBLOCKING[p]NONE
NOT (R)NO_WAITNO_WRITE_TO_BINLOG (R)
NULL (R)NUMBERNUMERIC (R)
NVARCHAROFFSETOLD_PASSWORD[q]
ON (R)ONEONLY
OPENOPTIMIZE (R)OPTIMIZER_COSTS[r] (R)
OPTION (R)OPTIONALLY (R)OPTIONS
OR (R)ORDER (R)OUT (R)
OUTER (R)OUTFILE (R)OWNER
PACK_KEYSPAGEPARSER
PARSE_GCOL_EXPR[s]PARTIALPARTITION (R)
PARTITIONINGPARTITIONSPASSWORD
PHASEPLUGINPLUGINS
PLUGIN_DIRPOINTPOLYGON
PORTPRECEDES[t]PRECISION (R)
PREPAREPRESERVEPREV
PRIMARY (R)PRIVILEGESPROCEDURE (R)
PROCESSLISTPROFILEPROFILES
PROXYPURGE (R)QUARTER
QUERYQUICKRANGE (R)
READ (R)READS (R)READ_ONLY
READ_WRITE (R)REAL (R)REBUILD
RECOVERREDOFILEREDO_BUFFER_SIZE
REDUNDANTREFERENCES (R)REGEXP (R)
RELAYRELAYLOGRELAY_LOG_FILE
RELAY_LOG_POSRELAY_THREADRELEASE (R)
RELOADREMOVERENAME (R)
REORGANIZEREPAIRREPEAT (R)
REPEATABLEREPLACE (R)REPLICATE_DO_DB[u]
REPLICATE_DO_TABLE[v]REPLICATE_IGNORE_DB[w]REPLICATE_IGNORE_TABLE[x]
REPLICATE_REWRITE_DB[y]REPLICATE_WILD_DO_TABLE[z]REPLICATE_WILD_IGNORE_TABLE[aa]
REPLICATIONREQUIRE (R)RESET
RESIGNAL (R)RESTORERESTRICT (R)
RESUMERETURN (R)RETURNED_SQLSTATE
RETURNSREVERSEREVOKE (R)
RIGHT (R)RLIKE (R)ROLLBACK
ROLLUPROTATE[ab]ROUTINE
ROWROWSROW_COUNT
ROW_FORMATRTREESAVEPOINT
SCHEDULESCHEMA (R)SCHEMAS (R)
SCHEMA_NAMESECONDSECOND_MICROSECOND (R)
SECURITYSELECT (R)SENSITIVE (R)
SEPARATOR (R)SERIALSERIALIZABLE
SERVERSESSIONSET (R)
SHARESHOW (R)SHUTDOWN
SIGNAL (R)SIGNEDSIMPLE
SLAVESLOWSMALLINT (R)
SNAPSHOTSOCKETSOME
SONAMESOUNDSSOURCE
SPATIAL (R)SPECIFIC (R)SQL (R)
SQLEXCEPTION (R)SQLSTATE (R)SQLWARNING (R)
SQL_AFTER_GTIDSSQL_AFTER_MTS_GAPSSQL_BEFORE_GTIDS
SQL_BIG_RESULT (R)SQL_BUFFER_RESULTSQL_CACHE
SQL_CALC_FOUND_ROWS (R)SQL_NO_CACHESQL_SMALL_RESULT (R)
SQL_THREADSQL_TSI_DAYSQL_TSI_HOUR
SQL_TSI_MINUTESQL_TSI_MONTHSQL_TSI_QUARTER
SQL_TSI_SECONDSQL_TSI_WEEKSQL_TSI_YEAR
SSL (R)STACKEDSTART
STARTING (R)STARTSSTATS_AUTO_RECALC
STATS_PERSISTENTSTATS_SAMPLE_PAGESSTATUS
STOPSTORAGESTORED[ac] (R)
STRAIGHT_JOIN (R)STRINGSUBCLASS_ORIGIN
SUBJECTSUBPARTITIONSUBPARTITIONS
SUPERSUSPENDSWAPS
SWITCHESTABLE (R)TABLES
TABLESPACETABLE_CHECKSUMTABLE_NAME
TEMPORARYTEMPTABLETERMINATED (R)
TEXTTHANTHEN (R)
TIMETIMESTAMPTIMESTAMPADD
TIMESTAMPDIFFTINYBLOB (R)TINYINT (R)
TINYTEXT (R)TO (R)TRAILING (R)
TRANSACTIONTRIGGER (R)TRIGGERS
TRUE (R)TRUNCATETYPE
TYPESUNCOMMITTEDUNDEFINED
UNDO (R)UNDOFILEUNDO_BUFFER_SIZE
UNICODEUNINSTALLUNION (R)
UNIQUE (R)UNKNOWNUNLOCK (R)
UNSIGNED (R)UNTILUPDATE (R)
UPGRADEUSAGE (R)USE (R)
USERUSER_RESOURCESUSE_FRM
USING (R)UTC_DATE (R)UTC_TIME (R)
UTC_TIMESTAMP (R)VALIDATION[ad]VALUE
VALUES (R)VARBINARY (R)VARCHAR (R)
VARCHARACTER (R)VARIABLESVARYING (R)
VIEWVIRTUAL[ae] (R)WAIT
WARNINGSWEEKWEIGHT_STRING
WHEN (R)WHERE (R)WHILE (R)
WITH (R)WITHOUT[af]WORK
WRAPPERWRITE (R)X509
XAXID[ag]XML
XOR (R)YEARYEAR_MONTH (R)
ZEROFILL (R)
Oracle
select * from v$reserved_words order by keyword asc
!
!=
&
(
)
*
+
,
-
.
/
:
;
<
<<
<=
=
=>
>
>=
@
A
ABORT
ABS
ACCESS
ACCESSED
ACCOUNT
ACOS
ACTIVATE
ACTIVE_COMPONENT
ACTIVE_FUNCTION
ACTIVE_TAG
ADD
ADD_COLUMN
ADD_GROUP
ADD_MONTHS
ADJ_DATE
ADMIN
ADMINISTER
ADMINISTRATOR
ADVISE
ADVISOR
AFTER
ALIAS
ALL
ALLOCATE
ALLOW
ALL_ROWS
ALTER
ALWAYS
ANALYZE
ANCILLARY
AND
AND_EQUAL
ANTIJOIN
ANY
ANYSCHEMA
APPEND
APPENDCHILDXML
APPEND_VALUES
APPLY
ARCHIVE
ARCHIVELOG
ARRAY
AS
ASC
ASCII
ASCIISTR
ASIN
ASSEMBLY
ASSOCIATE
ASYNC
ASYNCHRONOUS
AT
ATAN
ATAN2
ATTRIBUTE
ATTRIBUTES
AUDIT
AUTHENTICATED
AUTHENTICATION
AUTHID
AUTHORIZATION
AUTO
AUTOALLOCATE
AUTOEXTEND
AUTOMATIC
AVAILABILITY
AVG
BACKUP
BASIC
BASICFILE
BATCH
BECOME
BEFORE
BEGIN
BEGIN_OUTLINE_DATA
BEHALF
BETWEEN
BFILE
BFILENAME
BIGFILE
BINARY
BINARY_DOUBLE
BINARY_DOUBLE_INFINITY
BINARY_DOUBLE_NAN
BINARY_FLOAT
BINARY_FLOAT_INFINITY
BINARY_FLOAT_NAN
BINDING
BIND_AWARE
BIN_TO_NUM
BITAND
BITMAP
BITMAPS
BITMAP_TREE
BITS
BLOB
BLOCK
BLOCKS
BLOCKSIZE
BLOCK_RANGE
BODY
BOTH
BOUND
BRANCH
BREADTH
BROADCAST
BUFFER
BUFFER_CACHE
BUFFER_POOL
BUILD
BULK
BY
BYPASS_RECURSIVE_CHECK
BYPASS_UJVC
BYTE
CACHE
CACHE_CB
CACHE_INSTANCES
CACHE_TEMP_TABLE
CALL
CANCEL
CARDINALITY
CASCADE
CASE
CAST
CATEGORY
CEIL
CELL_FLASH_CACHE
CERTIFICATE
CFILE
CHAINED
CHANGE
CHANGE_DUPKEY_ERROR_INDEX
CHAR
CHARACTER
CHARTOROWID
CHAR_CS
CHECK
CHECKPOINT
CHECK_ACL_REWRITE
CHILD
CHOOSE
CHR
CHUNK
CLASS
CLEAR
CLOB
CLONE
CLOSE
CLOSE_CACHED_OPEN_CURSORS
CLUSTER
CLUSTERING_FACTOR
CLUSTER_ID
CLUSTER_PROBABILITY
CLUSTER_SET
COALESCE
COALESCE_SQ
COARSE
COLD
COLLECT
COLUMN
COLUMNAR
COLUMNS
COLUMN_AUTH_INDICATOR
COLUMN_STATS
COLUMN_VALUE
COMMENT
COMMIT
COMMITTED
COMPACT
COMPATIBILITY
COMPILE
COMPLETE
COMPLIANCE
COMPOSE
COMPOSITE
COMPOSITE_LIMIT
COMPOUND
COMPRESS
COMPUTE
CONCAT
CONFIRM
CONFORMING
CONNECT
CONNECT_BY_CB_WHR_ONLY
CONNECT_BY_COMBINE_SW
CONNECT_BY_COST_BASED
CONNECT_BY_ELIM_DUPS
CONNECT_BY_FILTERING
CONNECT_BY_ISCYCLE
CONNECT_BY_ISLEAF
CONNECT_BY_ROOT
CONNECT_TIME
CONSIDER
CONSISTENT
CONST
CONSTANT
CONSTRAINT
CONSTRAINTS
CONTAINER
CONTENT
CONTENTS
CONTEXT
CONTINUE
CONTROLFILE
CONVERT
CORR
CORRUPTION
CORRUPT_XID
CORRUPT_XID_ALL
CORR_K
CORR_S
COS
COSH
COST
COST_XML_QUERY_REWRITE
COUNT
COVAR_POP
COVAR_SAMP
CO_AUTH_IND
CPU_COSTING
CPU_PER_CALL
CPU_PER_SESSION
CRASH
CREATE
CREATE_STORED_OUTLINES
CREATION
CROSS
CROSSEDITION
CSCONVERT
CUBE
CUBE_GB
CUME_DIST
CUME_DISTM
CURRENT
CURRENTV
CURRENT_DATE
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CURSOR_SHARING_EXACT
CURSOR_SPECIFIC_SEGMENT
CV
CYCLE
D
DANGLING
DATA
DATABASE
DATABASE_DEFAULT
DATAFILE
DATAFILES
DATAOBJNO
DATAOBJ_TO_PARTITION
DATE
DATE_MODE
DAY
DBA
DBA_RECYCLEBIN
DBMS_STATS
DBTIMEZONE
DB_ROLE_CHANGE
DB_VERSION
DDL
DEALLOCATE
DEBUG
DEBUGGER
DEC
DECIMAL
DECLARE
DECODE
DECOMPOSE
DECR
DECREMENT
DECRYPT
DEDUPLICATE
DEFAULT
DEFAULTS
DEFERRABLE
DEFERRED
DEFINED
DEFINER
DEGREE
DELAY
DELETE
DELETEXML
DEMAND
DENSE_RANK
DENSE_RANKM
DEPENDENT
DEPTH
DEQUEUE
DEREF
DEREF_NO_REWRITE
DESC
DETACHED
DETERMINES
DICTIONARY
DIMENSION
DIRECTORY
DIRECT_LOAD
DISABLE
DISABLE_PRESET
DISABLE_RPKE
DISALLOW
DISASSOCIATE
DISCONNECT
DISK
DISKGROUP
DISKS
DISMOUNT
DISTINCT
DISTINGUISHED
DISTRIBUTED
DML
DML_UPDATE
DOCFIDELITY
DOCUMENT
DOMAIN_INDEX_FILTER
DOMAIN_INDEX_NO_SORT
DOMAIN_INDEX_SORT
DOUBLE
DOWNGRADE
DRIVING_SITE
DROP
DROP_COLUMN
DROP_GROUP
DST_UPGRADE_INSERT_CONV
DUMP
DYNAMIC
DYNAMIC_SAMPLING
DYNAMIC_SAMPLING_EST_CDN
E
EACH
EDITION
EDITIONING
EDITIONS
ELEMENT
ELIMINATE_JOIN
ELIMINATE_OBY
ELIMINATE_OUTER_JOIN
ELSE
EMPTY
EMPTY_BLOB
EMPTY_CLOB
ENABLE
ENABLE_PRESET
ENCODING
ENCRYPT
ENCRYPTION
END
END_OUTLINE_DATA
ENFORCE
ENFORCED
ENQUEUE
ENTERPRISE
ENTITYESCAPING
ENTRY
ERROR
ERRORS
ERROR_ARGUMENT
ERROR_ON_OVERLAP_TIME
ESCAPE
ESTIMATE
EVALNAME
EVALUATION
EVENTS
EVERY
EXCEPT
EXCEPTIONS
EXCHANGE
EXCLUDE
EXCLUDING
EXCLUSIVE
EXECUTE
EXEMPT
EXISTS
EXISTSNODE
EXP
EXPAND_GSET_TO_UNION
EXPAND_TABLE
EXPIRE
EXPLAIN
EXPLOSION
EXPORT
EXPR_CORR_CHECK
EXTENDS
EXTENT
EXTENTS
EXTERNAL
EXTERNALLY
EXTRA
EXTRACT
EXTRACTVALUE
FACILITY
FACT
FACTORIZE_JOIN
FAILED
FAILED_LOGIN_ATTEMPTS
FAILGROUP
FALSE
FAST
FBTSCAN
FEATURE_ID
FEATURE_SET
FEATURE_VALUE
FILE
FILESYSTEM_LIKE_LOGGING
FILTER
FINAL
FINE
FINISH
FIRST
FIRSTM
FIRST_ROWS
FIRST_VALUE
FLAGGER
FLASHBACK
FLASH_CACHE
FLOAT
FLOB
FLOOR
FLUSH
FOLDER
FOLLOWING
FOLLOWS
FOR
FORCE
FORCE_XML_QUERY_REWRITE
FOREIGN
FOREVER
FORWARD
FREELIST
FREELISTS
FREEPOOLS
FRESH
FROM
FROM_TZ
FULL
FUNCTION
FUNCTIONS
G
GATHER_PLAN_STATISTICS
GBY_CONC_ROLLUP
GBY_PUSHDOWN
GENERATED
GLOBAL
GLOBALLY
GLOBAL_NAME
GLOBAL_TOPIC_ENABLED
GRANT
GREATEST
GROUP
GROUPING
GROUPING_ID
GROUPS
GROUP_BY
GROUP_ID
GUARANTEE
GUARANTEED
GUARD
H
HASH
HASHKEYS
HASH_AJ
HASH_SJ
HAVING
HEADER
HEAP
HELP
HEXTORAW
HEXTOREF
HIDDEN
HIDE
HIERARCHY
HIGH
HINTSET_BEGIN
HINTSET_END
HOT
HOUR
HWM_BROKERED
HYBRID
ID
IDENTIFIED
IDENTIFIER
IDENTITY
IDGENERATORS
IDLE_TIME
IF
IGNORE
IGNORE_OPTIM_EMBEDDED_HINTS
IGNORE_ROW_ON_DUPKEY_INDEX
IGNORE_WHERE_CLAUSE
IMMEDIATE
IMPACT
IMPORT
IN
INCLUDE
INCLUDE_VERSION
INCLUDING
INCR
INCREMENT
INCREMENTAL
INDENT
INDEX
INDEXED
INDEXES
INDEXTYPE
INDEXTYPES
INDEX_ASC
INDEX_COMBINE
INDEX_DESC
INDEX_FFS
INDEX_FILTER
INDEX_JOIN
INDEX_ROWS
INDEX_RRS
INDEX_RS
INDEX_RS_ASC
INDEX_RS_DESC
INDEX_SCAN
INDEX_SKIP_SCAN
INDEX_SS
INDEX_SS_ASC
INDEX_SS_DESC
INDEX_STATS
INDICATOR
INFINITE
INFORMATIONAL
INITCAP
INITIAL
INITIALIZED
INITIALLY
INITRANS
INLINE
INLINE_XMLTYPE_NT
INNER
INSERT
INSERTCHILDXML
INSERTCHILDXMLAFTER
INSERTCHILDXMLBEFORE
INSERTXMLAFTER
INSERTXMLBEFORE
INSTANCE
INSTANCES
INSTANTIABLE
INSTANTLY
INSTEAD
INSTR
INSTR2
INSTR4
INSTRB
INSTRC
INT
INTEGER
INTERMEDIATE
INTERNAL_CONVERT
INTERNAL_USE
INTERPRETED
INTERSECT
INTERVAL
INTO
INVALIDATE
INVISIBLE
IN_MEMORY_METADATA
IN_XQUERY
IS
ISOLATION
ISOLATION_LEVEL
ITERATE
ITERATION_NUMBER
JAVA
JOB
JOIN
K
KEEP
KEEP_DUPLICATES
KERBEROS
KEY
KEYS
KEYSIZE
KEY_LENGTH
KILL
LAG
LAST
LAST_DAY
LAST_VALUE
LATERAL
LAYER
LDAP_REGISTRATION
LDAP_REGISTRATION_ENABLED
LDAP_REG_SYNC_INTERVAL
LEAD
LEADING
LEAST
LEFT
LENGTH
LENGTH2
LENGTH4
LENGTHB
LENGTHC
LESS
LEVEL
LEVELS
LIBRARY
LIFE
LIFETIME
LIKE
LIKE2
LIKE4
LIKEC
LIKE_EXPAND
LIMIT
LINK
LIST
LISTAGG
LN
LNNVL
LOB
LOBNVL
LOBS
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCAL_INDEXES
LOCATION
LOCATOR
LOCK
LOCKED
LOG
LOGFILE
LOGFILES
LOGGING
LOGICAL
LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
LOGOFF
LOGON
LONG
LOW
LOWER
LPAD
LTRIM
M
MAIN
MAKE_REF
MANAGE
MANAGED
MANAGEMENT
MANUAL
MAPPING
MASTER
MATCHED
MATERIALIZE
MATERIALIZED
MAX
MAXARCHLOGS
MAXDATAFILES
MAXEXTENTS
MAXIMIZE
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXSIZE
MAXTRANS
MAXVALUE
MEASURE
MEASURES
MEDIAN
MEDIUM
MEMBER
MEMORY
MERGE
MERGE$ACTIONS
MERGE_AJ
MERGE_CONST_ON
MERGE_SJ
METHOD
MIGRATE
MIGRATION
MIN
MINEXTENTS
MINIMIZE
MINIMUM
MINING
MINUS
MINUS_NULL
MINUTE
MINVALUE
MIRROR
MIRRORCOLD
MIRRORHOT
MLSLABEL
MOD
MODE
MODEL
MODEL_COMPILE_SUBQUERY
MODEL_DONTVERIFY_UNIQUENESS
MODEL_DYNAMIC_SUBQUERY
MODEL_MIN_ANALYSIS
MODEL_NO_ANALYSIS
MODEL_PBY
MODEL_PUSH_REF
MODIFY
MONITOR
MONITORING
MONTH
MONTHS_BETWEEN
MOUNT
MOUNTPATH
MOVE
MOVEMENT
MULTISET
MV_MERGE
NAME
NAMED
NAMESPACE
NAN
NANVL
NATIONAL
NATIVE
NATIVE_FULL_OUTER_JOIN
NATURAL
NAV
NCHAR
NCHAR_CS
NCHR
NCLOB
NEEDED
NESTED
NESTED_TABLE_FAST_INSERT
NESTED_TABLE_GET_REFS
NESTED_TABLE_ID
NESTED_TABLE_SET_REFS
NESTED_TABLE_SET_SETID
NETWORK
NEVER
NEW
NEW_TIME
NEXT
NEXT_DAY
NLJ_BATCHING
NLJ_INDEX_FILTER
NLJ_INDEX_SCAN
NLJ_PREFETCH
NLSSORT
NLS_CALENDAR
NLS_CHARACTERSET
NLS_CHARSET_DECL_LEN
NLS_CHARSET_ID
NLS_CHARSET_NAME
NLS_COMP
NLS_CURRENCY
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_INITCAP
NLS_ISO_CURRENCY
NLS_LANG
NLS_LANGUAGE
NLS_LENGTH_SEMANTICS
NLS_LOWER
NLS_NCHAR_CONV_EXCP
NLS_NUMERIC_CHARACTERS
NLS_SORT
NLS_SPECIAL_CHARS
NLS_TERRITORY
NLS_UPPER
NL_AJ
NL_SJ
NO
NOAPPEND
NOARCHIVELOG
NOAUDIT
NOCACHE
NOCOMPRESS
NOCPU_COSTING
NOCYCLE
NODELAY
NOENTITYESCAPING
NOFORCE
NOGUARANTEE
NOLOCAL
NOLOGGING
NOMAPPING
NOMAXVALUE
NOMINIMIZE
NOMINVALUE
NOMONITORING
NONE
NONSCHEMA
NOORDER
NOOVERRIDE
NOPARALLEL
NOPARALLEL_INDEX
NORELY
NOREPAIR
NORESETLOGS
NOREVERSE
NOREWRITE
NORMAL
NOROWDEPENDENCIES
NOSCHEMACHECK
NOSEGMENT
NOSORT
NOSTRICT
NOSWITCH
NOT
NOTHING
NOTIFICATION
NOVALIDATE
NOWAIT
NO_ACCESS
NO_BASETABLE_MULTIMV_REWRITE
NO_BIND_AWARE
NO_BUFFER
NO_CARTESIAN
NO_CHECK_ACL_REWRITE
NO_COALESCE_SQ
NO_CONNECT_BY_CB_WHR_ONLY
NO_CONNECT_BY_COMBINE_SW
NO_CONNECT_BY_COST_BASED
NO_CONNECT_BY_ELIM_DUPS
NO_CONNECT_BY_FILTERING
NO_COST_XML_QUERY_REWRITE
NO_CPU_COSTING
NO_DOMAIN_INDEX_FILTER
NO_DST_UPGRADE_INSERT_CONV
NO_ELIMINATE_JOIN
NO_ELIMINATE_OBY
NO_ELIMINATE_OUTER_JOIN
NO_EXPAND
NO_EXPAND_GSET_TO_UNION
NO_EXPAND_TABLE
NO_FACT
NO_FACTORIZE_JOIN
NO_FILTERING
NO_GBY_PUSHDOWN
NO_INDEX
NO_INDEX_FFS
NO_INDEX_SS
NO_LOAD
NO_MERGE
NO_MODEL_PUSH_REF
NO_MONITOR
NO_MONITORING
NO_MULTIMV_REWRITE
NO_NATIVE_FULL_OUTER_JOIN
NO_NLJ_BATCHING
NO_NLJ_PREFETCH
NO_ORDER_ROLLUPS
NO_OUTER_JOIN_TO_INNER
NO_PARALLEL
NO_PARALLEL_INDEX
NO_PARTIAL_COMMIT
NO_PLACE_DISTINCT
NO_PLACE_GROUP_BY
NO_PQ_MAP
NO_PRUNE_GSETS
NO_PULL_PRED
NO_PUSH_PRED
NO_PUSH_SUBQ
NO_PX_JOIN_FILTER
NO_QKN_BUFF
NO_QUERY_TRANSFORMATION
NO_REF_CASCADE
NO_RESULT_CACHE
NO_REWRITE
NO_SEMIJOIN
NO_SET_TO_JOIN
NO_SQL_TUNE
NO_STAR_TRANSFORMATION
NO_STATEMENT_QUEUING
NO_STATS_GSETS
NO_SUBQUERY_PRUNING
NO_SUBSTRB_PAD
NO_SWAP_JOIN_INPUTS
NO_TEMP_TABLE
NO_TRANSFORM_DISTINCT_AGG
NO_UNNEST
NO_USE_HASH
NO_USE_HASH_AGGREGATION
NO_USE_INVISIBLE_INDEXES
NO_USE_MERGE
NO_USE_NL
NO_XMLINDEX_REWRITE
NO_XMLINDEX_REWRITE_IN_SELECT
NO_XML_DML_REWRITE
NO_XML_QUERY_REWRITE
NTH_VALUE
NTILE
NULL
NULLIF
NULLS
NUMBER
NUMERIC
NUMTODSINTERVAL
NUMTOYMINTERVAL
NUM_INDEX_KEYS
NVARCHAR2
NVL
NVL2
OBJECT
OBJECTTOXML
OBJNO
OBJNO_REUSE
OCCURENCES
OF
OFF
OFFLINE
OID
OIDINDEX
OLAP
OLD
OLD_PUSH_PRED
OLTP
ON
ONLINE
ONLY
OPAQUE
OPAQUE_TRANSFORM
OPAQUE_XCANONICAL
OPCODE
OPEN
OPERATIONS
OPERATOR
OPTIMAL
OPTIMIZER_FEATURES_ENABLE
OPTIMIZER_GOAL
OPTION
OPT_ESTIMATE
OPT_PARAM
OR
ORADEBUG
ORA_BRANCH
ORA_CHECKACL
ORA_DST_AFFECTED
ORA_DST_CONVERT
ORA_DST_ERROR
ORA_GET_ACLIDS
ORA_GET_PRIVILEGES
ORA_HASH
ORA_ROWSCN
ORA_ROWSCN_RAW
ORA_ROWVERSION
ORA_TABVERSION
ORDER
ORDERED
ORDERED_PREDICATES
ORDINALITY
ORGANIZATION
OR_EXPAND
OR_PREDICATES
OTHER
OUTER
OUTER_JOIN_TO_INNER
OUTLINE
OUTLINE_LEAF
OUT_OF_LINE
OVER
OVERFLOW
OVERFLOW_NOMOVE
OVERLAPS
OWN
OWNER
OWNERSHIP
P
PACKAGE
PACKAGES
PARALLEL
PARALLEL_INDEX
PARAM
PARAMETERS
PARENT
PARITY
PART$NUM$INST
PARTIALLY
PARTITION
PARTITIONS
PARTITION_HASH
PARTITION_LIST
PARTITION_RANGE
PASSING
PASSWORD
PASSWORD_GRACE_TIME
PASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_VERIFY_FUNCTION
PATH
PATHS
PBL_HS_BEGIN
PBL_HS_END
PCTFREE
PCTINCREASE
PCTTHRESHOLD
PCTUSED
PCTVERSION
PENDING
PERCENT
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
PERCENT_RANKM
PERFORMANCE
PERMANENT
PERMISSION
PFILE
PHYSICAL
PIKEY
PIVOT
PIV_GB
PIV_SSF
PLACE_DISTINCT
PLACE_GROUP_BY
PLAN
PLSCOPE_SETTINGS
PLSQL_CCFLAGS
PLSQL_CODE_TYPE
PLSQL_DEBUG
PLSQL_OPTIMIZE_LEVEL
PLSQL_WARNINGS
POINT
POLICY
POST_TRANSACTION
POWER
POWERMULTISET
POWERMULTISET_BY_CARDINALITY
PQ_DISTRIBUTE
PQ_MAP
PQ_NOMAP
PREBUILT
PRECEDES
PRECEDING
PRECISION
PRECOMPUTE_SUBQUERY
PREDICATE_REORDERS
PREDICTION
PREDICTION_BOUNDS
PREDICTION_COST
PREDICTION_DETAILS
PREDICTION_PROBABILITY
PREDICTION_SET
PREPARE
PRESENT
PRESENTNNV
PRESENTV
PRESERVE
PRESERVE_OID
PREVIOUS
PRIMARY
PRIOR
PRIVATE
PRIVATE_SGA
PRIVILEGE
PRIVILEGES
PROCEDURAL
PROCEDURE
PROCESS
PROFILE
PROGRAM
PROJECT
PROPAGATE
PROTECTED
PROTECTION
PUBLIC
PULL_PRED
PURGE
PUSH_PRED
PUSH_SUBQ
PX_GRANULE
PX_JOIN_FILTER
QB_NAME
QUERY
QUERY_BLOCK
QUEUE
QUEUE_CURR
QUEUE_ROWP
QUIESCE
QUORUM
QUOTA
RANDOM
RANDOM_LOCAL
RANGE
RANK
RANKM
RAPIDLY
RATIO_TO_REPORT
RAW
RAWTOHEX
RAWTONHEX
RBA
RBO_OUTLINE
RDBA
READ
READS
REAL
REBALANCE
REBUILD
RECORDS_PER_BLOCK
RECOVER
RECOVERABLE
RECOVERY
RECYCLE
RECYCLEBIN
REDO
REDUCED
REDUNDANCY
REF
REFERENCE
REFERENCED
REFERENCES
REFERENCING
REFRESH
REFTOHEX
REF_CASCADE_CURSOR
REGEXP_COUNT
REGEXP_INSTR
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_SUBSTR
REGISTER
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
REGULAR
REJECT
REKEY
RELATIONAL
RELY
REMAINDER
REMOTE_MAPPED
REMOVE
RENAME
REPAIR
REPEAT
REPLACE
REPLICATION
REQUIRED
RESET
RESETLOGS
RESIZE
RESOLVE
RESOLVER
RESOURCE
RESPECT
RESTORE
RESTORE_AS_INTERVALS
RESTRICT
RESTRICTED
RESTRICT_ALL_REF_CONS
RESULT_CACHE
RESUMABLE
RESUME
RETENTION
RETRY_ON_ROW_CHANGE
RETURN
RETURNING
REUSE
REVERSE
REVOKE
REWRITE
REWRITE_OR_ERROR
RIGHT
ROLE
ROLES
ROLLBACK
ROLLING
ROLLUP
ROUND
ROW
ROWDEPENDENCIES
ROWID
ROWIDTOCHAR
ROWIDTONCHAR
ROWNUM
ROWS
ROW_LENGTH
ROW_NUMBER
RPAD
RTRIM
RULE
RULES
SALT
SAMPLE
SAVEPOINT
SAVE_AS_INTERVALS
SB4
SCALE
SCALE_ROWS
SCAN
SCAN_INSTANCES
SCHEDULER
SCHEMA
SCHEMACHECK
SCN
SCN_ASCENDING
SCOPE
SD_ALL
SD_INHIBIT
SD_SHOW
SEARCH
SECOND
SECUREFILE
SECUREFILE_DBA
SECURITY
SEED
SEGMENT
SEG_BLOCK
SEG_FILE
SELECT
SELECTIVITY
SEMIJOIN
SEMIJOIN_DRIVER
SEQUENCE
SEQUENCED
SEQUENTIAL
SERIALIZABLE
SERVERERROR
SESSION
SESSIONS_PER_USER
SESSIONTIMEZONE
SESSIONTZNAME
SESSION_CACHED_CURSORS
SET
SETS
SETTINGS
SET_TO_JOIN
SEVERE
SHARE
SHARED
SHARED_POOL
SHOW
SHRINK
SHUTDOWN
SIBLINGS
SID
SIGN
SIGNAL_COMPONENT
SIGNAL_FUNCTION
SIMPLE
SIN
SINGLE
SINGLETASK
SINH
SIZE
SKIP
SKIP_EXT_OPTIMIZER
SKIP_UNQ_UNUSABLE_IDX
SKIP_UNUSABLE_INDEXES
SMALLFILE
SMALLINT
SNAPSHOT
SOME
SORT
SOUNDEX
SOURCE
SPACE
SPECIFICATION
SPFILE
SPLIT
SPREADSHEET
SQL
SQLLDR
SQL_TRACE
SQRT
STALE
STANDALONE
STANDBY
STANDBY_MAX_DATA_DELAY
STAR
START
STARTUP
STAR_TRANSFORMATION
STATEMENTS
STATEMENT_ID
STATEMENT_QUEUING
STATIC
STATISTICS
STATS_BINOMIAL_TEST
STATS_CROSSTAB
STATS_F_TEST
STATS_KS_TEST
STATS_MODE
STATS_MW_TEST
STATS_ONE_WAY_ANOVA
STATS_T_TEST_INDEP
STATS_T_TEST_INDEPU
STATS_T_TEST_ONE
STATS_T_TEST_PAIRED
STATS_WSR_TEST
STDDEV
STDDEV_POP
STDDEV_SAMP
STOP
STORAGE
STORE
STREAMS
STRICT
STRING
STRIP
STRIPE_COLUMNS
STRIPE_WIDTH
STRUCTURE
SUBMULTISET
SUBPARTITION
SUBPARTITIONS
SUBPARTITION_REL
SUBQUERIES
SUBQUERY_PRUNING
SUBSTITUTABLE
SUBSTR
SUBSTR2
SUBSTR4
SUBSTRB
SUBSTRC
SUCCESSFUL
SUM
SUMMARY
SUPPLEMENTAL
SUSPEND
SWAP_JOIN_INPUTS
SWITCH
SWITCHOVER
SYNC
SYNCHRONOUS
SYNONYM
SYSASM
SYSAUX
SYSDATE
SYSDBA
SYSOPER
SYSTEM
SYSTEM_DEFINED
SYSTIMESTAMP
SYS_AUDIT
SYS_CHECKACL
SYS_CONNECT_BY_PATH
SYS_CONTEXT
SYS_DBURIGEN
SYS_DL_CURSOR
SYS_DM_RXFORM_CHR
SYS_DM_RXFORM_NUM
SYS_DOM_COMPARE
SYS_DST_PRIM2SEC
SYS_DST_SEC2PRIM
SYS_ET_BFILE_TO_RAW
SYS_ET_BLOB_TO_IMAGE
SYS_ET_IMAGE_TO_BLOB
SYS_ET_RAW_TO_BFILE
SYS_EXTPDTXT
SYS_EXTRACT_UTC
SYS_FBT_INSDEL
SYS_FILTER_ACLS
SYS_GETTOKENID
SYS_GET_ACLIDS
SYS_GET_PRIVILEGES
SYS_GUID
SYS_MAKEXML
SYS_MAKE_XMLNODEID
SYS_MKXMLATTR
SYS_OPTLOBPRBSC
SYS_OPTXICMP
SYS_OPTXQCASTASNQ
SYS_OP_ADT2BIN
SYS_OP_ADTCONS
SYS_OP_ALSCRVAL
SYS_OP_ATG
SYS_OP_BIN2ADT
SYS_OP_BITVEC
SYS_OP_BL2R
SYS_OP_BLOOM_FILTER
SYS_OP_BLOOM_FILTER_LIST
SYS_OP_C2C
SYS_OP_CAST
SYS_OP_CEG
SYS_OP_CL2C
SYS_OP_COMBINED_HASH
SYS_OP_COMP
SYS_OP_CONVERT
SYS_OP_COUNTCHG
SYS_OP_CSCONV
SYS_OP_CSCONVTEST
SYS_OP_CSR
SYS_OP_CSX_PATCH
SYS_OP_DECOMP
SYS_OP_DESCEND
SYS_OP_DISTINCT
SYS_OP_DRA
SYS_OP_DUMP
SYS_OP_ENFORCE_NOT_NULL$
SYS_OP_EXTRACT
SYS_OP_GROUPING
SYS_OP_GUID
SYS_OP_IIX
SYS_OP_ITR
SYS_OP_LBID
SYS_OP_LOBLOC2BLOB
SYS_OP_LOBLOC2CLOB
SYS_OP_LOBLOC2ID
SYS_OP_LOBLOC2NCLOB
SYS_OP_LOBLOC2TYP
SYS_OP_LSVI
SYS_OP_LVL
SYS_OP_MAKEOID
SYS_OP_MAP_NONNULL
SYS_OP_MSR
SYS_OP_NICOMBINE
SYS_OP_NIEXTRACT
SYS_OP_NII
SYS_OP_NIX
SYS_OP_NOEXPAND
SYS_OP_NTCIMG$
SYS_OP_NUMTORAW
SYS_OP_OIDVALUE
SYS_OP_OPNSIZE
SYS_OP_PAR
SYS_OP_PARGID
SYS_OP_PARGID_1
SYS_OP_PAR_1
SYS_OP_PIVOT
SYS_OP_R2O
SYS_OP_RAWTONUM
SYS_OP_RDTM
SYS_OP_REF
SYS_OP_RMTD
SYS_OP_ROWIDTOOBJ
SYS_OP_RPB
SYS_OP_TOSETID
SYS_OP_TPR
SYS_OP_TRTB
SYS_OP_UNDESCEND
SYS_OP_VECAND
SYS_OP_VECBIT
SYS_OP_VECOR
SYS_OP_VECXOR
SYS_OP_VERSION
SYS_OP_VREF
SYS_OP_VVD
SYS_OP_XPTHATG
SYS_OP_XPTHIDX
SYS_OP_XPTHOP
SYS_OP_XTXT2SQLT
SYS_ORDERKEY_DEPTH
SYS_ORDERKEY_MAXCHILD
SYS_ORDERKEY_PARENT
SYS_PARALLEL_TXN
SYS_PATHID_IS_ATTR
SYS_PATHID_IS_NMSPC
SYS_PATHID_LASTNAME
SYS_PATHID_LASTNMSPC
SYS_PATH_REVERSE
SYS_PXQEXTRACT
SYS_RID_ORDER
SYS_ROW_DELTA
SYS_SC_2_XMLT
SYS_SYNRCIREDO
SYS_TYPEID
SYS_UMAKEXML
SYS_XMLANALYZE
SYS_XMLCONTAINS
SYS_XMLCONV
SYS_XMLEXNSURI
SYS_XMLGEN
SYS_XMLI_LOC_ISNODE
SYS_XMLI_LOC_ISTEXT
SYS_XMLLOCATOR_GETSVAL
SYS_XMLNODEID
SYS_XMLNODEID_GETCID
SYS_XMLNODEID_GETLOCATOR
SYS_XMLNODEID_GETOKEY
SYS_XMLNODEID_GETPATHID
SYS_XMLNODEID_GETPTRID
SYS_XMLNODEID_GETRID
SYS_XMLNODEID_GETSVAL
SYS_XMLNODEID_GETTID
SYS_XMLTRANSLATE
SYS_XMLTYPE2SQL
SYS_XMLT_2_SC
SYS_XQBASEURI
SYS_XQCASTABLEERRH
SYS_XQCODEP2STR
SYS_XQCODEPEQ
SYS_XQCON2SEQ
SYS_XQCONCAT
SYS_XQDELETE
SYS_XQDFLTCOLATION
SYS_XQDOC
SYS_XQDOCURI
SYS_XQED4URI
SYS_XQENDSWITH
SYS_XQERR
SYS_XQERRH
SYS_XQESHTMLURI
SYS_XQEXLOBVAL
SYS_XQEXSTWRP
SYS_XQEXTRACT
SYS_XQEXTRREF
SYS_XQEXVAL
SYS_XQFB2STR
SYS_XQFNBOOL
SYS_XQFNCMP
SYS_XQFNDATIM
SYS_XQFNLNAME
SYS_XQFNNM
SYS_XQFNNSURI
SYS_XQFNPREDTRUTH
SYS_XQFNQNM
SYS_XQFNROOT
SYS_XQFORMATNUM
SYS_XQFTCONTAIN
SYS_XQFUNCR
SYS_XQGETCONTENT
SYS_XQINDXOF
SYS_XQINSERT
SYS_XQINSPFX
SYS_XQIRI2URI
SYS_XQLANG
SYS_XQLLNMFRMQNM
SYS_XQMKNODEREF
SYS_XQNILLED
SYS_XQNODENAME
SYS_XQNORMSPACE
SYS_XQNORMUCODE
SYS_XQNSP4PFX
SYS_XQNSPFRMQNM
SYS_XQPFXFRMQNM
SYS_XQPOLYABS
SYS_XQPOLYADD
SYS_XQPOLYCEL
SYS_XQPOLYCST
SYS_XQPOLYCSTBL
SYS_XQPOLYDIV
SYS_XQPOLYFLR
SYS_XQPOLYMOD
SYS_XQPOLYMUL
SYS_XQPOLYRND
SYS_XQPOLYSQRT
SYS_XQPOLYSUB
SYS_XQPOLYUMUS
SYS_XQPOLYUPLS
SYS_XQPOLYVEQ
SYS_XQPOLYVGE
SYS_XQPOLYVGT
SYS_XQPOLYVLE
SYS_XQPOLYVLT
SYS_XQPOLYVNE
SYS_XQREF2VAL
SYS_XQRENAME
SYS_XQREPLACE
SYS_XQRESVURI
SYS_XQRNDHALF2EVN
SYS_XQRSLVQNM
SYS_XQRYENVPGET
SYS_XQRYVARGET
SYS_XQRYWRP
SYS_XQSEQ2CON
SYS_XQSEQ2CON4XC
SYS_XQSEQDEEPEQ
SYS_XQSEQINSB
SYS_XQSEQRM
SYS_XQSEQRVS
SYS_XQSEQSUB
SYS_XQSEQTYPMATCH
SYS_XQSTARTSWITH
SYS_XQSTATBURI
SYS_XQSTR2CODEP
SYS_XQSTRJOIN
SYS_XQSUBSTRAFT
SYS_XQSUBSTRBEF
SYS_XQTOKENIZE
SYS_XQTREATAS
SYS_XQXFORM
SYS_XQ_ASQLCNV
SYS_XQ_ATOMCNVCHK
SYS_XQ_NRNG
SYS_XQ_PKSQL2XML
SYS_XQ_UPKXML2SQL
T
TABLE
TABLES
TABLESPACE
TABLESPACE_NO
TABLE_STATS
TABNO
TAN
TANH
TBL$OR$IDX$PART$NUM
TEMPFILE
TEMPLATE
TEMPORARY
TEMP_TABLE
TEST
THAN
THE
THEN
THREAD
THROUGH
TIME
TIMEOUT
TIMES
TIMESTAMP
TIMEZONE_ABBR
TIMEZONE_HOUR
TIMEZONE_MINUTE
TIMEZONE_OFFSET
TIMEZONE_REGION
TIME_ZONE
TIV_GB
TIV_SSF
TO
TOPLEVEL
TO_BINARY_DOUBLE
TO_BINARY_FLOAT
TO_BLOB
TO_CHAR
TO_CLOB
TO_DATE
TO_DSINTERVAL
TO_LOB
TO_MULTI_BYTE
TO_NCHAR
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIME
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_TIME_TZ
TO_YMINTERVAL
TRACE
TRACING
TRACKING
TRAILING
TRANSACTION
TRANSFORM_DISTINCT_AGG
TRANSITION
TRANSITIONAL
TRANSLATE
TREAT
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNC
TRUNCATE
TRUSTED
TUNING
TX
TYPE
TYPES
TZ_OFFSET
U
UB2
UBA
UID
UNARCHIVED
UNBOUND
UNBOUNDED
UNDER
UNDO
UNDROP
UNIFORM
UNION
UNIQUE
UNISTR
UNLIMITED
UNLOCK
UNNEST
UNPACKED
UNPIVOT
UNPROTECTED
UNQUIESCE
UNRECOVERABLE
UNRESTRICTED
UNTIL
UNUSABLE
UNUSED
UPDATABLE
UPDATE
UPDATED
UPDATEXML
UPD_INDEXES
UPD_JOININDEX
UPGRADE
UPPER
UPSERT
UROWID
USAGE
USE
USER
USERENV
USERGROUP
USERS
USER_DEFINED
USER_RECYCLEBIN
USE_ANTI
USE_CONCAT
USE_HASH
USE_HASH_AGGREGATION
USE_INVISIBLE_INDEXES
USE_MERGE
USE_MERGE_CARTESIAN
USE_NL
USE_NL_WITH_INDEX
USE_PRIVATE_OUTLINES
USE_SEMI
USE_STORED_OUTLINES
USE_TTT_FOR_GSETS
USE_WEAK_NAME_RESL
USING
VALIDATE
VALIDATION
VALUE
VALUES
VARCHAR
VARCHAR2
VARIANCE
VARRAY
VARRAYS
VARYING
VAR_POP
VAR_SAMP
VECTOR_READ
VECTOR_READ_TRACE
VERIFY
VERSION
VERSIONING
VERSIONS
VERSIONS_ENDSCN
VERSIONS_ENDTIME
VERSIONS_OPERATION
VERSIONS_STARTSCN
VERSIONS_STARTTIME
VERSIONS_XID
VIEW
VIRTUAL
VISIBLE
VOLUME
VSIZE
WAIT
WALLET
WELLFORMED
WHEN
WHENEVER
WHERE
WHITESPACE
WIDTH_BUCKET
WITH
WITHIN
WITHOUT
WORK
WRAPPED
WRITE
XID
XML
XMLATTRIBUTES
XMLCAST
XMLCDATA
XMLCOLATTVAL
XMLCOMMENT
XMLCONCAT
XMLDIFF
XMLELEMENT
XMLEXISTS
XMLEXISTS2
XMLFOREST
XMLINDEX_REWRITE
XMLINDEX_REWRITE_IN_SELECT
XMLINDEX_SEL_IDX_TBL
XMLISNODE
XMLISVALID
XMLNAMESPACES
XMLPARSE
XMLPATCH
XMLPI
XMLQUERY
XMLROOT
XMLSCHEMA
XMLSERIALIZE
XMLTABLE
XMLTOOBJECT
XMLTRANSFORM
XMLTRANSFORMBLOB
XMLTYPE
XML_DML_RWT_STMT
XPATHTABLE
XS_SYS_CONTEXT
X_DYN_PRUNE
YEAR
YES
ZONE
[
]
^
{
|
}

更多相关推荐


性能测试新手误区(二):为什么我模拟的百万测试数据是无效的

发布时间:2012-03-14 数据库 大数据
  系列原创:性能测试新手误区   测试环境的重要性无需多说,大家都知道测试环境要尽量的模拟生产环境,当然也包括数据。这样测试的结果才会更加准确的反应真实的性能。就连开发过程,都已经开始在大数据量下加压开发了。那么,关于测试数据,你了解多少呢?  通常说的测试数据可以分为两类:  一是为了测试性能而准备的数据,这是用来模拟“压力”的数据。也就是常说的数据量、历史数据等。一般都会根据需求或者经验很容...

并发场景设计测试

发布时间:2017-03-30 数据库
Previous最近在看并发编程,但是对于我这么个渣渣来说,显然有点儿困难,于是跟一个老司机请教,(ˇˍˇ)~请他来出一个场景,然后我把我放在这个场景里面进行设计,so,玩一玩。。。场景设计数据库里面导入10w篇文章,然后对文章进行内容分词,采用多线程方式,线程池方式;达到要求:1,性能最大化;2,资源收集批量更新;步骤设计数据抓取使用Python抓取10w的文章,存入mysql;获取关键词集合取...

业务测试概念和执行

发布时间:2017-03-10 数据库
业务测试概念和执行一.业务测试概念:       业务测试是测试人员把系统各个模块串接起来运行、模拟真实用户     实际的工作流程,满足用户需求定义的功能来进行测试流程二.测试的时间:       已完成功能测试并保证功能正常使用三.业务流程分2种:       基本数据       业务数据重点:数据业务流程四.业务测试执行1.在执行业务测试之前,清空业务数据,保留基础数据2.按照业务用例执行...

MySQL数据库常见面试题一(传智专修学院2017级java4班)

1.在数据库中你怎么把时间进行格式化selectDATE_FORMAT(updated_at,'%y-%M-%D')fromtb_sku;2.什么是视图?表和视图的关系1.视图:就是一种虚拟的表,是一个逻辑表,本身不包含数据,作为一个select语句存在数据字典中的2.通过视图,可以展示基表的部分数据;视图数据来自定义视图的查询中使用的表,使用视图动态生成3.基表:用来创建视图的表叫做基表base...

MySQL中LIMIT查询和BETWEEN查询对比

发布时间:2017-10-19 MYSQL
当数据库某表中数据量较大时,查询会变得比较慢。在此情况下可以考虑BETWEEN查询替换LIMIT查询实测:app_log大约2000000条数据,从第1500000开始取出10条数据每次执行SQL语句之前进行数据库查询缓存操作resetquerycache;1、select*fromapp_loglimit1500000,10[SQL]select*fromapp_loglimit1500000,...

MySql INNODB引擎下的索引使用原则或注意事项

发布时间:2020-03-13 索引 数据库 MYSQL SQL JAVA
1、mysql的索引存储类型BTREE、HASHINNODB、MyISAM引擎下,只支持BTREE索引2、索引的分类-基于INNDB引擎1)普通索引,MySQL中基本索引类型,没有什么限制,允许在定义索引的列中插入重复值和空值,纯粹为了查询数据更快一点。2)唯一索引:索引列中的值必须是唯一的,但是允许为空值,如果是组合索引,则列值的组合必须唯一(普通索引和唯一索引该怎么选择:这两种索引查询性能差别...

使用用例场景,设计测试用例。

使用用例场景,设计测试用例作者:周毅概念和定义不完全、不彻底是软件测试的致命缺陷,任何程序只能进行少量而有限的测试。测试用例在此情况下产生,同时它也是软件测试系统化、工程化的产物。而测试用例的设计一直是软件测试工作的重点和难点. 什么是测试用例?为达到最佳的测试效果或高效的揭露隐藏的错误而精心设计的少量测试数据,称之为测试用例。我们不可能进行穷举测试,为了节省时间和资源、提高测试效率,必须要从数量...

HBase in Action 读书笔记

Chapter2.2.3&amp;2.2.5​HBase上RegionServer的内存分为两个部分,一部分作为Memstore,主要用来写;另外一部分作为BlockCache,主要用于读数据。以下是对HBase读写操作的详细描述。2.2.3Underthehood:theHBasewritepath——HBase写路径HBase写入操作包括两个部分:把写入操作分别记录到预写日志(WAL)和Mem...

GFS Google File System 读书笔记

针对Google应用的问题与需求设计1、在廉价、不可靠计算机上存储大量的数据,这使得节点失效是常态而不是异常。GFS必须能够较高容错、持续监控自身的状态,同时还要能从节点失效中快速恢复;2、纵观Google的内部应用,数据访问有以下特点:存储内容以大文件为主。系统需要存储的内容在通常情况下由数量不多的大文件构成,每个文件通常有几百MB甚至是几GB的大小;数据访问特点多为顺序访问,比较常见的场景是数...

系统测试全过程(转)

我一直感觉系统测试总像马拉松总是测试不完,什么时候上线,什么时候算终点。虽然提交客户了,可是对于质量仍然心里没底,对于测试的效果没有评价的依据。后来经过高人指点,终于领悟到至关重要的精髓:明确测试目标!   如果要将系统进行全面测试,那么就要有一套完整的测试阶段,每个阶段都以测试目标为标准,科学、有序地进行测试,那么测试效率也就会自然而然跟着提高。测试阶段分为:测试前准备、需求分析、测试计划、测试...

访问禅道显示提示“拒绝连接请求”

发布时间:2018-10-19 MYSQL
昨天还可以正常访问的禅道,第二天再访问,提示“000.000.000.000拒绝了我们的连接请求”,如图 查看后台禅道报错日志,没找到原因,然后,重启禅道,解决。启动禅道服务#/opt/zbox/zboxstart,...

linux 的部署与安装插件

发布时间:2022-03-15 MYSQL LINUX TOMCAT
请添加图片描述WFu,size_20,color_FFFFFF,t_70,g_se,x_16)-AINPUT-ptcp-mtcp--dport8080-jACCEPT路径mysql&gt;grantallprivileges.to‘root’@’%’identifiedby''root开启mysql远程登录权限mysql&gt;flushprivileges冲洗权限使生效/sbin/iptable...

MySQL只有information_schema,test两个数据库

发布时间:2016-01-22 数据库
安装好数据库时,连接MySQL,查看数据库时,发现只有两个数据库。MBP:~gegongxian$mysqlWelcometotheMySQLmonitor. Commandsendwith;or\g.YourMySQLconnectionidis75Serverversion:5.6.27MySQLCommunityServer(GPL)Copyright(c)2000,2015,Oraclea...

mysql root权限丢失只能看到information_schema数据库

发布时间:2018-05-31 MYSQL ROOT
mysqlroot权限丢失只能看到information_schema数据库解决办法vi/etc/mysql/mysql.conf.d/mysqld.cnf在文件最后一行添加skip-grant-tables保存后,root权限登录,运行 servicemysqldrestart重启mysql执行:mysql-uroot-pEnterpassword: (直接回车)执行:usemysqlDatab...

远程访问mysql只显示test和information_schema两个库

远程访问权限问题。在mysql服务器登录mysql-uroot-p*****先查一把确认是不是有人删库走人:mysql&gt;showdatabases;如果,很幸运的查出来你的库都还在,看看ip和用户的对应关系:mysql&gt;selecthost,userfrommysql.user;然后查看,远程登录的用户是否有权限:mysql&gt;showgrantsforuser(用户名)@'%';...

linux服务器安装Mysql后,只能看到information_schema/test这两个库,无法修改密码

发布时间:2020-02-25 MYSQL JAVA LINUX 数据库
1.关闭Mysql:执行servicemysqlstop2.用安全模式启动Mysql,如果是自己通过tar包手动安装的Mysql,mysqld_safe命令在“${mysql}/bin”下mysqld_safe--skip-grant-tables执行这条命令后,当前ssh命令行会停住,如下图3.复制当前链接,再打开一个ssh连接,登录到mysql数据库直接用命令mysql,就进入了数据了,不需要...

SQLyog连接数据库出现1130错误

发布时间:2019-01-07 MYSQL
修改root的连接限制,host=’%'为允许所有IP都有连接权限#mysql-uroot-pEnterpassword:mysql&gt;usemysql;mysql&gt;selecthostfromuserwhereuser='root';mysql&gt;updateusersethost='%'whereuser='root';mysql&gt;flushprivileges;...

SQLyog登陆MYSQL提示1130错误解决方法

发布时间:2008-05-21 MYSQL USER
权限问题造成的localhost改称%mysql-uroot-pmysql&gt;usemysql;mysql&gt;updateusersethost=‘%’whereuser=’root’;mysql&gt;flushprivileges;mysql&gt;select`host`,`user`fromuserwhereuser=’root’;...

SQLyog远程连接mysql时出现1130的解决办法

发布时间:2018-09-04 0->1 MYSQL
SQLyog远程连接mysql时出现1130的解决办法在远程主机上执行:msyql-uroo-p:(password)进入mysql:usemysql一般会出现:YoumustresetyourpasswordusingALTERUSERstatementbeforeexecutingthisstatement.\需要设置新的密码。设置密码:setpassword=password('newpas...

sqlyog连接Linux上的mysql报错误号码2013,错误号码1130的解决办法

发布时间:2018-09-23 运维 操作系统 数据库
 sqlyog连接Linux上的mysql报错误号码2013,错误号码1130的解决办法1.报错误号码2013,可能是端口号不是默认的3306,需要改成对应的,检查命令是:[root@hostetc]#netstat-an|grep330 看看有没有对应的端口号。更直接点是查看配置文件cat /etc/my.cnf(注意:在windows下是my.ini,Linux下则是my.cnf)重新测试连接...

转 Error No. 1130 Host '*.*.*.*' is not allowed to connect to this MySQL server

发布时间:2010-11-24 MYSQL 数据库 SERVER
出现情况:     使用mysql的客户端SQLyogEnterprise连接到mysql的服务端时,出现如下错误:     ErrorNo.1130     Host'*.*.*.*'isnotallowedtoconnecttothisMySQLserver原因:     这是由于mysql服务端root用户所对应的客户端权限设置问题。默认所对应的客户端地址只有localhost(也就是服务端...

SQLyog远程连接Mysql报错1130

发布时间:2022-02-16 MYSQL 服务器 数据库
解决该问题有以下两个方法1、改表法可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改“mysql”数据库里的“user”表里的“host”项,从”localhost”改称”%”mysql-uroot-pvmwaremysql&gt;usemysql;mysql&gt;updateusersethost='%'whereuse...

SQLyog远程连接1130错误解决方案

发布时间:2021-12-21 MYSQL 数据库
当连接mysql数据库的时候,出现ERROR1130(HY000):Host‘xxxx’isnotallowedtoconnecttothisMySQLserver的问题。解决该问题使用以下方法:授权法例如,你想root用户使用123456密码从任何主机连接到mysql服务器的话。GRANTALL PRIVILEGES ON *.*TO 'root'@'%' IDENTIFIEDBY '12345...

使用SQLyog远程连接mysql,以及mysql远程连接错误1130 解决方法

发布时间:2017-11-09 MYSQL
一、下载SQLyog安装包,下载完以后直接安装就可以了二、创建新连接,2.1点击软件右侧绿色图标,输入安装mysql的远程主机地址、登录mysql的用户名、密码,mysql的端口号,默认为3306端口2.1点击测试连接,测试连接是否正确可以看到此时测试连接报错,远程连接数据库的时候,出现ERROR1130(HY000):Host'192.168.0.1'isnotallowedtoconnectt...

SQLyog连接数据库报错1130:Host ‘192.168.0.1‘ is not allowed to connect to this MySQL server问题的解决

发布时间:2021-05-18 MYSQL SQLYOG
在使用SQLyog进行数据库连接时,有时我们会遇到下面问题:远程连接数据库的时候,出现ERROR1130(HY000):Host‘xxx.xxx.xxx.xxx’isnotallowedtoconnecttothisMySQLserver提示信息。报错原因:权限问题【当前主机host没有链接远程mysql数据库的权限】解决方法:修改mysql数据库中user表root用户的主机地址;1、使用roo...

sqlyog连接服务出现的2003和1130错误问题

发布时间:2018-10-15 MYSQL SQLYONG LINUX
最近新租的阿里云服务器自带的mysql数据库,想用sqlyog连接以下看看里面的东西,无奈连接的时候尽然错误,也是刚刚才玩服务器,所以折腾了半天。 先说2003错误码我的这个错误码原因是我3306端口在防火墙中没有放开,所以从阿里云控制台将3306端口放开这一步解决好了,又给我出现了一个问题 ERROR1130(HY000):Hos。。。。。。大概意思: 不能远程连接数据库,该条错误应该是该主机没...

xampp安装后httpd无法启动

发布时间:2014-03-31 WEB服务器 C/C++ 数据库 PHP
安装xampp(xampp-win32-1.8.0-VC9-installer.exe91.9MB)后,apache无法启动,老是提示:11:55:50[apache]Statuschangedetected:running11:55:51[apache]Statuschangedetected:stopped启动tomcat也失败搜索,大部分说是80和443端口被占用,但发现不是这问题,也有说A...

性能测试漫谈:性能测试之场景设计思想

验证测试是用于验证在特定的场景、时间、压力、环境和操作方式下系统能够正常的运行,服务器、应用系统和网络环境等软硬件设施还能否良好的支撑这些情况下用户的使用。验证性测试主要针对有明确的压力目标和预期结果,验证系统在这种压力下的各方面反映能够达到预期结果。主要分以下几种:压力测试:已知系统高峰期使用人数,验证各事务在最大并发数(通过高峰期人数换算)下事务响应时间能够达到客户要求。系统各性能指标在这种压...

信息安全等级测评师考试重点梳理

发布时间:2017-02-17 操作系统 数据库 网络
第一章网络安全测评网络全局1.1结构安全(G3)a)  应保证主要网络设备的业务处理能力具备冗余空间,满足业务高峰期需要;b)  应保证网络各个部分的带宽满足业务高峰期需要;c)   应在业务终端与业务服务器之间进行路由控制建立安全的访问路径;(静态动态路由、动态路由协议认证功能。)ospf开放最短路径优先)d)  应绘制与当前运行情况相符的网络拓扑结构图;e)  应根据各部门的工作职能、重要性和...

史上最全的测试用例设计方法总结

发布时间:2018-09-25 测试 运维 数据库
测试用例的设计方法(全)等价类划分方法:一.方法简介1.定义是把所有可能的输入数据,即程序的输入域划分成若干部分(子集),然后从每一个子集中选取少数具有代表性的数据作为测试用例。该方法是一种重要的,常用的黑盒测试用例设计方法。2.划分等价类:等价类是指某个输入域的子集合。在该子集合中,各个输入数据对于揭露程序中的错误都是等效的,并合理地假定:测试某等价类的代表值就等于对这一类其它值的测试,因此,可...

软件测试基础2----缺陷(bug)和黑盒测试

发布时间:2019-01-17 测试 系统架构 数据库
什么是软件缺陷(bug)  软件缺陷是指系统或系统部件中那些导致系统或部件不能实现其应有功能的缺陷。一般定义缺陷有以下5条原则:软件未实现产品说明书要求的功能。软件出现产品说明书指明不应该出现的错误。软件实现了产品说明书未说明的功能。软件未实现产品说明书虽未明确提及但应该实现的目标。软件难以理解,不易使用,运行速度慢,或者软件测试员认为最终用户会认为不好。提交缺陷(bug)的要求:Bug描述的基本...

用例级别和缺陷等级

发布时间:2017-07-03 测试 数据库
用例级别(level)     Level1 基本:  1、该类用例设计系统基本功能,1级用例的数量应受到控制,防止工作量过大。  2、划分依据:该用例执行的失败会导致众多重要功能无法运行的,如:表单维护中的增加功能、最平常的业务使用等。可以认为是发生概率较高的并经常这样使用的一些功能用例。  3、该级别的测试用例在每一轮版本测试中都必须执行  Level2 重要:1、2级测试用例实际系统的重要功...

测试专家问答----如何编写好的软件测试用例

发布时间:2013-09-02 测试 嵌入式 数据库
1、对于新产品和维护版的老产品设计的用例应该注意些什么呢?专家分析:新项目和维护项目从本质上看没有区别,维护产品,无非就是新增功能和缺陷修复两大类,和新项目相比,唯一需要注意的就是新增\修复的功能是否对其他部分有影响,这里就涉及到一个回归策略的问题——老功能要测多少。一般来说,需要和开发讨论确定受影响的范围,然后制定测试范围。当然最理想的情况就是整个系统全测,因为一旦系统复杂了,没有哪个开发能说清...

敏捷测试关键成功因素

发布时间:2018-06-28 测试 数据库
参考《敏捷软件测试》第21章关键成功要素为了帮助测试人员在敏捷团队中成功并帮助敏捷团队成功地发布高质量产品,现总结出具有敏捷思想的测试人员如何应用敏捷实践和提高工作质量。1、团队整体参与  当整个开发团队负责测试和质量问题,会发现学到不同的技能集合和经验等级来处理测试可能发生的问题。在团队中要注重1+1&gt;2。任何人都参与测试任务,团队才会设计出非常完美的可测试case。将测试人员真正成为开发...

Centos7 rpm安装mysql-8.0.13

发布时间:2019-05-09 MYSQL MSYQL
yum安装方式很方便,但是下载mysql的时候从官网下载,速度较慢。rpm安装方式可以从国内镜像下载mysql的rpm包,比较快。rpm适合离线安装。在CentOS7中默认安装有MariaDB,MariaDB是MySQL的分支,mysql和mariadb只能存在一个,所以我们需要先卸载系统自带的mariadb查看mariadb版本:rpm-qa|grepmariadb卸载mariadb(注意对应版...

2021-11-16thought

发布时间:2021-11-16 MYSQL SQL 数据库
153.最大子序和classSolution:defmaxSubArray(self,nums:List[int])-&gt;int:iflen(nums)==1:returnnums[0]curr=nums[0]max_sum=nums[0]foriinrange(1,len(nums)):ifcurr&lt;0:curr=nums[i]else:curr+=nums[i]max_sum=max...

多线程爬取中国土地市场网土地交易数据,最新2020/08/21

发布时间:2020-08-21 MYSQL PYTHON 爬虫
多线程爬取中国土地市场网土地交易数据可自动通过验证码(识别准确率不太高,所以设置了6次的重试机制,如果没事识别出来可自动重新识别,一般2-3次。),爬取网页过程中断可自动重试并继续爬取(因为增加了爬取中断处理,导致代码很长)6月份弄好的,2020.08.21测试了,依然行得通欢迎讨论实现方法尝试很多方法之后最终使用了如下方案:爬取数据:selenium+Chrome(此方法速度不快,也吃cpu,但...

Qt5+MySQL 插入中文乱码解决方案

发布时间:2021-06-02 MYSQL 乱码 数据库 QT
1.查看是否有mysql驱动,有输出MYSQL则有; QStringListdrivers=QSqlDatabase::drivers(); foreach(QStringdvr,drivers)  {    qDebug()&lt;&lt;dvr;  }2.有MYSQL驱动后,需要把libmysql.dll放在执行文件处,对应32位和64位,即Qt程序位32位则用32位的libmysql.dll...

MongoDB导入文件小技巧

发布时间:2021-12-14 NOSQL MONGODB 数据库
今天在用MongoDB导入文件时一直报错2021-12-14T16:23:44.807+0800EQUERY[js]SyntaxError:missing;beforestatement@(shell):1:14有点诡异…查看其它资料后发现应先启动MongoDB,在shell终端进入MongoDB的bin目录进入后在shell端输入(注意是在cmd的shell端!!!不是在mongodb的shel...

软件缺陷

发布时间:2019-07-03 测试 数据库
软件缺陷定义:从产品内部看,软件缺陷是软件产品开发或维护过程中所存在的错误、毛病等各种问题;从外部看,软件缺陷是系统所需要实现的某种功能的失效或违背与bug的区别:bug指某功能未实现,存在问题;缺陷指的是未满足用户的需求(bug∈ 缺陷)五大缺陷  软件未达到需求规格说明书表明的功能软件出现了需求规格说明书指明不会出现的错误软件的功能超出了需求规格说明书指明的范围(画蛇添足)软件未达到需求规格说...

Python连接sqlserver中文乱码的问题

发布时间:2014-09-04 PYTHON 数据库
第一次遇到这个问题,Google后才找到解决方法(百度果然还是太弱了啊),编码的问题还是不熟settings={'CMT_SQLSERVER_DSN':'MerchantPrice','CMT_SQLSERVER_USERNAME':'readuser','CMT_SQLSERVER_PASSWD':'password'}conn="DSN=%s;UID=%s;PWD=%s"%(settings[...

python向数据库插入中文乱码问题

发布时间:2015-11-17 PYTHON 数据库 数据库中文乱码
碰到编码问题就头疼啊!。。。。在想数据库中插入中文时候,会出现如下错误提示:Warning:Incorrectstringvalue:'\xE5\x8C\x97\xE4\xBA\xAC...'forcolumn'title'atrow1这个异常主要是由于数据库的字符编码选择错误造成,MySQL的默认编码是Latin1,不支持中文,最好修改为utf8的字符编码为宜!修改后就可以插入中文了。。。。。在...

Python 连接sql server数据库乱码(UnicodeDecodeError)

发布时间:2018-08-15 PYTHON 乱码 GBK SQL SERVER
今天客户运行写好的python程序时,遇到了乱码问题UnicodeDecodeError:'gbk'codeccan'tdecodebyte0xaainposition6:illegalmultibytesequen 乱码问题一直是特别特别头疼的问题,在网上搜索好久,找到一个解决方案,解决方案链接:https://www.jianshu.com/p/e0c95e94275d 大致说下,在连接sql...

python:pymssql查询结果集合中部分中文乱码处理

发布时间:2020-10-31 PYTHON 数据库 BUG 乱码 JAVA
python:pymssql查询结果中文乱码处理1、背景描述有个任务是用python去sqlserver捞数据(数据库连接编码是utf8),用到了多库多表查询,然后有部分返回值是写死的,就像这样select"人名币"as"币种",然后又因为两个库的编码格式不一样,最后导致,查出来的数据,部分乱码,乱码不是那种16进制的,比如这样b\xe4\xb8\xad,而是这种的真中文乱码,就像这样æ:°×ÁÖ...