CREATE COMMAND:
used to create a basic table involves name of the table and defining its columns and each column's data type.
SYNATX:
CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);
EXAMPLE:
create table student( rno number(10),
name varchar2(25),
mark1 number(3),
mark2 number(3),
mark3 number(3),
result varchar2(10),
class varchar2(10));
used to create a basic table involves name of the table and defining its columns and each column's data type.
SYNATX:
CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);
EXAMPLE:
create table student( rno number(10),
name varchar2(25),
mark1 number(3),
mark2 number(3),
mark3 number(3),
result varchar2(10),
class varchar2(10));
No comments:
Post a Comment