I guess with this idea, the user would have to type in '<br>' every time you want a line break. And on the data entry page, in that particular field, you'd see the '<br>'. Unless there was a way / process to replace all line break characters (which I think is /n....I think..or that represents an end line. I forget, I'd have to look it up again) with '<br>'.
Thanks for your input though.
Well, yes, you can, for sure do that. I don't think it is as hard as you think. The most fool proof way, and the way that will require the least effort on your part, is to do it via a table trigger.
Assume your table is named MY_TABLE and the column into which you want to to this is named DESCRIPTION.
CREATE OR REPLACE TRIGGER TR_SET_HTML_LINE_BREAKS
ON MY_TABLE REFERENCING NEW AS new OLD AS old
FOR EACH ROW
CRLF CONSTANT CHAR(2) := Chr(13) || Chr(10);
:new.DESCRIPTION = Replace( :new.DESCRIPTION, CRLF, '<BR>' );
:new.DESCRIPTION = Replace( :new.DESCRIPTION, Chr(13), '<BR>' );
:new.DESCRIPTION = Replace( :new.DESCRIPTION, Chr(10), '<BR>' );