Skip to content

Instantly share code, notes, and snippets.

Avatar
👩‍🚀

Eduardo Quintanilha Eduard0x6F

👩‍🚀
View GitHub Profile
@Eduard0x6F
Eduard0x6F / caught_errors.sql
Created Mar 26, 2020 — forked from frank-borkin/caught_errors.sql
Catch bad queries in Oracle.
View caught_errors.sql
create table caught_errors (
dt date,
username varchar2( 30), -- value from ora_login_user
msg varchar2(2000),
stmt varchar2(2000)
);
create or replace trigger catch_errors
after servererror on database
@Eduard0x6F
Eduard0x6F / FlashbackQueryOracle.sql
Created Sep 10, 2018
Flashback query on Oracle Table
View FlashbackQueryOracle.sql
/* Show the state of rows in table on 15 minutes before */
/* PS: Replace <TABLE_NAME> and '15' for prefered table and time */
SELECT *
FROM <TABLE_NAME>
AS OF TIMESTAMP SYSTIMESTAMP - INTERVAL '15' MINUTE
@Eduard0x6F
Eduard0x6F / CreatePoolConnNodeOracleDB.js
Created Sep 4, 2018
Creating Pool and Connection on Node OracleDB
View CreatePoolConnNodeOracleDB.js
https://github.com/oracle/node-oracledb/issues/484#issue-168115319
@Eduard0x6F
Eduard0x6F / CREATE_GRANT_USER_ORACLE.sql
Created Sep 3, 2018
Create and grant user for read only on Oracle Database
View CREATE_GRANT_USER_ORACLE.sql
-- Replace text inside '<>' tags by USER or PASSWORD fields;
CREATE USER <NEW_USER_NAME> IDENTIFIED BY <USER_PASSWORD>;
/
CREATE ROLE <NEW_USER_NAME>_ROLE;
/
GRANT CREATE SESSION TO <NEW_USER_NAME>;
/
GRANT SELECT ANY DICTIONARY TO <NEW_USER_NAME>_ROLE;
/
View gist:bbce739f79dad2a5073711a955e31751

1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@Eduard0x6F
Eduard0x6F / gist:6f2a2308337c4aef59b1c304d1423518
Last active Aug 30, 2018 — forked from sabarasaba/gist:3080590
Remove directory from remote repository after adding them to .gitignore
View gist:6f2a2308337c4aef59b1c304d1423518
git rm -r --cached node_modules
git commit -m 'Remove the now ignored directory node_modules'
git push origin master
View building-android-ionic.txt
1. ionic cordova build android --prod --release
2. jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 -keystore key-padrao platforms\android\app\build\outputs\apk\release\app-release-unsigned.apk key-padrao
3. zipalign.exe -v 4 platforms\android\app\build\outputs\apk\release\app-release-unsigned.apk ..\ApkVersionsTest\FinanceiroHe_01-06-2018_v3_EXTERNAL.apk
@Eduard0x6F
Eduard0x6F / LINKS MODEM HUAWEI
Created May 31, 2018
SMS MODEM HUAWEI - GAMMU CONFIG
View LINKS MODEM HUAWEI
@Eduard0x6F
Eduard0x6F / Raspberry and Gammu.md
Created May 31, 2018 — forked from tomysmile/Raspberry and Gammu.md
GAMMU: Send SMS with Raspberry Pi
View Raspberry and Gammu.md

Send SMS messages using Raspberry Pi.

Using gammu and Huawei E220

Prepare SD card with wheezy.

Login / complete rasp-config / reboot / login

Set vimrc to prevent annoying ADBC arrow keys

cp /etc/vim/vimrc ~/.vimrc

@Eduard0x6F
Eduard0x6F / HUAWEI_E3531.sh
Created May 31, 2018 — forked from elacheche/HUAWEI_E3531.sh
Little script to enable HUAWEI E3531 on Ubuntu
View HUAWEI_E3531.sh
sudo apt-get update && sudo apt-get install usb-modeswitch && v=$(lsusb | grep "Huawei" | awk '{ print $6 }' | awk -F: '{ print $1 }'); p=$(lsusb | grep "Huawei" | awk '{ print $6 }' | awk -F: '{ print $2 }'); sudo usb_modeswitch -v $v -p $p -M '55534243123456780000000000000011062000000100000000000000000000'
You can’t perform that action at this time.