Des codes SQL sous sqlplus

• ADD COLUMN:

alter table sales add tax_code varchar2(20) default 'XX' not null;

• DROP COLUMN:

alter table
   soins_amb
drop column
   MOTIF;  -- drop one column

alter table
   table_name
drop
   (col_name1, col_name2);  -- drop many columns

• RENAME COLUMN:

ALTER TABLE requisition RENAME COLUMN "MOTIF" TO "MOTIF_ANNULE";

• GRANT:

grant dba to finance;
grant resource to finance;

• Retourne le nom d'hôte distant à partir de l'adresse IP:

SQL> SELECT utl_inaddr.get_host_name('X.X.X.X') HOST_NAME FROM dual;