DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format, column, width
|
|
|
format, row, heigh
|
|
|
format, column, autoselection
|
|
|
format, row, autoselection
|
Detailed explanation-1: -In generic terms, you use the ALTER TABLE command followed by the table name, then the MODIFY command followed by the column name and new type and size. Here is an example: ALTER TABLE tablename MODIFY columnname VARCHAR(20); The maximum width of the column is determined by the number in parentheses.
Detailed explanation-2: -You can change the displayed width of a datatype or DATE, by using the COLUMN command with a format model consisting of the letter A (for alphanumeric) followed by a number representing the width of the column in characters. If you specify a width shorter than the column heading, SQL*Plus truncates the heading.
Detailed explanation-3: -right-click in the sqlplus window. select properties->layout. increase screen buffer size width to 1000.