SQL Projection

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" --&gt "Preferences" --&gt "Database" --&gt "Autotrace/Explain Plan", select "projection".

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/638844/viewspace-776242/，如需轉載，請註明出處，否則將追究法律責任。