SQL & PL/SQL

CREATE TABLE BORROWER
(
NAME VARCHAR2(15 BYTE),
TOOLS TOOLS_NT, --nested table
TOTAL_DEBT NUMBER(7)
)


select b.name, nt.name, b.total_debt from borrower b, table(tools) nt where nt.cost is not null;

result set of the above query

NAME NAME_1 TOTAL_DEBT

ROHIT D 800
ROHIT A 800
ROHIT C 800
AKSHAY C 300

i want to change the NAME_1 value 'C' to 'CC'.
please suggest.