Skip to content

Instantly share code, notes, and snippets.

View joseboretto's full-sized avatar
💭
Coding

Jose Boretto joseboretto

💭
Coding
View GitHub Profile
@joseboretto
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
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';