SESSION NAME: Views.

QUESTION NAME: Views - 9.


TABLE DESCRIPTION:

Create a VIEW as your RegistrationNumber_09.

For example your registration number is
RA1511003010255 the create a view as
RA1511003010255_09.

The view should be created for Country table for the
following fields:

1. CODE
2. NAME
3. GNP
4. INDEPYEAR
5. SURFACEAREA

After creating view for the above mentioned fields display
the view.

Hint:

1. Create a view with specified name.
2. After creating the view delete the lines in the code
editor
3. Display the view (select * from viewname)

CODE:

SELECT CODE, NAME, GNP, INDEPYEAR, SURFACEAREA FROM RA1931005040001_09