![]() Related Questions How to decrypt the password on oracle 8/8i in system/scott user?what is the query fired to see the password? Read Answers (2) | Asked by : Ashish Latest Answer : SELECT 'GRANT ' ||privilege ||' ON '||table_schema||'.'||table_name ||' TO '||USER ||' ;' FROM ALL_TAB_PRIVSWHERE grantee ='TILITS' -- user name that has already access ... 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 ... In which section of a PL/SQL block is a user defined exception waste? Latest Answer : In exception block ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||