************
Bank Data
**************
SELECT
BANK_NAME,
HOME_COUNTRY_CODE,
TO_CHAR(START_DATE,'MM/DD/YYYY'),
TO_CHAR(END_DATE,'MM/DD/YYYY')
FROM
CE_INDEX_BANKS
WHERE BANK_NAME IN ('BANK ')
*****************
Bank Branch Data
*****************
SELECT
BANK_BRANCH_NAME,
BRANCH_NUMBER,
HOME_COUNTRY_CODE,
TO_CHAR(START_DATE,'MM/DD/YYYY'),
TO_CHAR(END_DATE,'MM/DD/YYYY'),
EFT_SWIFT_CODE
FROM
CE_INDEX_BANK_BRANCHES
WHERE BANK_BRANCH_NAME IN ('BRANCH')