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 post interview email, creating a dictionary from two, how to write computer software, 2kva stablizer project write up, creating a training, how to write cv for english, what to write in jagran com,

[-]
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,243 29-07-2011, 12:15 PM
Last Post: smart paper boy
  How to create a query in Microsoft Access? smart paper boy 0 1,107 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,189 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: