This content has been marked as final. Show 3 replies
you can use.. TERMINATED BY WHITESPACE
According to Oracle doc, "If TERMINATED BY WHITESPACE is specified, data is read until the first occurrence of a whitespace character (space, tab, newline). Then the current position is advanced until no more adjacent whitespace characters are found. "..
FIELDS TERMINATED BY WHITESPACE