You execute an SQL statement in interactive mode (session mode).
For information about the other options for executing SQL statements in the SQLCLI, see Executing Commands.
You are logged on to a database instance.
Enter the SQL statement <sql_statement>.
<sql_statement>
Logging on to the database instance DEMODB as user MONA with the password RED and defining the SQL mode INTERNAL
sqlcli -d DEMODB -u MONA,RED -S INTERNAL
Displaying the CNO, TITLE, FIRSTNAME, NAME, and ZIP columns of the HOTEL.CUSTOMER table:
select CNO,TITLE,FIRSTNAME,NAME,ZIP from HOTEL.CUSTOMER
CNO | TITLE | FIRSTNAME | NAME | ZIP
-------+---------+------------+------------+------
3000 | Mrs | Jenny | Porter | 10580
3100 | Mr | Peter | Brown | 48226
3200 | Company | ?
| Datasoft |
90018
3300 | Mrs | Rose | Brian | 75243
3400 | Mrs | Mary | Griffith | 20005
3500 | Mr | Martin | Randolph | 60615
3600 | Mrs | Sally | Smith | 75243
3700 | Mr | Mike | Jackson | 45211
3800 | Mrs | Rita | Doe |
97213
3900 | Mr | George | Howe | 75243
4000 | Mr | Frank | Miller | 95054
4100 | Mrs | Susan | Baker | 90018
4200 | Mr | Joseph | Peters | 92714
4300 | Company | ?
| TOOLware |
20019
4400 | Mr | Antony | Jenkins | 20903
(15 rows selected)
* Ok
See also:
For an introduction to the SQL statements available, see the SQL Tutorial. For a detailed overview of the syntax and semantics of SQL statements, see the SQL Reference Manual.