Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sending "\n" delimited strings to Oracle

 
Irachi Chishima
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am writing a JDBC utility and need to send multiple address lines down to a single column in Oracle using "new line" as the delimiter. When I look at the values in SQLPlus the lines are placed on separate lines but at the end of the line there is a black square. I am guessing that is the "\n" represented in SQLPlus. Anyone know a reliable way to send a new line delimited string to Oracle that will display better?
Thanks!
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
usually you don't incorporate formatting into the data that you are storing(line separators,etc.). You worry about that when you are programming. '\n' is the delimiter in a lot of languages but that may change if you have to change languages. Then '\n' would be unwanted characters in the database. What programmers traditionally do is to have several address line columns in the database(address1, address2,...) then format them accordingly in your program. Is this possible for you?
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic