Tuesday , November 12 2024

Oracle Reserverd Words

Some words in the Oracle database are reserved for specific use or fully. In this way, it is intended to eliminate possible typographical errors in SQL statements.

You can find out what the reserved words are and whether they are reserved for a specific purpose or completely reserved, from the V$RESERVED_WORDS view.

For example, the word TABLE is a reserved word. We cannot use this word in information such as table name or column name. If used, we will receive errors as follows.

But if we need to use it, there is also a method. It is possible to use reserved words in double quotes.

As in the following examples, we can use reserved words in object names.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *