CODE EXAMPLE FOR SQL

create-table

create table bricks (
  colour varchar2(10),
  shape varchar2(10)
);

select table_name
from   user_tables
where  table_name = 'BRICKS';