Answer to Question #502 in Databases | SQL | Oracle | MS Access for Julie
TYPE customer_type IS RECORD
SELECT id, first_name, last_name, address, phone INTO customer_rec.id, customer_rec.first_name, customer_rec.last_name, customer_rec.address, customer_rec.phone FROM customer;
Where customer (in "FROM customer" statement) the name of customer table.
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!