Slide #1
Created 2/7/2000
Loading...
Slide #2
Created 2/7/2000
Loading...
Slide #3
Created 2/7/2000
Loading...
Slide #4
Created 2/7/2000
Loading...
Slide #5
Created 2/7/2000
Loading...
Slide #6
Created 2/7/2000
Loading...
Slide #7
Created 2/7/2000
Loading...
Slide #8
Created 2/7/2000
Loading...
Slide #9
Created 2/7/2000
Loading...
Slide #10
Created 2/7/2000
Loading...
Slide #11
Created 2/7/2000
Loading...
Slide #12
Created 2/7/2000
Loading...
Slide #13
Created 2/7/2000
Loading...
Slide #14
Created 2/7/2000
Loading...
Slide #15
Created 2/7/2000
Loading...
Slide #16
Created 2/7/2000
Loading...
Slide #17
Created 2/7/2000
Loading...
Slide #18
Created 2/7/2000
Loading...
Slide #19
Created 2/7/2000
Loading...
Slide #20
Created 2/7/2000
Loading...
Presentation from teacher.buet.ac.bd
Author:
Marilyn Turnamian
Company:
Lucent Technologies
Created:
2/7/2000 7:26:30 PM
>
Share this presentation
|
Advanced SQL Features (cont’d)Merge construct allows batch processing of updates.
Example: relation funds_received (account_number, amount ) has batch of deposits to be added to the proper account in the account relation
merge into account as A using (select * from funds_received as F ) on (A.account_number = F.account_number ) when matched then update set balance = balance + F.amount
Copy the following code to your webpage or blog to embed this presentation:
<a href="http://www.slidefinder.net/a/advanced_sql_features_cont/32085500" class="slidefinder">5. Advanced SQL</a>
<script type="text/javascript" src="http://www.slidefinder.net/scripts/embedded.js"></script>
<a href="http://www.slidefinder.net/a/advanced_sql_features_cont/32085500" class="slidefinder">5. Advanced SQL</a>
Det3
<script type="text/javascript" src="http://www.slidefinder.net/scripts/embedded.js"></script>
Share this presentation:
Comments