I hereby claim:
- I am jramb on github.
- I am jramb (https://keybase.io/jramb) on keybase.
- I have a public key ASDOFoydae_xmR9tVPSYO8rejULQNTtghARbtdhWwhAgdgo
To claim this, I am signing this object:
Jörg Ramb jramb
jramb
/ ebs-logged-in-users.sql
Last active
June 15, 2023 20:49
List all users currently logged in on Oracle EBS.This select lists all users currently logged in (only potentially, since they might have ended the session without loggin out).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.* | |
| from apps.icx_sessions icx | |
| join apps.fnd_user usr on usr.user_id=icx.user_id | |
| left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id | |
| where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24 | |
| and disabled_flag != 'Y' and pseudo_flag = 'N' |
jramb
/ levenshtein.sql
Last active
December 30, 2015 11:39
String distance metric - Levenshtein distance
Optimized with some efford, still, performance depends heavily on the length of the input. Example: select xx_tools_pkg.levenshtein_dist('Hejsan', 'hejsan'), xx_tools_pkg.levenshtein_dist('kitten', 'sitting')
from dual; Returns distances of 1 and 3. Probably you would want to apply upper/lower on the…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Levenshtein is a string distance metric | |
| -- https://en.wikipedia.org/wiki/Levenshtein_distance | |
| function levenshtein_dist(p_s varchar2, p_t varchar2) | |
| return number deterministic | |
| is | |
| type int_t is table of pls_integer index by pls_integer; | |
| type char_t is table of char(2) index by pls_integer; | |
| v0 int_t; | |
| v1 int_t; | |
| t char_t; -- copy of p_t for performance |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package xxcust.testClient; | |
| import javax.xml.namespace.QName; | |
| import javax.xml.soap.MessageFactory; | |
| import javax.xml.soap.MimeHeaders; | |
| import javax.xml.soap.SOAPBody; | |
| import javax.xml.soap.SOAPConnection; | |
| import javax.xml.soap.SOAPConnectionFactory; | |
| import javax.xml.soap.SOAPElement; | |
| import javax.xml.soap.SOAPEnvelope; |
jramb
/ openpgp.md
Created
March 27, 2022 09:00
This is an OpenPGP proof that connects my OpenPGP key to this Github account. For details check out https://docs.keyoxide.org/advanced/openpgp-proofs/
[Verifying my OpenPGP key: openpgp4fpr:2168f22b84851fc265ba6af589d8325b4488070c]
jramb
/ nic_validate_se_persnr_mod.js
Created
October 27, 2023 06:43
Luhn validation of swedish personal id number
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * @NApiVersion 2.1 | |
| * | |
| * @Description nic_validate_se_persnr_mod.js | |
| * @Solution Generic module | |
| * | |
| * @Copyright 2023 Noresca IT Consulting AB | |
| * @Author jorg.ramb <[email protected]> | |
| * | |
| * # Explanation |
OlderNewer