SQL*Plus environment variables are set to default values when SQL*Plus is started. State three ways by which users can change the default setting.

What will be an ideal response?


Users can change the default setting in three ways (use SET command):
? Interactively by resetting each variable;
? Write all commands in a script file and run the file each time the user wishes to
change the setting;
? Write all commands in the file login.sql. The file must be stored in the current
directory (folder) of SQL*Plus.

Computer Science & Information Technology

You might also like to view...

The statement that raises an exception is sometimes called the ___________ of the excep- tion.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

InDesign is a page layout software program used to design and produce documents that can be printed or used on the web.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

All colors can be represented using ____________________ codes, which is a value based on the three basic colors used on computer monitors-red, green, and blue (RGB).

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The number of lines needed to connect the nodes in a network is always equal to the number of nodes, minus one.

Answer the following statement(s) true (T) or false (F)

Computer Science & Information Technology