How to concat dynamic column alias using || on oracle PL/SQL?
Date: Thu, 18 Nov 2021 17:31:40 +0800
Message-ID: <CABpiuuQghXEuECMRDxqfogQmT2TXePN53RHhNVvWz14R+Ta7ig_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 18 2021 - 10:31:40 CET