Create a view on the Client_master table for administration department.

[smart paper boy]

PROGRAM CODE:

CREATE VIEW vw_clientadmin AS
SELECT name, address1, address2,city, pincode, state
FROM client_master;


CREATE VIEW vw_clientadmina as
SELECT name, address1 add1, address2 add2,city, pincode, state
FROM client_master;


SELECT name, address1, address2,city, pincode, state
FROM vw_clientadmin
where city in ('Bombay', 'Delhi');

OUTPUT:

CREATE VIEW succeeded.
CREATE VIEW succeeded.

NAME ADDRESS1 ADDRESS2 CITY PINCODE STATE
--------- ---------------- --------- --------- ----------- ---------
Ivan bayross Bombay 400054 Maharastra
Basu navindgi Bombay 400056 maharastra
Ravi sreedharan Delhi 100001 Delhi
Rukmini Bombay 400050 Maharastra

4 rows selected