Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To store data as paragragh

662043Oct 1 2010 — edited Oct 1 2010
Hello,

Is it possible to store in db(oracle 9i) a volume of data split into paragraphs as it is?Also, would I be able to retrive it with a select query in the same format that i stored it too.
Ex:
If this is the data,

Hence Burgundy, Claret, and Port,
Away with old Hock and madeira,
Too earthly ye are for my sport;
There's a beverage brighter and clearer.

Instead of a piriful rummer,
My wine overbrims a whole summer;
My bowl is the sky,
And I drink at my eye.

I want to store this in tha database such that when i retrieve it,I get to display this as above.

Thanks in advance!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2010
Added on Oct 1 2010
4 comments
324 views