oracle静态视图和动态视图，oracle视图（oracle视图）.doc

 oracle视图（oracle视图） Definition of view: A view in a computer database is a virtual table whose contents are defined by queries. Like a real table, the view contains a series of column and row data with names.However,views dc not exist in the database as stored data value sets. Row and columndatadefinethetablereferencedbythequery of theview freely, and dynamically generate when referencing the view. SQLsqlplus scott/tiger Direct query SQL select empno, ename from emp; Create view SQL create viewEMPs as select empno, ename from emp; Create view EMPs as select empno, ename from EMP The first li