oracle选择列时重命名列,sql – Oracle自动重命名列中的列？

我有2个表,包含以下字段.

表格1

> AA

> BB

> CC

> DD

表2

> AA

> CC

> EE

询问

Select t1.*,

t2.*

from table1 t1,

join table2 t2 on table1.DD = table2.EE

我的数据列返回以下列名称：

AA, BB, CC, DD, **AA_1**, **CC_1**, EE

我不希望列名这样.我希望他们将表名称作为common(或所有列)的名称前缀.我可以解决这个问题：

select t1.AA as t1_AA, t1.BB as t1_BB, t1.CC as t1_CC, t1.DD as t1_DD,

t2.AA as t2_AA, t2.CC as t2_CC, t2.EE as t2_EEE

from table1 t1,

inner join table2 t2

on table1.DD = table2.EE

但这意味着每个地方的每个选择都会变得长500行.在oracle中有没有神奇的方法呢？基本上我想写我的代码

select t1.* as t1_*, t2.* as t2_*

from table1 t1,

inner join table2 t2

on table1.DD = table2.EE

但当然这不是有效的SQL