This mode enables you to enter long commands for several rows. SQLCLI stores multiple row commands in an internal command buffer.
You run the SQLCLI program in multiple row mode: You have the following options for activating the multiple row mode:
· Call option: sqlcli [<options>] -m
· SQLCLI Command: \mu ON
To start a new row in multiple row mode, choose Enter.
To execute the command, either close the last row either by entering a semicolon and choosing Enter or enter the command \g.
Logging on to the database instance DEMODB as user MONA with the password RED in multiple row mode:
sqlcli -d DEMODB -u MONA,RED
Entering a multiple row SQL statement:
select
*
from
HOTEL.CUSTOMER
Executing the SQL statement:
\g
See also:
Editing Commands in an External File