select vendor_name, segment1, decode(hold_flag, 'Y', '*', null), num_1099, vat_registration_num, vendor_id from po_suppliers_val_v order by upper(vendor_name)
如上:我想得到字段vendor_name,segment1,hold_flag,num_1099,vat_registration_num,vendor_id,vendor_name 如何截取,请各位高手帮忙!!!!
如上:我想得到字段vendor_name,segment1,hold_flag,num_1099,vat_registration_num,vendor_id,vendor_name 如何截取,请各位高手帮忙!!!!
不知道那2个类是不是你要求的
str = str.substring(0,str.indexOf(" from ")).trim();
String[] items = str.split(",");
String[] str2 = str1[1].split(",");