Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

Sample of Update~Delete with OUTPUT clause (2016 >)

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 1, rows affected: 10, absolute service time: 0,17 sec 
edit mode |  history  | discussion
   -- comment
1 -- CUSTOMERS table loaded...
   cust_id cust_name cust_address cust_city cust_state cust_zip cust_country cust_contact cust_email
1 10001 Coyote Inc. 200 Maple Lane Detroit MI 44444 USA Y Lee ylee@coyote.com
2 10002 Mouse House 333 Fromage Lane Columbus OH 43333 USA Jerry Mouse NULL
3 10003 Wascals 1 Sunny Place Muncie IN 42222 USA Jim Jones rabbit@wascally.com
4 10004 Yosemite Place 829 Riverside Drive Phoenix AZ 88888 USA Y Sam sam@yosemite.com
5 10005 E Fudd 4545 53rd Street Chicago IL 54545 USA E Fudd NULL