Create a list to display customer name, phone, address using PL/SQL.
1
Expert's answer
2010-07-27T12:40:44-0400
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 https://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.
Comments