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 seminar, how to write a simple project report, how to write quesionyar on biscuits product, what i write in jagran com in yuvasampadak, creating the school sample, creating a cname, i want to write essay on drought in hindi,

[-]
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,225 29-07-2011, 12:15 PM
Last Post: smart paper boy
  How to create a query in Microsoft Access? smart paper boy 0 1,099 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,977 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,767 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,733 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,080 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,180 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,376 20-06-2011, 11:41 AM
Last Post: smart paper boy

Forum Jump: