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.
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 orderand get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!
Comments
Leave a comment