Creating Check Constraints (Bangla)

†PK K݇UªB›U †Uwej †Zix Kivi mgq mshy³ Kivi Rb¨ wbb¥wjwLZ fv‡e SQL ‡KvW wjL‡Z n‡e|

Create table student (
SID varchar2(30),
SNAME varchar2(200) not null,
SADD varchar2(200)

SAGE  number(3) CHECK (SAGE>16) ,
SBDATE date  ,
SPH varchar2(20),
SEMAIL varchar2(30));

A_ev,

Create table student (
SID varchar2(30),
SNAME varchar2(200) not null,
SADD varchar2(200)

SAGE  number(3) ,
SBDATE date  ,
SPH varchar2(20),
SEMAIL varchar2(30)

Constraint ck_sage CHECK (SAGE>16) );

‡Uwej ˆZixi c‡i  Zv‡Z †PK K݇UªB›U mshyË Kivi Rb¨ wbb¥wjwLZ fv‡e SQL ‡KvW wjL‡Z n‡e|

ALTER TABLE student ADD CONSTRAINT ck_sage CHECK (SAGE>16);