Yurttas/PL/DBL/oracle/F/01/Bank/q011.sql
1REM q011.sql
2REM
3REM Find customer by any(&1) attribute from
4REM any branch('&2') who has a loan.
5REM
6REM &1(attribute) and '&2'(value) are interactive values.
7REM
8
9SELECT &1
10FROM Borrower
11WHERE branchname LIKE '&2%';