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