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: process of blue brain for creating validating with block diagram, how to write projects, how to write a concise review, write project documentation, creating data dictionary, write interview questions, creating online auctioning system,

[-]
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,241 29-07-2011, 12:15 PM
Last Post: smart paper boy
  How to create a query in Microsoft Access? smart paper boy 0 1,106 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,988 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,787 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,766 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,086 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,188 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,395 20-06-2011, 11:41 AM
Last Post: smart paper boy

Forum Jump: