update table_name set column_name='value' where column_name1='value';
delete from table_name where column_name='value';
after execution of dml statments (SUIDE):- select, update, insert into, delete, execute, merge;
ddl-> data definition language :- CADTRE (create, alter,drop,truncate,rename)
Note:- while using ddl always mention 'command object_type'
after executing dml ----> commit, rollback;
grant permission_name to username;
revoke permission_name from username;
*********** SELECT INTO ******************
declare
volume varchar2(400);
begin
select host_name into volume from v$instance;
dbms_output.put_line(volume);
end;
/
declare
variable_name datatype;
begin
select column_name into variable_name from table_name;
dbms_output.put_line(variable_name);
end;
/
or
declare
variable_name_1 datatype;
variable_name_2 datatype;
begin
select column_name into variable_name_1 from table_name;
select column_name into variable_name_2 from table_name;
dbms_output.put_line(variable_name_1||variable_name_2);
end;
/
set serverout on;
