A column alias is a temporary name assigned to a column within a SQL statement. It is defined next to the column name using space or the AS keyword as a separator. By default, a column alias appears in uppercase. A column alias must be enclosed within double quotes if its case is to be preserved or it contains spaces or special characters such as $, #, etc.
A column alias cannot be used in the WHERE and GROUP BY clauses of a SELECT statement.
- Download free practice test for Oracle OCA DBA 10g exam.
- Download free practice test for Oracle OCA DBA 11g exam.
- Download free practice test for oca-dba9i OCA DBA 9i exam.
- Download free practice test for oca-dba9i-pl-sql OCA DBA 9i PL/SQL exam.
- Pass OCA PL/SQL Developer in first attampt.
- Download practice question and study guide for ocp-dba10g for exam.
- Download free practice test for Oracle OCP DBA 11g exam.
- Pass OCP DBA 9i in first attampt.
- Click here to get free ocp-pl-sql OCP PL/SQL Developer exam practice questions.
- Pass Oracle ocm-10g - Oracle Certified Master 10g
- Pass Oracle PL/SQL Developer in first attampt.
- Best exam simulation Oracle performance-tuning-certified-expert-11g download free trial.
- Click here to download rac-administrator-certified-experts-10g test study guide and practice question.
- Download practice question and study guide for 1Z0-007 for exam.
- Pass Oracle 1Z0-040 - OCA, 10g New Feature for Administrator
- Become Oracle Oracle Database SQL Expert certified.
- Pass Oracle 1Z0-051 - OCA: Oracle Database 11g-SQL Fundamentals-I
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
