Skip to content

Instantly share code, notes, and snippets.

View ivanantunes's full-sized avatar
:shipit:
while(1) {}

Ivan Antunes ivanantunes

:shipit:
while(1) {}
9 followers · 9 following
View GitHub Profile
@ivanantunes
ivanantunes / revisao_04_08_20_db2.sql
Created August 7, 2020 10:51
-- EXERCICIO - 1
/* VISAO NORMAL */
CREATE OR REPLACE VIEW filtro_func_normal AS
SELECT
FIRST_NAME AS "NOME",
LAST_NAME AS "SOBRENOME",
HIRE_DATE AS "DATA CONTRATAÇÃO",
JOB_TITLE AS "CARGO",
@ivanantunes
ivanantunes / tree.c
Created August 7, 2020 10:49
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
// Ivan Antunes - BT3007243
typedef struct stno {
int info;
struct stno *right;
struct stno *left;
@ivanantunes
ivanantunes / par_impar_primo.js
Created June 17, 2020 23:40
const arrPar = [];
const arrImpar = [];
const arrPrimo = [];
for (let i = 0; i <= 50; i++) {
if (i % 2 === 0) {
console.log('Par: ', i);
arrPar.push(i);
verificaPrimo(i);
} else {
@ivanantunes
ivanantunes / arvore-binaria.c
Created June 7, 2020 18:38
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <time.h>
// Nome: Ivan Antunes || Prontuario: BT3007243
// Nome: Mauro Cesar || Prontuario: BT3008444
// Feito em Epoca de Coronavirus (covid 19)
// Onde o semestre foi cancelado por conta do mesmo.
@ivanantunes
ivanantunes / pl-sql.sql
Created March 13, 2020 01:11
set serveroutput on;
BEGIN
DBMS_OUTPUT.PUT_LINE('Meu bloco de trabalho PL/SQL');
END;
DECLARE
a number(10,2) := 10;
b number(10,2) := 10;
c number(10,2) := 10;
@ivanantunes
ivanantunes / atividade_visao.sql
Created March 10, 2020 22:09
-- Questão 1
create or REPLACE view vw_pais as
select loc.postal_code, loc.city from HR.locations loc where loc.country_id like '%US%';
-- Questão 2
create or REPLACE view vw_empregados as
select emp.first_name as NOME, emp.last_name as SOBRENOME, job.job_title as CARGO, dep.department_name as DEPARTAMENTO
from HR.employees emp inner join HR.jobs job
@ivanantunes
ivanantunes / arvore-recursiva.c
Last active March 12, 2020 23:10
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
typedef struct stNo {
char info;
struct stNo *esquerda;
struct stNo *direita;
} tNo;
@ivanantunes
ivanantunes / arvore-char.c
Created March 4, 2020 01:39
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
typedef struct stNo {
char info;
struct stNo *esquerda;
struct stNo *direitra;
} tNo;
@ivanantunes
ivanantunes / funcionarios.sql
Last active March 3, 2020 22:30
CREATE TABLE cargo (
CAR_ID int not null,
CAR_NOME varchar(100),
CAR_SALARIO_MAX number,
CAR_DATA_INICIO DATE,
CAR_CARGO_SUPERIOR int,
PRIMARY KEY(CAR_ID),
CONSTRAINT FK_CAR_SUPERIOR FOREIGN KEY(CAR_CARGO_SUPERIOR) REFERENCES cargo(CAR_ID)
);
@ivanantunes
ivanantunes / futebol.sql
Created February 14, 2020 01:03
create table treinador(
TREINADOR_ID int not null,
TREINADOR_NOME varchar(45),
TREINADOR_SALARIO number,
primary key(TREINADOR_ID)
);
create table campeonato(
CAMPEONATO_ID int not null,
CAMPEONATO_NOME varchar(45),