Kbase 15136: How to create an Oracle View
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to create an Oracle View
A view is created for an Oracle database in SQL via the creata view
command. A view is similar to a table in that it consists of rows
and columns where the rows and columns are defined by a select
statement setup during the create view command. The select statement
can be comprised of one or more Oracle database tables. In addition
the select statement can contain a fields list and, or a where clause
to limit the columns and, or rows in the view, respectively.
Progress Software Technical Support Note # 15136