SQL Projection is the collective name for the columns that are Selected and returned from a query. In other words, the columns goes behind select in a query. In Oracle, a whole row is first fetched, then data values from the columns within that row are extracted into the known projection.
To see the projection in SQL Developer, go to "Tools" --> "Preferences" --> "Database" --> "Autotrace/Explain Plan", select "projection".
To see the projection in SQL Developer, go to "Tools" --> "Preferences" --> "Database" --> "Autotrace/Explain Plan", select "projection".
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/638844/viewspace-776242/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/638844/viewspace-776242/