/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

5 votes333 views1 answer
JBDC
SQL
4 votes324 views2 answers
Convert utc to est sql
SQL
0 vote356 views1 answer
Get total and distict row diff in sql
SQL
0 vote338 views1 answer
To_date sql
SQL
0 vote342 views1 answer
Oracle remove line breaks
SQL
5 votes336 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote320 views1 answer
Call procedure in wordpress
SQL
4 votes322 views2 answers
Bulk kill mysql processlist
SQL
0 vote338 views1 answer
Get date from timestamp in mysql
SQL
2 votes318 views4 answers
How to find 2nd highest salary in mysql
SQL