Hi All,
We have data in the custom data like below,
- Welcomes everyone who enters the clinic/office in a friendly, sincere and timely manner.
- Shows compassion & actively listens when interacting with others.
- Actively listens to seek understanding
When we need to display data without bullet points.
Expected Output:
------------------
Welcomes everyone who enters the clinic/office in a friendly, sincere and timely manner. Shows compassion & actively listens when interacting with others. Actively listens to seek understanding.
For ex:
----
create table xx_test456(empnum varchar2(100),gl_desc varchar2(1000))
/
insert into xx_test456
values
('123456',
'• Welcomes everyone who enters the clinic/office in a friendly, sincere and timely manner.
• Shows compassion & actively listens when interacting with others.
• Actively listens to seek understanding')
/
insert into xx_test456
values
('87980',
'• Negotiates effectively.
• Solicits feedback and handles constructive criticism in a professional manner.')
/
COMMIT
/
select * from xx_test456
Please provide inputs to display data without bullet points.
Thanks,
Visu