SQL Projection

来源:互联网 发布:弈城围棋软件下载 编辑:程序博客网 时间:2024/06/03 08:22
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".

1 0
原创粉丝点击