Sql Plust Tutorial

Front 1

What is SQL*Plus?

Back 1

an ad-hoc query tool that is used to interface with an Oracle database system to enter SQL statements and then view the results of the execution of the statements

Front 2

Windows version of SQL*Plus is typically started by

Back 2

clicking
"Start,"
"All Programs,"
"Oracle,"
"Application Development" and
"SQL*Plus."

Front 3

clicking "Start," "All Programs," "Oracle," "Application Development" and "SQL*Plus."

Back 3

CREATE TABLE CUSTOMERS (
(customer_id INTEGER CONSTRAINT customer_pk PRIMARY KEY,
first_name VARCHAR2 (10) NOT NULL,
ast_name VARCHAR2 (10) NOT NULL,
dob DATE, phone VARCHAR2 (12) );

Front 4

DESCRIBE command will display the customers' table

Back 4

DESCRIBE customers;

Front 5

Add customer information into the Oracle database

Back 5

INSERT INTO customers (
customer_id,
first_name,
last_name,
dob,
phone ) VALUES ( 6, 'Joe', 'Black', '03-MAR-1970', '888-555-1111');

Front 6

DELETE customer information from the Oracle database

Back 6

DELETE FROM customers WHERE customer_id = 6;

Front 7

Drop the customer table from the Oracle database

Back 7

DROP TABLE customers;