68 231
Assignments Done
99%
Successfully Done
In November 2018

Answer to Question #502 in Databases | SQL | Oracle | MS Access for Julie

Question #502
Create a list to display customer name, phone, address using PL/SQL.
Expert's answer
We can't explain it without you give us a database structure. But we think it can be done using PL/SQL records (more details on http://plsql-tutorial.com/plsql-records.htm). It would be looks like following code:
DECLARE
TYPE customer_type IS RECORD
(customer_id number(5),
customer_first_name varchar2(25),
customer_last_name varchar2(25),
customer_address varchar2(64),
customer_phone varchar(15));
customer_rec customer_type;
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!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions