Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Create a view on the Client_master table for administration department.
#1

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
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: project topic for master of hospital administration in hospital operations department, table view for college time table, administration police payslip view, kenya administration police payslip administration police, construction of topology table and routing table and routing table using bfs in manet routingppt, how to create routing table based on topological table and distance using bfs in manet ppt, administration police department payslips in kenya,

Forum Jump:


Users browsing this thread: 1 Guest(s)