oracle

Saturday, 29 April 2017

PL/SQL: Insert/update/delete Data into table

If we had to insert data into the columns then the syntax will be the same.

Syntax:

begin
insert into t1
values (3,'cc');
end;
/




Or by using Update statement In Sql :
update t1 set c2='bb' where c1=2;

Update statement in PL/SQL:
begin
update t1 set c1=33 where c1=3;
end;
/


Delete BY Using PL/SQL:
begin
delete from t1 
where c1=33;
end;
/






No comments:

Post a Comment