如何在 Oracle 中加粗字符串的一部分?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/35453744/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to bold part of string in Oracle?
提问by ahad
I want to bold the part of string from query output in Oracle 10g. For example if I query
我想在 Oracle 10g 中将查询输出中的字符串部分加粗。例如,如果我查询
select 'Oracle'||'10g' from dual`
my desired output is following:
我想要的输出如下:
Oracle10g
甲骨文10g
Please help! Thanx in advance.
请帮忙!提前谢谢。
回答by Khalid Amin
The following example query will enclose '10g' in <b>
html tag. Then you will also need to set the 'Contains HTML tags' property of the desired field to 'Yes' in its property palette, in Reports Builder 6i.
以下示例查询将在<b>
html 标记中包含“10g” 。然后,您还需要在 Reports Builder 6i 的属性面板中将所需字段的“包含 HTML 标记”属性设置为“是”。
SELECT 'Oracle ' ||'<b>' || '10g' ||'</b>' FROM DUAL;