This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE FUNCTION FNC_FILENAME (ruta_archivo VARCHAR2, | |
barra VARCHAR2, | |
extension VARCHAR2) | |
RETURN VARCHAR2 | |
IS | |
BEGIN | |
RETURN REGEXP_SUBSTR (ruta_archivo, | |
'[^' || barra || ']+.' || extension, | |
1, | |
1); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Obtener todos los registros que son alfanumericos | |
select * from ( | |
select '123' campo from dual | |
union all | |
select '1X2' from dual | |
) tmp | |
where translate(campo,'T 0123456789','T') is not null; | |
-- Obtener todos los registros que son numericos | |
select * from ( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Decode a base-64 encoded string: | |
var quote = "Stay hungry. Stay foolish."; | |
var encode = window.btoa(quote); | |
var decode = window.atob(encode); | |
console.log("Encoded String: " + enc + "<br>" + "Decoded String: " + dec); | |
// The result will be: | |
// Encoded String: U3RheSBodW5ncnkuIFN0YXkgZm9vbGlzaC4= |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Uso de funcion FNC_FILENAME ubicada en https://gist.github.com/arbo-hacker/f8385586df6b20ff5419 | |
SELECT FNC_FILENAME('D:\user\Desktop\pafii\leeme.txt', '\', 'txt') nombre_archivo archivo | |
FROM DUAL; | |
-- O | |
set serveroutput on | |
DECLARE | |
v_FILENAME VARCHAR2(50); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 1. Abrir el terminal y situarte en la carpeta Utilities. | |
# 2. Escribir el siguiente comando y presionar la tecla enter: | |
sudo mkdir -p /Library/Internet\ Plug-Ins/disabled | |
# 3. Escribir el siguiente comando y presionar la tecla enter: | |
sudo mv /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin /Library/Internet\ Plug-Ins/disabled | |
# 4. Escribir el siguiente comando y presionar la tecla enter: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE tabla1 t1 | |
SET t1.valor = (SELECT t2.CODE FROM tabla2 t2 WHERE t1.valor = t2.DESC and t1.fecha=t2.fecha) | |
WHERE t1.filtro='correcto' | |
AND EXISTS (SELECT t2.CODE FROM tabla2 t2 WHERE t1.valor = t2.DESC and t1.fecha=t2.fecha); | |
-- O | |
UPDATE | |
(SELECT t1.valor as OLD, t2.CODE as NEW | |
FROM tabla1 t1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Hay q forzar a aceptar el certificado, ya que | |
//el nombre que se utiliza en la solicitud HTTP no | |
//coincide con el nombre del servidor que se emite con el certificado SSL | |
System.Net.ServicePointManager.CertificatePolicy = new MyPolicy(); | |
WebProxy proxy = new WebProxy("http://servidorconproxy:8080/",true); | |
proxy.Credentials = new NetworkCredential("user","password"); | |
System.Net.HttpWebRequest hr=System.Net.WebRequest.Create("https://www.unapagina.com") as System.Net.HttpWebRequest ; | |
hr.Proxy = proxy; | |
HttpWebResponse o=hr.GetResponse() as HttpWebResponse; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Casos creados por alguien | |
select distinct number,title from workitem | |
where created_by_worker_contact_id=(select contact_id from worker where upper(name) like '%ARBO%') | |
order by number desc; | |
-- Personas asociados a una cola de atención específica | |
select * from worker where queue_id=455; | |
-- Cantidad de casos asociados a todos los integrantes de una cola de atención | |
select (select w3.name from worker w3 where w3.id= w1.assigned_to_worker_id) asignado_a,count(*) Casos |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
---######## Este script crea el ACL en la BD: | |
begin | |
dbms_network_acl_admin.create_acl ( | |
acl => 'nombreacl.xml', | |
description => 'Normal Access', | |
principal => 'CONNECT', | |
is_grant => TRUE, | |
privilege => 'connect', | |
start_date => null, | |
end_date => null |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE | |
-- Change the following two parameters to fit your needs | |
p_progShortName VARCHAR2 (100) := '&nombre del concurrente'; -- este debe ser obtenido de la tabla fnd_concurrent_programs | |
p_forceDelete BOOLEAN := TRUE; | |
num_programID NUMBER; | |
var_progName VARCHAR2 (100); | |
num_appID NUMBER; | |
num_execID NUMBER; | |
num_appIDName VARCHAR2 (100); |
OlderNewer