The following code allows you to centralise data in a column, 
if you declared the column to be 20 characters wide.


SELECT lpad(' ',((20-length(dname))/2),' '))||dname dept_name from dept