Get Started

SQL COMMANDS

Truncate Command

CONSTRAINTS

NOT NULL

SQL FUNCTIONS

STRING FUNCTION

NUMERIC FUNCTION

PL/SQL

ADVANTAGES OF PL/SQL

DATATYPES AND DECLARATION

VARIABLES AND CONSTANTS

CONTROL STATEMENTS

ITERAIVE CONTROL

CONDITIONAL CONTROL

ERROR HANDLING

OVERVIEW OF ERROR HANDLING

EXCEPTION TYPES

DATATYPES AND DECLARATION

SUBPROGRAMS

INTRODUCTION

DATABASE TRIGGERS

ERROR WITH TRIGGERS

The SQL RENAME Statement

The TRUNCATE TABLE ALTER TABLE

Syntax



   Table_Name RENAME COLUMN old_column_name TO new_column_name;

Output

create table

The column parameters specify the names of the columns of the table.