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;