/SQL/How to increase the width of the screen in oracle

How to increase the width of the screen in oracle

When selecting data from Oracle tables, the default line width can often be shorter than the lines of
data you wish to view. This causes the text to wrap around, making it very hard to read. To avoid
this problem you can change the Oracle default settings to increase the width of the lines, using the
set command.
Eg. At the SQL*Plus command line, type:
set linesize 200 - this will change the line width to 200 characters.
You could try a few different line size settings unitl you find the size that suits you

Similar codes

12 votes157 views6 answers
Change mysql root password
SQL
17 votes145 views4 answers
Set mysql Password
SQL
14 votes144 views3 answers
SQL trim
SQL
0 vote274 views1 answer
Multiple row join
SQL
0 vote142 views1 answer
Linebreak sql
SQL
6 votes186 views2 answers
How to get last element sql
SQL
4 votes166 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote152 views1 answer
Oracle change password expiration policy
SQL
1 vote145 views1 answer
Mysql find most common value
SQL
0 vote142 views1 answer
Recover deleted data from mysql database
SQL