用PL/SQL Developer直接COPY SQL语句变成StringBuffer语句

在PLSQL安装目录下有SpecialCopy目录，下面有java.copy、c++.copy等等，

新增一个文件：Java4StringBuffer.copy，内容为：

;PL/SQL Developer SpecialCopy definition
;<LINE_1> for first line
;<LINE_*> for all other lines
;<LINE_N> for last line
;
#define " = \"
#define \ = \\
#define char(9) = \t
new StringBuffer("<line_1>")
.append("<line_*>")
.append("<line_n>").toString();

在PLSQL里写这么一段语句:

select o.compid, o.pcompid
  from basic_organization o
connect by prior o.compid = o.pcompid
 start with o.compid = '0000'

选择 edit--special copy--Java4StringBuffer，然后到JAVA编辑器里ctrl+v 出来