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