 Related Questions Latest Answer : A transaction is a UNIT of work. It contains a set of tasks to be completed as a SINGULAR UNIT of work. ... Transaction is logical unit between two commits and commit and rollback. Latest Answer : A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user. ... SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed. Latest Answer : savepoint is used to give some break points between multiple transactions so that if some transaction is required to be rolledback then some of transaction will still available in buffer. commit will save the data and remove all savepoints ... List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns: Latest Answer : Hi, One of the solution is as follow: select cust.customer_id,fname,mname,lname,e_mail,credit.tot_credit+coupan.tot_coup no_of_recharge,credit.tot_credit_val+coupan.tot_coup_val tot_recharging,tot_trans,credit.tot_credit_val+coupan.tot_coup_val-current_balance ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
