JRGGRoberto

/*
 Este programa serve para importar do Oracle para o MySQL
 A base de dados e tabelas do lado que receberá a importação já deverá existir
 Este Não! verifica se o registro, não evita duplicações 
 */

package basededasosnofiltro;

import java.sql.Connection;
import java.sql.DriverManager;

JRGGRoberto

DELIMITER $$

DROP PROCEDURE IF EXISTS teste $$
CREATE PROCEDURE teste()
BEGIN
    DECLARE v_finished INTEGER DEFAULT 0;
	--Declara??o das variaveis
    DECLARE v_email varchar(100) DEFAULT "";
    DECLARE v_fone varchar(100) DEFAULT "";

JRGGRoberto

DROP PROCEDURE IF EXISTS vtigercrm540.hierarquia;
CREATE PROCEDURE vtigercrm540.hierarquia()
BEGIN
    DECLARE v_finished INTEGER DEFAULT 0;

    DECLARE v_filho int;
    DECLARE v_pai  int;

    DEClARE cur CURSOR FOR
       select 

JRGGRoberto

--criação do database
CREATE DATABASE Teste DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;  

USE Teste;

--criação de uma tabela de teste
CREATE TABLE `nomes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)

JRGGRoberto

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package ltn_cot;

import java.sql.Connection;
import java.sql.DriverManager;

JRGGRoberto

create or replace procedure tofilejrgg(id integer) as
  l_file    UTL_FILE.FILE_TYPE;
  l_clob    CLOB;
  l_buffer  VARCHAR2(32767);
  l_amount  BINARY_INTEGER := 32767;
  l_pos     INTEGER := 1;
  l_filename varchar2(30);
  JRGG varchar2(32767);
BEGIN
  SELECT attach_content_bytes, attach_filename

JRGGRoberto

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package extractclob;

import java.io.File;
import java.io.FileWriter;
import java.io.Reader;

JRGGRoberto

import java.util.Scanner;

public class ordena {

	public static void main(String[] args) {
		int[] num = new int[3];
		Scanner key = new Scanner(System.in);
		System.out.print("N1:");
		num[0] = key.nextInt();
		System.out.print("N2:");

JRGGRoberto

import java.util.Scanner;

public class CiclosArraysInversao {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Scanner key = new Scanner(System.in);
		
		System.out.print("Qntos n quer inserir? ");
		int qntnum = key.nextInt();

JRGGRoberto

select
	t.ticketid, t.st,   greatest(t.modifiedtime, ifnull(a.dt, t.modifiedtime), ifnull(c.dt,t.modifiedtime)) dt,
	t.tec, t.title,	
	TIMESTAMPDIFF( day, greatest(t.modifiedtime, ifnull(a.dt, t.modifiedtime), ifnull(c.dt,t.modifiedtime)), NOW() ) diasabando
from
	tksabc2 t
 	left join atividades a on a.tk = t.ticketid
	left join comments c   on c.related_to = t.ticketid
group by 1, 2	
order by 1, 2;