Wednesday, 14 September 2016

Create a Table

Here's the syntax of creating a table in SQL,

SYNTAX -
1:  create table <table_name>
2: ( column_name1 datatype(size),
3:   column_name2 datatype(size),
4:   column_name3 datatype(size),
5:   column_name4 datatype(size)); 

Example -
1:  create table student
2: ( Roll_no number(10),
3:   Name varchar2(20),
4:   Address varchar2(30),
5:   Phone_Number number(10)); 

No comments:

Post a Comment

If u need any help,