SQL: Linking Multiple Rows in Table Based on Data Chain in Select

SQL: Linking Multiple Rows in Table Based on Data Chain in Select

I'm trying to create a select statement which will return all linked rows
based on a "LINK_SEQUENCE" column. The column however, only links two rows
together. A simple query to combine the two makes perfect sense to me.
However, in the case that three or more links in the "chain" are present,
I want to make sure that all codes are returned.

How would I go about returning something similar to this when only handing
the query one of the codes involved? EX: 3245.

Not sure if it much matters in this situation, but this is for an Oracle
database. Thank you all very much!