The following code allows you to centralise data in a column using SQL, if you declared the column to be 20 characters wide. SELECT lpad(‘ ‘,((20-length(dname))/2),’ ‘))||dname dept_name from dept
Oracle Home
For Everything Oracle and more
For Everything Oracle and more
The following code allows you to centralise data in a column using SQL, if you declared the column to be 20 characters wide. SELECT lpad(‘ ‘,((20-length(dname))/2),’ ‘))||dname dept_name from dept