OracleCatalog's sql statement of SELECT_COLUMNS_SQL_TEMPLATE have some issue when the column‘s type is NVARCHAR2 or NCHAR, the length of column should get the cols.char_col_decl_length. so the sql ...

-- Your task is to use a select statement to return a single column table containing the full title of the person (concatenate all columns together except id), as follows: ...