Write a query for creating an Updateable view.
#1

PROGRAM CODE:
create view vw_client as
select client_no, name, address1, bal_due
from client_master;

insert into vw_client values('C00110','Robert','40/2, Vinayak Nagar', 1000);

update vw_client set bal_due=12000 where client_no='C00110';

delete vw_client where client_no='C00110';

OUTPUT:
[attachment=14367]
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: how to write a marketing report, how to write a name in, 2kva stablizer project write up, creating video, health education creating strategies for school and, how to write effective driving questions for**, how to write effective driving questions for,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  What are steps involved in creating a form in Access? smart paper boy 0 1,247 29-07-2011, 12:15 PM
Last Post: smart paper boy
  How to create a query in Microsoft Access? smart paper boy 0 1,115 29-07-2011, 12:14 PM
Last Post: smart paper boy
  To write a program to print “Hello World” in CORBA. smart paper boy 0 1,991 21-07-2011, 09:52 AM
Last Post: smart paper boy
  To write a C# program to perform encryption and decryption of the given data. smart paper boy 0 1,791 21-07-2011, 09:50 AM
Last Post: smart paper boy
  To write a program in C# to perform conversion of dollars to rupees smart paper boy 0 1,767 21-07-2011, 09:48 AM
Last Post: smart paper boy
  Write a query that will accept an account no smart paper boy 0 1,095 09-07-2011, 10:50 AM
Last Post: smart paper boy
  Create a view on the Client_master table for administration department. smart paper boy 0 1,196 09-07-2011, 10:43 AM
Last Post: smart paper boy
  Write a C Program to declare an array for 2 0 floats. Accept the values from the user smart paper boy 0 1,401 20-06-2011, 11:41 AM
Last Post: smart paper boy

Forum Jump: