11.2.0.4 RAC on RHEL 6: How to enter formatted text into a column so a user gets formatted text bac
I have a comma delimited file that I edit manually and load into the database via sqlldr. Our customer is asking that a new column be added to the table called COMMENTS. They want me to enter their comments into this column (varchar2(4000)) but they want to see formatted text when they query the table/column. For example they want to see:
"SR1-16:
Code values changed as of 03/23/2016
OLD NEW
Code1=value1 NewCode1=newvalue1"
etc.
I know that you can query a column and format the results to have carriage returns, tabs, etc. but is there a way to actually enter the data into the column in a formatted way, so a normal user can query the table/column and see formatted text in their results?