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;
No. | Subject | Author | Date | Views |
---|---|---|---|---|
6 | DATE -> DAY CONVERT SQL | admin | 2023.05.25 | 38 |
5 | ORACLE COLLECTION | admin | 2023.05.08 | 38 |
4 | Monthly SUM | admin | 2023.05.22 | 37 |
3 | INNER JOIN | admin | 2023.05.19 | 37 |
2 | TEST | admin | 2023.05.03 | 36 |
1 | YEAR EXPRESSIONS | admin | 2023.05.25 | 34 |