rponte

By design, Oracle does NOT support dirty reads AT ALL (aka READ_UNCOMMITED Isolation level)

Stackoverflow: Does oracle allow the uncommitted read option?

Tom provides a great answer to this: On Transaction Isolation Levels

The READ UNCOMMITTED isolation level allows dirty reads. Oracle Database doesn't use dirty reads, nor does it even allow them. The basic goal of a READ UNCOMMITTED isolation level is to provide a standards-based definition that allows for nonblocking reads.

...

rponte

##
# Reverting a range of commits
#
# git --pretty=oneline --abbrev-commit older_commit..newer_commit       # not includes the oldest commit
# git --pretty=oneline --abbrev-commit older_commit^..newer_commit      # includes the oldest commit
##

# just to be sure about the commits, list them
git log --pretty=oneline --abbrev-commit 1f80548^..4b293d5

rponte

Aplicando Clean Code em código PLSQL

Tech-talk semanal, no estilo hands-on, apresentado para equipe de desenvolvimento na empresa MDIAS BRANCO. O código utilizado na talk foi de uma package PL/SQL utilizada em produção.

Pre-Requisitos: O código PL/SQL deve estar coberto por testes automatizados;

Passo a Passo:

rponte

#!/bin/bash -eu
if [ -z "${LIB_ROBUST_BASH_SH:-}" ]; then
  LIB_ROBUST_BASH_SH=included

  function error {
    echo "Error:  ${1:-}"
  }

  # Check to see that we have a required binary on the path
  function require_binary {

rponte

/**
 * Para rodar, basta:
 *    1. executar este script no console da pagina;
 *    2. clicar no botão "Exportar" no inicio da página;
 *    3. apos download, abrir arquivo .csv;
 *    4. abrir arquivo no Excel;
 */
$(document).ready(function() {
  
  // cria link "exportar" no inicio da pagina

rponte

Full page logging in Postgres and Oracle (Oracle: sparse update)

The volume of undo and redo generated is only 15 MB here, including 6 MB of undo vectors. This is really optimized and this is one reason why you should update only the columns changed (and not use the default non-dynamic update of Hibernate for example).

rponte

• O(1) = O(yeah)
• O(log n) = O(nice)
• O(nlogn) = O(k-ish)
• O(n) = O(ok)
• O(n²) = O(my)
• O(2ⁿ) = O(no)
• O(n^n) = O(fuck)
• O(n!) = O(mg!)

rponte

select sess.username  as username
      ,sess.sid       as session_id
      ,sess.serial#   as session_serial
      ,sess.program   as session_program
      ,sess.server    as session_mode
      ,round(stat.value/1024/1024, 2) as "current_UGA_memory (in MB)"
  from v$session    sess
      ,v$sesstat    stat
      ,v$statname   name
  where sess.sid        = stat.sid

rponte

--
-- tabela JOB_QUEUE
--
CREATE SEQUENCE SEQ_JOB_QUEUE;

CREATE TABLE JOB_QUEUE (
	ID          NUMBER              NOT NULL ENABLE, 
	CONTENT     VARCHAR2(4000 CHAR) NOT NULL ENABLE, 
	STATUS      VARCHAR2(20   CHAR) NOT NULL ENABLE, 
	THREAD_NAME VARCHAR2(60   CHAR), 

rponte

package com.nicequestion.donatas.adf.validate;

import javax.el.ValueExpression;

import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.BeanValidator;
import javax.faces.validator.FacesValidator;
import javax.faces.validator.ValidatorException;