有没有等同于或替代以下内容?
- SELECT mix_type || ' (' || mix_num || ')' as description
- FROM acid_batch
- WHERE mix_num < 10
Oracle有没有像printf样式格式化的东西?
- SELECT printf("%s (%s)",mix_type,mix_num) as description,FROM acid_batch
- WHERE mix_num < 10