select
CUSTOMER_ID,
CUST_FIRST_NAME,
CUST_LAST_NAME,
CUST_STREET_ADDRESS1,
CUST_STREET_ADDRESS2,
CUST_CITY,
CUST_STATE,
CUST_POSTAL_CODE,
PHONE_NUMBER1,
PHONE_NUMBER2,
CREDIT_LIMIT,
CUST_EMAIL,
NLS_TERRITORY,
ACCOUNT_MGR_ID,
LAST_MODIFIED_ON,
LAST_MODIFIED_BY
from DEMO_CUSTOMERS
select CUST_STREET_ADDRESS1 from DEMO_CUSTOMERS where CUSTOMER_ID = :P9_CUSTOMER_ID;