SQL & PL/SQL :: Re-orientation Of Joined Table

I have the following, simplified, query involving 3 tables:

Table 1
ID---Student
1----Terry
2----Gilbert
3 ---Egbert
4 ---Norris

Table 2
ID--Base_ID--Base_Name
1 --F100 ------St. Vincents
3 --F102 ------AB Junior High
4 --F103 ------CD Middle School

Table 3
ID--Choice_order_ID--Secondary_Base_Choice
1---Co1-------------School A
1---Co2-------------School B
1---Co3-------------School C
2---Co1-------------School B
2---Co2-------------School A
2---Co3-------------(null)
3---Co1-------------School C
3---Co2-------------School A
3---Co3-------------School B

I use the following query:

select table1.student, table2.base_name
from table 1, table2,
where table1.id = table2.id (+)

which returns the student and the base name they attend, i.e.

Student---Base_Name
Terry-----St. Vincents
Gilbert----(null)

However, I need to also list their school Secondary_Base_Choices horizontally, in the following format,

I.e.

Student---Base_Name----Base_Choice_1---Base_Choice_2---Base_Choice_3
Terry-----St. Vincents----School A----------School B-----------School C
Gilbert----(NULL)---------'NO DATA'--------'NO DATA'----------'NO DATA'
Egbert----AB Junior H----School B----------School A-----------'NO DATA'