DDL, DML, TCL and lots more

 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;