Answer to Question #502 in Databases | SQL | Oracle | MS Access for Julie
Create a list to display customer name, phone, address using PL/SQL.
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.