What is the usage of as in oracle

In Oracle, the main function of as is to add aliases to the fields in the table. Adding double quotes when naming the alias can be case-sensitive. If the defined alias is multiple characters, you must add double quotes. The syntax is "select value as value1".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the usage of as in oracle

The function of as in oracle is mainly to add aliases to the fields in the table. As shown below

You can also be case-sensitive when naming aliases, but you need to add double quotes "". If you don't add double quotes If only the first letter is capitalized, it will be replaced with all capitals when querying the results.

If the defined alias has multiple characters, a grammatical error will be reported if double quotes are not added.

#So if the alias you want to define consists of multiple characters, you must add double quotes. As shown below

#When using as to define aliases for columns, the as keyword can be omitted. As shown below.

You can also define Chinese aliases through the as keyword, but for the sake of standardization, Chinese aliases are generally not often used.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What is the usage of as in oracle. For more information, please follow other related articles on the PHP Chinese website!