SQL-Plus RESERVED WORDS (PL/SQL)
Die reservierten Wörter in PL/SQL haben eine spezielle Bedeutung und dürfen nicht für andere Zwecke verwendet werden.
Die folgende Liste zeigt die reservierten Wörter in PL/SQL:
ALL | DESC | JAVA | PACKAGE | SUBTYPE |
ALTER | DISTINCT | LEVEL | PARTITION | SUCCESSFUL |
AND | DO | LIKE | PCTFREE | SUM |
ANY | DROP | LIMITED | PLS_INTEGER | SYNONYM |
ARRAY | ELSE | LOCK | POSITIVE | SYSDATE |
AS | ELSIF | LONG | POSITIVEN | TABLE |
ASC | END | LOOP | PRAGMA | THEN |
AT | EXCEPTION | MAX | PRIOR | TIME |
AUTHID | EXCLUSIVE | MIN | PRIVATE | TIMESTAMP |
AVG | EXECUTE | MINUS | PROCEDURE | TIMEZONE_ABBR |
BEGIN | EXISTS | MINUTE | PUBLIC | TIMEZONE_HOUR |
BETWEEN | EXIT | MLSLABEL | RAISE | TIMEZONE_MINUTE |
BINARY_INTEGER | EXTENDS | MOD | RANGE | TIMEZONE_REGION |
BODY | EXTRACT | MODE | RAW | TO |
BOOLEAN | FALSE | MONTH | REAL | TRIGGER |
BULK | FETCH | NATURAL | RECORD | TRUE |
BY | FLOAT | NATURALN | REF | TYPE |
CHAR | FOR | NEW | RELEASE | UI |
CHAR_BASE | FORALL | NEXTVAL | RETURN | UNION |
CHECK | FROM | NOCOPY | REVERSE | UNIQUE |
CLOSE | FUNCTION | NOT | ROLLBACK | UPDATE |
CLUSTER | GOTO | NOWAIT | ROW | USE |
COALESCE | GROUP | NULL | ROWID | USER |
COLLECT | HAVING | NULLIF | ROWNUM | VALIDATE |
COMMENT | HEAP | NUMBER | ROWTYPE | VALUES |
COMMIT | HOUR | NUMBER_BASE | SAVEPOINT | VARCHAR |
COMPRESS | IF | OCIROWID | SECOND | VARCHAR2 |
CONNECT | IMMEDIATE | OF | SELECT | VARIANCE |
CONSTANT | IN | ON | SEPERATE | VIEW |
CREATE | INDEX | OPAQUE | SET | WHEN |
CURRENT | INDICATOR | OPEN | SHARE | WHENEVER |
CURRVAL | INSERT | OPERATOR | SMALLINT | WHERE |
CURSOR | INTEGER | OPTION | SPACE | WHILE |
DATE | INTERFACE | OR | SQL | WITH |
DAY | INTERSECT | ORDER | SQLCODE | WORK |
DECIMAL | INTERVAL | ORGANIZATION | SQLERRM | WRITE |
DECLARE | INTO | OTHERS | START | YEAR |
DEFAULT | IS | OUT | STDDEV | ZONE |
DELETE | ISOLATION |
Trademark Information:
Oracle is a registered trademark of Oracle Corporation.
Weiterführende Themen:
Leave a Response