3. SQL LANGUAGES
Data Definition Language (DDL) Commands
• CREATE
• ALTER
• TRUNCATE
• DROP
• RENAME
Data Manipulation Languages(DML) Commands
• INSERT
• UPDATE
• DELETE
Data Query Language / Retrieval Language
• SELECT
Transaction Control Languages(TCL) Commands
• ROLLBACK
• COMMIT
• SAVEPOINT
Data Control Languages(DCL) Commands
• GRANT
• REVOKE
CREATE TABLE RC_INWARD
(
ID NUMBER GENERATED BY DEFAULT AS IDENTITY,
CONTRACT_NO NUMBER ,
CUSTOMER_NAME VARCHAR2(50) ,
RC_NO NUMBER(36),
RC_TYPE VARCHAR2(6) ,
RC_RECEIPT_DATE TIMESTAMP(6),
VEHICLE_TYPE VARCHAR(8),
CHASSIS_NO NUMBER,
RC_GIVEN_BY VARCHAR2(10),
ISSUED_DATE DATE DEFAULT SYSDATE NOT NULL ,
SIGNATURE VARCHAR2(10),
REMARK VARCHAR2(10),
BRANCH_NAME VARCHAR2(10)
);
2. CREATE TABLE FROM ANOTHER TABLE:
a) Using columns b) With data c) Withought data
CREATE TABLE new_table
AS (SELECT * FROM old_table);