1
0

I have SQL Statement embedded in Java code (see below). How can I format these statements.

StringBuffer SQL = new StringBuffer();
SQL.append(„SELECT  „);
SQL.append(“    price.col1      AS col1  „);
SQL.append(“  , price.col2      AS col2  „);
SQL.append(“  , price.col3      AS col3  „);
SQL.append(„FROM table_1           t1  „);
SQL.append(“  , table_2            t2 „);
SQL.append(„WHERE col1           = col2 „);
SQL.append(“    AND column_1     = small_column „);
SQL.append(“    AND column_3411 <= column_12_sup „);
SQL.append(“    and col1         = ‚Test Run‘ „);
SQL.append(“    AND column_4532  = c1.dert „);

  • You must to post comments
0
0

Please check the option „SQL is copied out of Program code“

and set the „SQL is encloded between“ field to

 

 

  • You must to post comments
Showing 1 result
Your Answer
Post as a guest by filling out the fields below or if you already have an account.
Name*
E-mail*
Website