Learn R Programming

sqlutils (version 1.2)

isql: Interactive SQL session.

Description

This function will start an interactive SQL session. The user can enter SQL statements and execute them against the given database connection. This was initially developed as a teaching tool for learning SQL.

Usage

isql(conn, sql = character(), envir = baseenv(), ...)

Arguments

conn
a database connection.
sql
initial SQL statement.
envir
the environment to save data frames when executing save.
...
other parameters passed to sqlexec.

Value

returns a list containing two character vectors, one with a history of commands and another with a history of SQL statements.