Oracle中的字段起别名与表起别名的命名规则:
1.为字段起别名时,加不加as均可
select data_q_type as rule_type from q_config_sql_info; (√)
select data_q_type rule_type from q_config_sql_info; (√)
2.但是表名后面,一定不能加as来指定表别名
select a.* from q_config_sql_info as a; (×)
--> ORA-00933:SQL 命令未正确结束
正确SQL写法为:
select a.* from q_config_sql_info a; (√)
3.双引号括起来的表示特殊名字,比如名称中间有空格
select "main table".* from q_config_sql_info "main table"; (√)
select "main table".data_q_id "rule id" from q_config_sql_info "main table"; (√)