plsql怎么拼接字段？

哪種數(shù)據(jù)庫？ 如果是sqlserver: select cast(column1 as varchar(10)) + '-' + cast(column2 as varchar(10) ...) as p from table 這么一直拼就好了。 如果是oracle: select to_char(column1) || '-' || to_char(column1)|| '-' || to_char... as p from table