Skip to content

Instantly share code, notes, and snippets.

View obedmhg's full-sized avatar

Obed Murillo obedmhg

View GitHub Profile
<!DOCTYPE NETSCAPE-Bookmark-file-1> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"> <TITLE>Bookmarks</TITLE> <H1>Bookmarks Menu</H1> <DL><p> <HR> <DT><H3 ADD_DATE="1512088815" LAST_MODIFIED="1512088815">Imported</H3> <DL><p>
<DT><A HREF="https://www.google.com/">google</A>
<DT><A HREF="https://www.amazon.com.mx/">amazon</A>
<DT><A HREF="https://sometools.netlify.com/">sometools</A>
<DT><A HREF="http://obed33.blogspot.com">obed'sBlog</A>
</DL><p> </DL>
google https://www.google.com/
amazon https://www.amazon.com.mx/
sometools https://sometools.netlify.com/
obed'sBlog http://obed33.blogspot.com/
@obedmhg
obedmhg / collate_example.sql
Created January 6, 2020 19:44
Example of sort using collate
CREATE TABLE t1 (
id NUMBER,
company VARCHAR2(15 CHAR),
location VARCHAR2(15 CHAR),
CONSTRAINT t1_pk PRIMARY KEY (id)
);
INSERT INTO t1 VALUES (1, 'OCorp', 'Bräunlingen');
INSERT INTO t1 VALUES (2, 'ocorporation', 'BrÄunlingen');
INSERT INTO t1 VALUES (3, 'Oscorp', 'Braunlingen');
drop directory data_pump_dir;
create directory data_pump_dir as '/u01/oracle/export/';
@obedmhg
obedmhg / RefreshDimensionValueCache.dash
Created October 22, 2019 22:07
Dash Script to invalidate DVC on ATG
set /atg/commerce/endeca/cache/DimensionValueCacheTools.minimumCacheRefreshIntervalSecs 0
set /atg/commerce/endeca/cache/DimensionValueCacheTools.checkMDEXUpdated false
call /atg/commerce/endeca/cache/DimensionValueCacheTools refreshCache
set /atg/commerce/endeca/cache/DimensionValueCacheTools.minimumCacheRefreshIntervalSecs 7200
set /atg/commerce/endeca/cache/DimensionValueCacheTools.checkMDEXUpdated true
@obedmhg
obedmhg / row_count_all_tables.sql
Created October 7, 2019 17:41
PL/SQL to run a count on all tables
SET SERVEROUTPUT ON;
DECLARE
CURSOR get_all_table_names IS
SELECT
table_name
FROM
user_tables
ORDER BY table_name ASC;
@obedmhg
obedmhg / thumbnailImageUrl.xml
Created July 31, 2019 22:26
RepositoryProperty using ValueFromMapPropertyDescriptor
<property name="thumbnailImageUrl" display-name-resource="thumbnailImageUrl" data-type="string"
property-type="com.myCompany.repository.ValueFromMapPropertyDescriptor">
<attribute name="property" value="imagesMap"/>
<attribute name="key" value="thumbnailImage"/>
</property>
@obedmhg
obedmhg / ValueFromMapPropertyDescriptor.java
Created July 31, 2019 22:22
Property descriptor that will get the value from a map, property and key need to be passed by as attributes.
package com.myCompany.repository;
import atg.core.util.StringUtils;
import atg.nucleus.logging.ApplicationLogging;
import atg.nucleus.logging.ClassLoggingFactory;
import atg.repository.RepositoryItemImpl;
import atg.repository.RepositoryPropertyDescriptor;
import java.util.Map;
@obedmhg
obedmhg / AssemblerPipelineServlet.properties
Created July 25, 2019 21:33
Custom formatParamName at AssemblerPipelineServlet
formatParamName=myCustomNotEasyToGuessName
find /u01/oracle/nodejs/apps/myApp/ -type f -name "*.js" -exec md5sum {} + | awk '{print $1}' | sort | md5sum