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.
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments