Skip to content

Instantly share code, notes, and snippets.

View JRGGRoberto's full-sized avatar
🏛️
On work

Roberto JRGGRoberto

🏛️
On work
View GitHub Profile
@JRGGRoberto
JRGGRoberto / TabelaDinamica.html
Last active March 30, 2023 19:33
Tabela dinamica. Dados inseridos via input. Javascript
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
<script src="https://cdn.jsdelivr.net/npm/jquery@3.6.3/dist/jquery.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js"></script>
@JRGGRoberto
JRGGRoberto / hierarquia.sql
Last active August 29, 2015 14:05
Gerando hierarquina das organizações no vtiger
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
@rodrigo-galba
rodrigo-galba / gist:559504
Created August 31, 2010 18:50
Select para listar usuarios conectados no oracle
SELECT s.username, s.program, s.logon_time, s.osuser, s.machine
FROM v$session s, v$process p, sys.v_$sess_io si
WHERE s.paddr = p.addr(+)
AND si.sid(+) = s.sid
AND s.username = 'SYSPDVWEB_LANCEUNICO_TEST';