SESSION NAME: Views.
QUESTION NAME: Views - 6.
TABLE DESCRIPTION:
Create a VIEW as your RegistrationNumber_06.
For example your registration number is
RA1511003010255 the create a view as RA1511003010255_06.
The view should be created for suppliers table for the
following fields:
1. SupplierID
2. SupplierName
3. Address
4. Phone
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 SupplierID, SupplierName, Address ,Phone FROM RA1931005040030_06;
0 Comments