Oracle wants to achieve the query effect of SQL

CSDN Q & A 2022-02-13 07:55:09 阅读数:840

oracle wants achieve query effect

Hello everyone , As a new contact Oracle Xiaobai has a basic question to ask , When executing a query, imagine sql Inquiry seems to be , "select Name 1, Name 2, Name 3, * from tablename" In this way , But it will report an error ,oracle It can be executed select Name 1, Name 2, Name 3 from Table name , Can not be like sql The same ?

Take the answer :

Give the table an alias , Just specify the alias :
select Name 1, Name 2, Name 3, t.* from tablename t

copyright:author[CSDN Q & A],Please bring the original link to reprint, thank you.