René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Reserved words in Oracle SQL | ||
The following words are reserved words in Oracle SQL (in 10g). Bold words indicate they're also reserved in the ANSI standard.
SQL_ prefix
When Oracle generates a name for an Objects, it usually prefixes it with SYS_. For example, if I don't name a
check constraint, Oracle will choose a name that starts with SYS_:
create table prefix_ex ( a number check (a > 10) ); select constraint_name from user_constraints where table_name = 'PREFIX_EX'; CONSTRAINT_NAME ------------------------------ SYS_C005096 Links
See also v$reserved_words and
reserved words in PL/SQL.
|