CODE EXAMPLE FOR SQL

Creating table

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

select table_name
from   user_tables
where  table_name = 'BRICKS';