WITH NO ADVANCING
clause prints the text without appending newline character(s)DELIMITED BY SPACE
are printed by converting them to strings and trimming empty spaces from both sidesDELIMITED BY SIZE
are printed by converting them to strings of fixed size corresponding to their defined (identifiers) or inferred (literals) typeDELIMITED BY Literal
are printed up to the first occurrence of the substring expressed by the literal