how to increase the width of the screen in oracle

Solutions on MaxInterview for how to increase the width of the screen in oracle by the best coders in the world

Search
showing results for - "how to increase the width of the screen in oracle"
Sophie
03 Jan 2018
1When selecting data from Oracle tables, the default line width can often be shorter than the lines of
2data you wish to view. This causes the text to wrap around, making it very hard to read. To avoid
3this problem you can change the Oracle default settings to increase the width of the lines, using the
4set command.
5Eg. At the SQL*Plus command line, type:
6set linesize 200 - this will change the line width to 200 characters.
7You could try a few different line size settings unitl you find the size that suits you
similar questions
oracle datafile max size 32gboracle tablespace sizeoracle apex collection sizeoracle schema sizeoracle tablespace datafile max sizeset column width in sqlplusoracle allow space to useroracle db get table sizesoracle calculate statistics on partitionoracle table sizeoracle control file sizequery to find table size in oracle 12coracle size of tables in schemaoracle index size calculationget clob size oracleoracle get partition name by high valuealter table column size oracleoracle index size
queries leading to this page
how to set line width in sqlplushow to increase line size in sqlplushow to set page width in sqlhow to increase the width of the screen in oraclesql set default linesizeplsql command line increase widthhow to set width of sql plussql set row sizesqlplus set page widthoracle set linesoracle set widthset linesize in sql serverhow to increase sqlplus window sizeset linesize in sqlhow to increase the width of the screen in oracle