diegoolipa’s gists

diegoolipa / Coneccion Oracle jdbc

Created September 16, 2024 17:55


	package com.diego.pe.db;

	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.SQLException;
	import javax.swing.JOptionPane;

	public class Conexion {
	// Declaración de variables estáticas para la conexión

diegoolipa / EJECICIOS 2

Created September 11, 2024 18:45

	--EJERCICIO 16
	--Uso de la CLAUSULA HAVING
	SELECT apellido_paterno, count(*) AS cantidad FROM PERSONA
	GROUP BY apellido_paterno
	HAVING count(*) >= 2
	;

	--Ejercicio 17 JOINS
	--Uso de INNER JOIN
	SELECT * FROM PERSONA p

diegoolipa / EJERCICIOS

Created September 10, 2024 19:00

	-- ejercicio 01
	-- de 5 tablas usar la funcion count(*) --Contar
	SELECT * FROM PERSONA; --LISTAR TODO LOS DATOS
	SELECT
	NOMBRE,
	apellido_materno AS MATERNO,
	apellido_paterno AS PATERNO
	FROM PERSONA;
	SELECT COUNT(*) AS cantidad_persona
	FROM PERSONA;

diegoolipa / BACKUP

Created September 5, 2024 17:07

DB

	--------------------------------------------------------
	-- Archivo creado - miércoles-setiembre-04-2024
	--------------------------------------------------------
	--------------------------------------------------------
	-- DDL for Sequence SQ_PERSONA
	--------------------------------------------------------

	CREATE SEQUENCE "USUARIO_MATRICULA"."SQ_PERSONA" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 30 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
	--------------------------------------------------------
	-- DDL for Sequence SQ_PERSONA_CELULAR

diegoolipa / Crear tablas

Created September 3, 2024 19:08

Crear tablas

	-------Diego Frank------
	--Crear una nueva base de datos
	--paso 01
	ALTER SESSION SET "_ORACLE_SCRIPT" = TRUE;

	--paso 02
	CREATE USER USUARIO_MATRICULA IDENTIFIED BY "1234560"
	DEFAULT TABLESPACE "USERS"
	TEMPORARY TABLESPACE "TEMP";

diegoolipa / sql

Created September 2, 2024 17:57

Crear una base de datos y una tabla en ORACLE


	--Crear una nueva base de datos
	--paso 01
	ALTER SESSION SET "_ORACLE_SCRIPT" = TRUE;

	--paso 02
	CREATE USER USUARIO_MATRICULA IDENTIFIED BY "1234560"
	DEFAULT TABLESPACE "USERS"
	TEMPORARY TABLESPACE "TEMP";

diegoolipa / Program.cs

Created September 27, 2023 13:37

Ciclo While and Swith Case

	// See https://aka.ms/new-console-template for more information

	bool salir = false;

	while (!salir)
	{
	Console.WriteLine("==================");
	Console.WriteLine("Nombre: Diego Lipa");
	Console.WriteLine("==================");
	Console.WriteLine("Elije una opción: ");

diegoolipa / ArbolDecisionSimple.java

Created September 20, 2023 12:43

Algoritmo de Arbol Decision en Java predecir si abordar a un automovil.

	package org.example;

	import weka.classifiers.Evaluation;
	import weka.classifiers.trees.J48;
	import weka.core.*;
	import com.opencsv.CSVReader;

	import java.io.FileReader;
	import java.util.List;

diegoolipa / ArbolDecisionDesdeCSV.java

Created September 20, 2023 12:41

Algoritmo de Arbol Decision en Java ' predecir enfermedad cardiaca.

	package org.example.argoritmia;

	import weka.classifiers.trees.J48;
	import weka.core.Attribute;
	import weka.core.Instances;
	import weka.core.converters.CSVLoader;
	import weka.core.Instance;
	import weka.core.DenseInstance;

	import java.io.File;

diegoolipa / RegresionLinealSimple.java

Created September 20, 2023 12:38

Algoritmo en JAVA REGRESION LINELA SIMPLE

	import org.apache.commons.math3.analysis.function.Exp;
	import org.apache.commons.math3.fitting.WeightedObservedPoints;
	import org.apache.commons.math3.fitting.WeightedObservedPoint;
	import org.apache.commons.math3.stat.regression.SimpleRegression; // Cambiar la importación

	public class RegresionLinealSimple {
	public static void main(String[] args) {
	// Datos de entrada
	double[] years = {2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023};
	double[] saldo = {751, 795, 852, 953, 971, 1002, 1287, 1396, 1399, 1502, 1596, 2000, 2842, 3052, 3520};

Diego Frank Lipa Choque diegoolipa