A question on viewsA. views have separate tablesB. they do not specify tablesC. they have simply definitionD. None of the above.Which of the following has function scope:A. automatic variablesB. static variablesC. extern variablesD. none of the above

Interview Candidate
Jun 21st, 2005
2
1364

Showing Answers 1 - 2 of 2 Answers

deviji2000
Profile Answers by deviji2000

Oct 16th, 2007

1)      views r stored as a SELECT statements in the data dictionary.

2)      they specify tables like

         create or replace view vw_emp as SELECT * FROM emp;

         so, they specify tables in select statements.

3)      of course there is nothing like view body like package body or proc body
          instead u can view the structure of a view using

         desc vw_emp;

         and get the contents the view like

         select * from vw_emp;

cheers,
viji