Seminar & Projects
Home
Members
Team
Help
Search
Register
Login
Home
Members
Help
Search
Seminar Topics & Project Ideas On Computer Science Electronics Electrical Mechanical Engineering Civil MBA Medicine Nursing Science Physics Mathematics Chemistry ppt pdf doc presentation downloads and Abstract
Academic
Study guide
Technical
Write a query for creating an Updateable view.
New Reply
0 Vote(s) - 0 Average
Write a query for creating an Updateable view.
smart paper boy
Offline
Active In SP
Posts:
2,053
Threads:
0
Joined:
Jun 2011
Reputation:
0
#1
25-08-2017, 09:32 PM
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:
«
Next Oldest
|
Next Newest
»
Quick Reply
Message
Type your reply to this message here.
Disable Smilies
You have selected one or more posts to quote.
Quote these posts now
or
deselect them
.
Possibly Related Threads…
Thread
Author
Replies
Views
Last Post
To write a program in C# to perform conversion of dollars to rupees
smart paper boy
1
121,768
02-05-2013, 10:40 AM
Last Post
: Guest
What are steps involved in creating a form in Access?
smart paper boy
0
75,314
29-07-2011, 12:15 PM
Last Post
:
smart paper boy
How to create a query in Microsoft Access?
smart paper boy
0
69,358
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
45,309
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
55,972
21-07-2011, 09:50 AM
Last Post
:
smart paper boy
Write a query that will accept an account no
smart paper boy
0
35,833
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
66,199
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
164,870
20-06-2011, 11:41 AM
Last Post
:
smart paper boy
View a Printable Version
Subscribe to this thread
Linear Mode
Threaded Mode