I have already inserted a row without a carriage return. In my update statement, can I use the CHR(13)||CHR(10)to insert the carriage return?

    Requires Free Membership to View

    Login

CHR(10) is the newline character and CHR(13) is the carriage return character (Takes you to the beginning of the line). If you want to add it to the end of the column value you should be able to just append it: 
UPDATE my_table
SET my_column = my_column || CHR((13) || CHR(10)
WHERE . . . . .

This was first published in March 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top