Inserting data into table (Bangla)
Avgiv AvR‡K wkL‡ev †Uwe‡j wKfv‡e WvUv BbmvU© Ki‡Z nq Zv m¤ú‡K©| Avgiv
cy‡e© wk‡LwQ wKfv‡e †Uwej ˆZix Ki‡Z nq| Gevi D³ †Uwe‡j wKfv‡e WvUv BbmvU© Kiv hvq Zv Rvb‡ev| hviv cye©eZx© ‡jm‡b †Uwej ‰Zix K‡ibwb Zviv wb‡b¥i w¯ŒÞ e¨envi K‡i †Uwej GmwKDGj cv‡m ‡Uwej ‰Zix K‡i wb‡Z cv‡ib|
Create table student (
SID varchar2(30),
SNAME varchar2(200) not null,
SADD varchar2(200),
SBDATE date ,
SPH varchar2(20),
SEMAIL varchar2(30),
SID varchar2(30),
SNAME varchar2(200) not null,
SADD varchar2(200),
SBDATE date ,
SPH varchar2(20),
SEMAIL varchar2(30),
Constraints pk_sid primary key (SID) );
Gevi D³ †Uwe‡j WvUv BbmvU Kivi Rb¨ BbmvU© †÷U‡g›U wjL‡ev| BbmvU© †÷U‡g‡›Ui ÷ªvKPvi wbb¥iƒc t
INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)
VALUES ("value1", "value2", ...)
÷z‡W›U †Uwe‡j WvUv BbmvU© Kivi †÷U‡g›U wbb¥iƒc n‡e,
SQL> INSERT INTO STUDENT (SID,SNAME,SADD,SBDATE,SPH,SEMAIL)
VALUES(‘0001’,’HASAN’,’01-JAN-1980’,’01984575421’,’hasan@yahoo.com‘)
Comments
Post a Comment