09-07-2011, 10:43 AM
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