/** Return the view for Sybase. */
public static ViewDefinition oracleView() {
ViewDefinition definition = new ViewDefinition();
definition.setName("AllVehicles");
definition.setSelectClause(
"Select V.*, F.FUEL_CAP, F.FUEL_TYP, B.DESCRIP, B.DRIVER_ID, C.CDESCRIP"
+ " from VEHICLE V, FUEL_VEH F, BUS B, CAR C"
+ " where V.ID = F.ID (+) AND V.ID = B.ID (+) AND V.ID = C.ID (+)");
return definition;
}
