Hello all 😊,
Recently I encountered a very weird issue when writing a PL/SQL procedure,
here are some screenshots from the following links:
*https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_1.png*
<https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_1.png>
*https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_2.png*
<https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_2.png>
*https://quanwenzhao.files.wordpress.com/2021/11/test_demo.png*
<https://quanwenzhao.files.wordpress.com/2021/11/test_demo.png>
*https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_3.png*
<https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_3.png>
*https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_4.png*
<https://quanwenzhao.files.wordpress.com/2021/11/pro_convert_rows_to_columns_4.png>
Yes, I know a column alias must use a double quotes for special character
because my case is the character about TIME (just including hour and
minute) like this, "10:30".
Could you help me troubleshooting it? Thanks beforehand! 🙏
Best Regards
Quanwen Zhao