c-tree isql是一个交互式SQL工具，支持SQL-92标准，用于学习SQL、测试语句、数据库修改和生成报告。它提供交易处理、系统表和多种功能，如格式化输出和执行脚本。此外，还有dbload和dbdump等其他实用工具，分别用于数据库加载和导出。
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 |
最低0.47元/天 解锁文章
1997
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
