What does as mean in oracle

as in oracle is the abbreviation of "alias", which means "alias". as is used to add an alias to a specified table or field. The syntax is "select value as value1"; when naming aliases, you need to distinguish the size. You need to add double quotes when writing. When no double quotes are added, the query results will all be replaced with uppercase letters

Operating environment for this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What does as mean in oracle

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

can also be case-sensitive when naming aliases, but you need to add double quotes "". If you do not 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.

Recommended tutorial: "Oracle Tutorial"

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