Spanning a long object name over multiple lines in a query

To continue a statement that contains a long object name on the next line, use double quotation marks.

A single SQL query line is limited to 79 bytes. When any part of an object name (the location, authorization ID, or the object name itself) is continued on a new line, that part of the name must be delimited by double quotation marks. The following figure shows an example of a long object name that spans two lines. The name is qualified with an authorization ID that also spans two lines.

Figure 1. Delimiting qualified object names that span multiple lines..

SQL QUERY                                            MODIFIED  LINE    1       
SELECT * FROM "VERY_LONG_AUTHID_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXX"."VERY_LONG_TABLE_NAME_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXX"