Skip to content

Instantly share code, notes, and snippets.

View ivanelson's full-sized avatar

Ivanelson Nunes ivanelson

8 followers · 4 following
  • Teresina, PI - BR
View GitHub Profile
@ivanelson
ivanelson / celsius.c
Created December 15, 2018 14:36
Calcula temperatura de celsius para fahrenheit
#include <stdio.h>
#include <stdlib.h>
/*
F=1,8C + 32
*/
void main() {
float soma=0;
int valorInicial, valorFinal, contador;
printf("Digite o valor da temperatura inicial: \n");
@ivanelson
ivanelson / vetor-notas.c
Created December 15, 2018 03:02
vetor em "C"
#include <stdio.h>
#include <stdlib.h>
int main () {
float notas[10];
int indice;
printf("Lendo as notas:\n");
for (indice = 0; indice < 10; indice++)
{
@ivanelson
ivanelson / do-while-media.c
Created December 14, 2018 22:35
media com do-while in "C"
#include <stdio.h>
#include <stdlib.h>
void main() {
float nota, soma = 0, media;
int resp, contador = 0;
do {
printf("Digita a nota: ");
scanf("%f", &nota);
@ivanelson
ivanelson / quadrado-while.c
Created December 14, 2018 22:08
Quadrado de um número em "C"
#include <stdio.h>
#include <stdlib.h>
int main () {
/* declaracoes */
int num; /* variavel utilizada para leitura da sequencia */
int quad;
/* programa */
printf("Digite uma sequencia terminada por zero\n");
@ivanelson
ivanelson / celsius-to-fahrenheit.c
Created December 14, 2018 14:42
Convert Celsius to Fahrenheit in "C"
#include <stdio.h>
#include <stdlib.h>
/*
F=1,8C + 32
*/
void main() {
float soma=0;
int valorInicial, valorFinal, contador;
printf("Digite o valor da temperatura inicial: \n");
@ivanelson
ivanelson / forloop.c
Created December 14, 2018 14:14
For loop in "C"
#include <stdio.h>
#include <stdlib.h>
void main() {
float nota, soma=0, media;
int conta;
for (conta = 0; conta <= 9; conta++) {
printf("Digite a nota: ");
scanf("%f", &nota);
@ivanelson
ivanelson / if-aninhado.c
Last active December 13, 2018 22:06
if's aninhados em C
void main() {
float salario;
char temFilhos;
printf("Digite o salario atual do funcionario: ");
scanf("%f", &salario);
printf("\nVoce possui Filhos? Digite 'S' ou 'N': ");
scanf(" %c", &temFilhos);
@ivanelson
ivanelson / media.c
Created December 11, 2018 19:04
Recebe 3 notas e calcula média de 04 alunos
#include <stdio.h>
#include <stdlib.h>
int main(void) {
// declaração de variáveis
int contador;
float nota1, nota2, nota3, media;
for (contador = 0; contador < 3; contador ++) {
@ivanelson
ivanelson / 3E5.c
Created November 28, 2018 21:24
3E5 - Divisível por 3 e 4
#include<stdio.h>
#include<math.h>
int main()
{
int numero;
printf("Entre com um numero inteiro: ");
scanf("%d",&numero);
if (((numero % 3)==0) && ((numero % 5)==0)){
@ivanelson
ivanelson / well.sql
Created August 10, 2018 12:28
add contrainst unique table already exists
ALTER TABLE dbatez.rec_filial drop COLUMN pk_rec_filial;
ALTER TABLE dbatez.rec_filial ADD COLUMN pk_rec_filial bigserial UNIQUE;
ALTER TABLE dbatez.rec_filial ALTER COLUMN pk_rec_filial SET NOT NULL;
ALTER TABLE dbatez.rec_filial ALTER COLUMN pk_rec_filial SET DEFAULT nextval('dbatez.rec_filial_pk_rec_filial_seq'::regclass);
update dbatez.REC_FILIAL set pk_rec_filial = pk_rec_filial;
-- passar o ultimo elementro da sequence
select max(pk_rec_filial) from dbatez.rec_filial;