4. c-tree isql utility
Interactive SQL (often referred to throughout this manual as ISQL) is a utility supplied with ctreeSQL that lets you issue SQL statements directly from a terminal and see results displayed at the terminal. You can use interactive SQL to:
l Learn how SQL statements work
l Test and prototype SQL statements to be embedded in programs
l Modify an existing database with data definition statements
l Perform ad-hoc queries and generate formatted reports with special ISQL formatting statements
4.1. SQL-92 Standard support
4.1.1. iSQL supports SQL-92 standard
1) iSQL command Options:
Graph 4.1.1 .1
2) Create a table
Type the following commands to create a table:
CREATE TABLE EMPLOYEE ( EMPID INT, FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30), MALE VARCHAR(10), AGE SMALLINT, BIRTH TIMESTAMP, NOTE VARCHAR(200), DEPARTMENTID INT, PRIMARY KEY(EMPID) );
CREATE TABLE DEPARTMENT |