What is Table in SQL and Syntax
A relational database system contains one or more objects called tables.
The data or information for the database are stored in these tables.
Syntax :
Create table tablename
(
rowname and data types
col1 is row name
varchar2(10) is data types.
);
example :
Create table Employee
(
Employe_id varchar2(10) not null,
First_Name varchar2(10) not null,
Middle_Name varchar2(10) not null,
Lost_Name varchar2(10) not null
) ;
Please write the select statement.
select * form Employee
Result :-
| Employe_id | First_Name | Middle_Name | Lost_Name|
the result will look above .
No comments:
Post a Comment