Pictures of chickens, flowers, wheat, a boy looking through a magnifying glass, irrigation pipe, soybean pods, and fruits and vegetables.		Cooperative Extension Service
Cooperative Extension Service		Agricultural Experiment Station
Steve Rea's Oracle Tips, Tricks, and Scripts		Search | Publications | Jobs | Personnel Directory | Links

Adding Line Feeds To Select Statement Output

To put line feeds in the results from a select statement, so that you can produce several lines of text split where you want them, use chr(10) where you want the line split to occur, such as:

select 'first line contents' || chr(10) || 'second line contents' from dual;

If you need an exact number of characters per line, padded on the right with blanks, use rpad:

select rpad('first line contents',80) || chr(10) || rpad('second line contents',80) from dual;

This Page was Last Updated on 06/04/07

You Are Visitor Number

© 2006 University of Arkansas Division of Agriculture All rights reserved. Last Date Modified 02/09/2008 Webmaster
	University of Arkansas • Division of Agriculture Cooperative Extension Service 2301 South University Avenue Little Rock, Arkansas 72204 • USA Phone (501) 671-2000 • Fax (501) 671-2209	Mission • Disclaimer • EEO • Privacy • FOI