Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about Oracle query tips that do not clearly define columns. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

When debugging a query statement in Oracle: the possible problem in which columns are not clearly defined is not the renaming of fields, but that there are duplicate columns in the columns of the query. For example:

Select A.The journal rownum mynum from (

Select ID,NAME,AGE,SEX,ADDR,TEL,AGE from STUDENT where SEX ='1'-statement 1

) where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.