Is it safe to add a new line charactor (\n) in the sql query?
<pre><code>StringBuilder sql = new StringBuilder();

        sql.append("SELECT C.ID,\n" +
                "    CODE\n" +
                "  FROM DB.TEATABLE C\n" +
                "  LEFT JOIN\n" +
                "    (SELECT IT.TEA,\n" +
                "      IT.COFFEETYPE,\n" +
                "      XREF.AUSTIN_COFFEE_LEAF_CODE AS LEAFCODE\n" +
                "    FROM DB.COFFEE_AUSTIN_XREF XREF,\n" +
                "      DB.INDIAPLAN TP,\n" +
                "      DB.COFFEE IT,\n" +
                "      DB.TEATABLE C\n" +
                "    WHERE C.ID            = IT.TEA\n" +
                "    AND IT.COFFEETYPE  = 'RIL'\n" +
                "    AND IT.INDIAPLANID   =TP.ID");
con     = getConnection();
pstmt   = con.prepareStatement(sql.toString());
rs      = pstmt.executeQuery();
</code></pre>

<p>We used to add new line charactor as above. Is it safe to add <code>\n</code> character in the query (in Oracle)? </p>