Skip to content

Instantly share code, notes, and snippets.

View AmrAbdeen's full-sized avatar

Amr AmrAbdeen

  • Egypt, Northern coast
View GitHub Profile
@AmrAbdeen
AmrAbdeen / total_column.js
Last active August 29, 2015 14:24
https://community.oracle.com/thread/3764388 Assuming the tabular form has following columns: f06 - Qty f07 - Price f10 - Total NOTE : Check your tabular form for the respective columns and accordingly change the below code. You can do it in two ways: Solution 1 : Using JavaScript Edit your Page Attributes -> "JavaScript" section -> "Function and…
//Checks whether the given string is numeric
function isNumeric(str) {
if (!str.length || !isNaN(str.replace(/\s/,"z")/1)) {return true;}
return false;
}
//Checks whether a field is null or numeric else returns 0
function f_chkNumberFlds(pVal) {
var lVal;
if ( pVal.length > 0 ) {
@AmrAbdeen
AmrAbdeen / auto_logout.sql
Created July 11, 2015 04:00
https://community.oracle.com/message/13189178#13189178 MahDM wrote: I am using custom authentication in Apex 5.0 application. Post login, if the password of the user is expired then I am able to move the user to self password change page. However, I wanted to logoff that user forcibly and so that user can login with his new password. I tried wit…
BEGIN
APEX_AUTHENTICATION.LOGOUT (
P_SESSION_ID => :APP_SESSION,
P_APP_ID => :APP_ID,
P_WS_APP_ID => NULL );
END;
@AmrAbdeen
AmrAbdeen / ConstraintCommands.sql
Last active August 29, 2015 14:06
ORACLE PL/SQL
-- Select constraint
select * from all_constraints
where constraint_name = 'T_CUST_PASS_CK'
@AmrAbdeen
AmrAbdeen / gist:11465377
Last active August 29, 2015 14:00
Here are some things you can do with Gists in GistBox.
We couldn’t find that file to show.