Table Creation Simple Example
CREATE TABLE Syntax:
CREATE TABLE TABLENAME (
field1 data_type,
field2 data_type,
...
...
fieldn data_type
)
here,
Consider
Two Fields;
1) E_ID as number
2) E_Name as varchar(20)
CREATE TABLE Example
CREATE TABLE EMPLOYEE
(
E_ID NUMBER,
E_NAME VARCHAR2(20)
);
CREATE TABLE Syntax:
CREATE TABLE TABLENAME (
field1 data_type,
field2 data_type,
...
...
fieldn data_type
)
here,
Consider
Two Fields;
1) E_ID as number
2) E_Name as varchar(20)
CREATE TABLE Example
CREATE TABLE EMPLOYEE
(
E_ID NUMBER,
E_NAME VARCHAR2(20)
);
No comments:
Post a Comment