Aula Banco 15/08

query.sql

create table rm78227_table(
    data_da_aula       date,
    assunto_da_aula    varchar2(255),
    resumo             varchar2(255),
    github_repo        varchar2(255) default 'www.github.com/vitorpiovezam/fiap-projects/4semestre/database'
)

comment on column rm78227_table.assunto_da_aula is "HEADLINE";
comment on column rm78227_table.resumo is "textos e anotações";


select * from rm78227_table;
drop table rm78227_table;
describe  rm78227_table;
delete from rm78227_table;



-- insert
insert into rm78227_table (data_da_aula,assunto_da_aula,resumo,github_repo)
values
('15/08/2018','ALTER TABLES, ADD/DROP/MODIFY','Maded a Gist from class','https://gist.github.com/vitorpiovezam/14a0aeee92bfba9763a61669fe9d4faf');