Skip to content

Instantly share code, notes, and snippets.

View arbo-hacker's full-sized avatar

Alejandro Barreto arbo-hacker

23 followers · 48 following
View GitHub Profile
@arbo-hacker
arbo-hacker / validation-loadsales-rms.sql
Last active February 22, 2016 20:54
Verificar si una venta se cargo en RMS cuando el JOB POSUPLD queda en status ABORTED
-- To verify if a POSU file was successfully loaded even though the job "POSUPLD.PC" culminates in ABORTED, without errors or rejected items, verify the following query at the time it aborts:
select * from tran_data
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
and pgm_name='posupld';
-- To verify the day after the batch
select * from if_tran_data
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
@arbo-hacker
arbo-hacker / auto_increment-oracle.sql
Last active February 19, 2016 13:34
Auto_increment en Oracle 12c
CREATE SEQUENCE dept_seq;
CREATE TABLE departments (
ID NUMBER(10) NOT NULL,
DESCRIPTION VARCHAR2(50) NOT NULL);
CREATE OR REPLACE TRIGGER dept_bir
BEFORE INSERT ON departments
FOR EACH ROW
@arbo-hacker
arbo-hacker / ejemplo-with-oracle12c.sql
Last active February 19, 2016 05:34
Clausula With | Novedades Oracle 12c
-- Para leer explicación ir a http://arbo.com.ve/2016/02/19/sentencia-with-novedades-oracle-12c/
WITH
FUNCTION sumar(valor1 in number, valor2 in number) RETURN number IS
BEGIN
RETURN valor1 + valor2;
END;
SELECT sumar(a,b) suma from (
SELECT 23 a, 51 b from dual
UNION ALL
SELECT 87 a, 21 b from dual
@arbo-hacker
arbo-hacker / comparacion-ventas-vs-inventario.sql
Created February 5, 2016 02:17
Como validar si se realizaron las rebajas de inventario de todos los artículos que se vendieron / devolvieron en el día en Oracle Retail (RESA vs RMS)
WITH
RESA AS
(
SELECT STD.BUSINESS_DATE FECHA,STD.STORE STORE,COUNT(DISTINCT STI.ITEM) ITEMS, SUM(STI.QTY) UNIDADES
FROM SA_TRAN_ITEM STI
JOIN SA_TRAN_HEAD STH
ON (STI.TRAN_SEQ_NO = STH.TRAN_SEQ_NO)
JOIN SA_STORE_DAY STD
ON (STD.STORE_DAY_SEQ_NO = STH.STORE_DAY_SEQ_NO)
WHERE STD.BUSINESS_DATE =&p_sales_date
@arbo-hacker
arbo-hacker / Start-uc4agent.sh
Created February 4, 2016 03:02
Procedimiento para levantar agentes con estatus “SRVC_DOWN” en UC4
# 1. Conectarse por línea de comandos al nodo con error con el usuario UC4.
# 2. Ir al directorio home de UC4
cd $AW_HOME
# 3. Ejecutar:
# Para levantar:
./uc4am.sh start
# Para detener:
./uc4am.sh stop
@arbo-hacker
arbo-hacker / Querys-util-ORSIM.sql
Created February 4, 2016 02:41
Querys de tablas principales de SIM (Oracle Retail Store Inventory Management)
--Tabla de Maestro de Artículos
select * from AS_ITM where id_itm='&codigoitem';
--Tabla Item / Location
select * from RK_ITM_LCN where id_itm='&codigoitem';
--Solicitudes de Inventario
select * from rk_item_request where item_request_id=&itemrequesid;
select * from RK_ITEM_REQUEST_LINE_ITEM where item_request_id=&itemrequesid; --Detalle de Solicitud de Inventario
@arbo-hacker
arbo-hacker / orders-in-rib.sql
Created February 4, 2016 02:28
Ordenes de compra que fueron publicadas en RIB
-- Query para determinar si las ordenes de compra fueron publicadas en RIB
select published, count(1)
from (
select distinct opi.*
from ordloc ol, ordhead oh, order_pub_info opi
where ol.location = 49
and oh.order_no = ol.order_no
and ol.order_no = opi.order_no
)
group by published;
@arbo-hacker
arbo-hacker / status-tablespace-oracle.sql
Created February 4, 2016 02:24
Status de TABLESPACES en la base de datos ORACLE
-- Con el siguiente query podemos ver el status de los tablespaces o unidades lógicas de almacenamiento de la base de datos:
SELECT A.tablespace_name tablespace_name,
to_char(TRUNC(NVL(SUM(B.BYTES/1048576),0) / (A.BYTES/1048576),4)*100)||'%' pct_free,
100 - to_char(TRUNC(NVL(SUM(B.BYTES/1048576),0) / (A.BYTES/1048576),4)*100)||'%' pct_used,
NVL(TRUNC(SUM(B.BYTES/1048576),2),0)||'MB' FREE_SPACE,
TRUNC((A.BYTES/1048576)-NVL(SUM(B.BYTES/1048576),2),0)||'MB' USED_SPACE,
TRUNC(A.BYTES/1048576,2)||'MB' FILE_SIZE,
autoextensible, status
FROM DBA_DATA_FILES A, DBA_FREE_SPACE B
WHERE A.FILE_ID=B.FILE_ID (+)
@arbo-hacker
arbo-hacker / nat-container.sh
Created February 1, 2016 20:23
Como dar salida/entrada a internet a tu Container (LXC) de Proxmox 4
#!/bin/sh
case "$1" in
start) echo "Starting iptables NAT"
#-----------------------------------------------------------------
#START NAT /////////////////////////////
#-----------------------------------------------------------------
/sbin/iptables -t nat -A POSTROUTING -s '10.0.0.0/24' -o vmbr0 -j MASQUERADE #BRIDGE
@arbo-hacker
arbo-hacker / test-jquery-serializearray.php
Created January 28, 2016 20:14
Demostracion de serializeArray() de JQuery
<?php
if (isset($_POST['first_name'])){
echo json_encode($_POST);
exit;
}
?>
<html>
<head>
<title>Test Serialize Array</title>
<script src="http://code.jquery.com/jquery-2.2.0.min.js"></script>