Skip to content

Instantly share code, notes, and snippets.

View demasy's full-sized avatar
🎯
Focusing

Ahmed El-Demasy demasy

🎯
Focusing
View GitHub Profile
@demasy
demasy / command-line.md
Created November 1, 2021 08:00
Install & Use WineHQ in Ubuntu
sudo apt update
sudo dpkg --add-architecture i386
wget -O - https://dl.winehq.org/wine-builds/winehq.key | sudo apt-key add -
@demasy
demasy / https.md
Created October 1, 2021 19:09
Generate SSL Certificate on Mac OS X
openssl req -x509 -days 365 -newkey rsa:4096 -keyout demasy.key -out roketto.key.crt
openssl rsa -in roketto.key -out demasy.decrypted.key
openssl pkcs12 -export -in demasy.key.crt -inkey demasy.key -out demasy.pfx
@demasy
demasy / mac.txt
Created September 10, 2021 17:12
get the open network ports with netstat on Mac
sudo lsof -PiTCP -sTCP:LISTEN
@demasy
demasy / java.txt
Created August 30, 2021 07:10
Remove Java JDK from mac
sudo rm -fr /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin
sudo rm -fr /Library/PreferencePanes/JavaControlPanel.prefPane
sudo rm -fr ~/Library/Application\ Support/Oracle/Java
cd /Library/Java/JavaVirtualMachines
sudo rm -rf <jdk-version>.jdk
@demasy
demasy / statement.sql
Created August 25, 2021 10:43
Oracle HR initialize Org session
FND_CLIENT_INFO.SET_ORG_CONTEXT('101');
@demasy
demasy / statement.sql
Created August 25, 2021 10:35
Oracle PL/SQL convert hex to decimal
CREATE OR REPLACE FUNCTION APPS.hex2dec (hexval IN CHAR)
RETURN NUMBER
IS
i NUMBER;
digits NUMBER;
result NUMBER := 0;
current_digit CHAR (1);
current_digit_dec NUMBER;
BEGIN
digits := LENGTH (hexval);
@demasy
demasy / statement.sql
Created August 25, 2021 10:32
Oracle Application Delete AR invoice Script
BEGIN
FOR AR_INV_DATA
IN (SELECT CUX.CUSTOMER_TRX_ID, CUX.TRX_NUMBER
FROM RA_CUSTOMER_TRX_ALL CUX
WHERE CUX.BATCH_SOURCE_ID = �REEM�
AND CUX.TRX_DATE <= TO_DATE ('01/05/2007', 'dd/mm/yyyy'))
LOOP
-- Set a proper where condition as your case
AR_TRANSACTION_PUB.DELETE_TRANSACTION (
P_API_NAME => 'Maintain_Transaction',
@demasy
demasy / statement.sql
Created August 25, 2021 10:29
Oracle SCM Inventory MinMax SQL
SELECT msib.ORGANIZATION_ID,
DECODE (USERENV ('LANG'),
'US', haou.ATTRIBUTE1,
'AR', haou.ATTRIBUTE2)
ORGANIZATION_NAME,
msib.INVENTORY_ITEM_ID,
msib.segment1 inv_num,
msib.DESCRIPTION,
msib.PRIMARY_UOM_CODE,
msib.PRIMARY_UNIT_OF_MEASURE,
@demasy
demasy / statement.sql
Created August 25, 2021 10:27
Oracle get workflow version
SELECT WR.TEXT Value
FROM WF_RESOURCES WR
WHERE 1 = 1 AND WR.LANGUAGE = USERENV ('LANG') AND WR.NAME = 'WF_VERSION'
@demasy
demasy / statement.sql
Created August 25, 2021 10:25
Oracle Application run Oracle workflow background
Exec WF_ENGINE.Background('WFVACXX', NULL, NULL, FALSE, TRUE, FALSE);