COP 6731 Theory and Implementation of Database Systems

Useful News

Self-driving cars will alter South Florida's roads. Here's how.

Tony Seba: Clean Disruption - Energy & Transportation

Sample Data Sets

click Fundamental of Database Systems BOOK

click COW BOOK

Sample SQLs

click Fundamental of Database Systems BOOK

click COW BOOK

Postgresql/Postgis Installation Guide

click here

Postgresql Command

To start SQL Command Line from the operating-system command prompt, enter the following: sqlplus

Change database

\connect postgis;

Retrieve schmea names

SELECT schema_name FROM information_schema.schemata;

Retrieve table names in public schema

SELECT table_name FROM information_schema.tables WHERE table_schema='public';

psql SQL Commands

Oracle SQL Plus Command

To start SQL Command Line from the operating-system command prompt, enter the following: sqlplus

You can also include the username and password: sqlplus username/password

The following SET commands specify the number of characters for each line in the output: SET LINESIZE 140

To view all the settings, enter the following at the SQL prompt: SHOW ALL

A SQL script file is executed with @ command. For example, you can execute a SQL script as follows: @COP6731.sql

The SPOOL command can be used to direct the output from SQL Command Line to a disk file. To start spooling the output to an operating system file, you enter the SPOOL command followed by a file name. SQL> SPOOL hw01.log

To stop spooling and close a file, enter the following: SPOOL OFF

SQL Command Line provides the DESCRIBE command to display a description of a database object. For example, the following displays the structure of the employees table: DESCRIBE employees