Shulou(Shulou.com)06/01 Report--

In the oracle database, creating a view will not generate a corresponding rowid, only a pseudo-column rownum

Directly using select rowid from view 1 in the view will directly report the error "ORA-01446: you cannot use clauses such as DISTINCT,GROUP BY to select ROWID or sample from the view"; you can only use select rownum from view 1 to implement the query.

Note that views do not generate rowid

Only pseudo column rownum will be generated

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.