Friday, 8 November 2013

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