IndiaBIX

Database - Managing Databases with Oracle - Discussion

Discussion Forum : Managing Databases with Oracle - General Questions (Q.No. 6)
Managing Databases with Oracle
6.
Which of the following is not true of SQL views?
Oracle views cannot use the ORDER BY clause in view definitions.
Oracle views are created using the standard SQL-92 CREATE VIEW command.
Oracle views can by queried.
The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
1 comments Page 1 of 1.
Adi said:   1 decade ago
We can use the ORDER BY CLAUSE in views.

Eg: create view emp_vi as select * from emp order by deptno

This query successfully executed.
(1)
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers