SQL Language (MOSC)

MOSC Banner

11.2.0.4 RAC on RHEL 6: How to enter formatted text into a column so a user gets formatted text bac

edited Oct 11, 2017 4:43PM in SQL Language (MOSC) 12 commentsAnswered ✓

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center