How to display table data more clearly in oracle sqlplus
If you mean you want to see them like this:
WORKPLACEID NAME ADDRESS TELEPHONE----------- ---------- -------------- --------- 1 HSBC Nugegoda Road 43434 2 HNB Bank Colombo Road 223423
then in SQL Plus you can set the column widths like this (for example):
column name format a10column address format a20column telephone format 999999999
You can also specify the line size and page size if necessary like this:
set linesize 100 pagesize 50
You do this by typing those commands into SQL Plus before running the query. Or you can put these commands and the query into a script file e.g. myscript.sql and run that. For example:
column name format a10column address format a20column telephone format 999999999select name, address, telephonefrom mytable;
You can set the line size as per the width of the window and set wrap off using the following command.
set linesize 160;set wrap off;
I have used 160 as per my preference you can set it to somewhere between 100 - 200
and setting wrap will not your data and it will display the data properly.