HOW TO WRITE CREATE STATEMENT IN ORACLE SQL

1.CREATE: Creating the tables with column names.

SYNATAX: Create table <table_name>(col1 datatype1, col2 datatype2……coln datatypen);

Ex: create table student (no number (2), name varchar (10), marks number (3));

Output:  For checking the output we are going to write the select statement. (select * from student;)

NO

NAME

MARKS