Jose Boretto joseboretto

💭

Coding

Team player.

joseboretto / git_delete_branches_from_dirs.sh

Last active December 20, 2022 13:51

Git delete all local branches except "develop and master" from many directories/repo recursively

for d in ./*/ ; do (cd "$d" && git branch | grep -v "develop" | grep -v "master" | grep -v "release" | xargs git branch -D); done

joseboretto / UNLOCK_ORACLE_OBJECT_PLSQL_SCRIPT.sql

Last active November 29, 2018 18:18

UNLOCK ORACLE OBJECT PL/SQL SCRIPT

	declare
	v_object_name ALL_OBJECTS.OBJECT_NAME%type;
	v_object_id ALL_OBJECTS.OBJECT_ID%type;
	v_session_id V$LOCK.SID%type;
	v_session_serial V$LOCK.serial#%type;
	v_sql_stmnt varchar2(400);
	begin
	-- RUN AS SYSDBA
	-- PUT YOUR OBJECT NAME HERE!!!
	v_object_name := 'CER_CERTIFICACIONES_EVALUACION';