|
Example # 1
CREATE
TABLE employee
( EmpID number (10) primary key,
Emp_Name varchar2(30) NOT NULL,
Emp_Sal number (10) NOT NULL )
Fig.
1.10
Description:
-
The create table statement
(as shown in figure 1.10)
creates a table based on the column definitions
-
One or more constraints
can be assigned to a column or to the entire table
-
Each column must have a
unique name and must be assigned a data type
MySQL
Create Table employee
(EID char(20) primary key, E_Name char(30),E_Designation
char(30),E_Address char(30))type=innodb;
ORACLE - PL/SQL
Database - SQL* PLUS - Primay key (1 column)
Database - SQL* PLUS - Crete TABLE
Database - SQL* PLUS - For Loops
Database - SQL* PLUS - Primary key (two-column)
Oracle PL/SQL - Procedures
Database - SQL* PLUS - Simple Loop
Database - SQL* PLUS - While Loops
|
