comparar columnas en tablas

WITH Tabla1_Columnas AS (
    SELECT upper(column_name) column_name
    FROM all_tab_columns
    WHERE table_name = 'table_name' -- Reemplaza con el nombre de tu primera tabla
),
Tabla2_Columnas AS (
    SELECT upper(column_name) column_name
    FROM all_tab_columns
    WHERE table_name = 'table_name' -- Reemplaza con el nombre de tu segunda tabla
)
(SELECT column_name
FROM Tabla1_Columnas
MINUS
SELECT column_name
FROM Tabla2_Columnas)
union all
(SELECT column_name
FROM Tabla2_C

Gantt Auto Set Dates

Saved from https://airtable.com/marketplace/scrRPE0b4OluQ6H0M/gantt-auto-set-dates

/****************************************************************************************** * Name: Gantt Auto-Date * Author: Mike Pechter * Date: 3/11/2021 * * Suggested use: Use this script to automatically complete a table of tasks, in conjunction with a Gantt View. * */
//PART 1: Script Settings
const config = input.config({    title: 'Gantt: automatically set start/end dates from dependencies',    description: `A script that automatically adds start and end dates to a table of tasks. Use i

Create Bar Chart in Markdown

Saved from https://airtable.com/marketplace/scr39Zr8GvhSPwOIM/create-bar-chart-in-markdown
let settings = input.config({
    title: 'Create bar chart in Markdown',
    description: 'This script will create a bar chart from your data and output it in Markdown',
    items: [
        input.config.table('table', {
            label: 'Table'
        }),
        input.config.view('view', {
            parentTable: 'table',
            label: 'View'
        }),
        input.config.field('label', {
            parentTable: 'table',
            label: 'Label field',
        }),

Find and Replace

Saved from https://airtable.com/marketplace/scrhgBXk9ExE6lLNx/find-and-replace?ref=blog.airtable.com&_gl=1*161p7ma*_ga*NTAxMzYxNDIxLjE2ODMyNzc1Nzg.*_ga_VJY8J9RFZM*MTY5NTUxODAyMy4yMi4xLjE2OTU1MTg2MTUuNTkuMC4w
let settings = input.config({    title: 'Find and replace',    description: `This script will find and replace all text matches for a text-based field you pick.    You will be able to see all matches before replacing them.`,    items: [        input.config.table('table', { label: 'Table' }),        input.config.field('field', { parentTable: 'table', label: 'Field' }),    ],});
let { table, field } = settings;output.text(`Finding and replacing in the ${field.name} field of ${table.name}.`);
let f

Delete Duplicates

Saved from https://airtable.com/marketplace/scrQMExSF76Ftgxrw/delete-duplicates?ref=blog.airtable.com&_gl=1*161p7ma*_ga*NTAxMzYxNDIxLjE2ODMyNzc1Nzg.*_ga_VJY8J9RFZM*MTY5NTUxODAyMy4yMi4xLjE2OTU1MTg2MTUuNTkuMC4w
let settings = input.config({    title: 'Delete duplicates',    description: `This script will delete duplicate records in a given table according to the value oftwo input fields. Duplicate records are detected when they contain the same cell value for each identifyingfield. For any two records that are considered duplicates, it will use a third comparison field to determinewhich of the two records should be deleted.`,    items: [        input.config.table('table', { label: 'Table' }),        in

Validate Emails

Saved from https://airtable.com/marketplace/scrWNTVvcQV0kyvHS/validate-emails?ref=blog.airtable.com&_gl=1*161p7ma*_ga*NTAxMzYxNDIxLjE2ODMyNzc1Nzg.*_ga_VJY8J9RFZM*MTY5NTUxODAyMy4yMi4xLjE2OTU1MTg2MTUuNTkuMC4w
let settings = input.config({    title: "Validate emails",    description: "This script will list all invalid emails for a field you pick.",    items: [        input.config.table("table", { label: "Table" }),        input.config.field("field", {            parentTable: "table",            label: "Email field",        }),    ],});
let { table, field } = settings;
// To validate a string of text we need to use a regular expression.// Regular expressions are complex — read more about them here: htt

Non Intersecting Instances (Point Removal Method)

/Switch Select Input should have an "if" statement: if(npoints("../intersectionanalysis1/")>0,1,0)

Delete docker buildkit

docker ps -a | grep buildx | awk '{print $1}' | xargs docker rm -f

Add a submenu toggle button to WordPress menu items with children

[Add a submenu toggle button to WordPress menu items with children] Here are the PHP code and JS that will let you create a toggle and cause it to actually toggle classes and aria-expanded attributes. Use styles to show and hide the submenu, and to rotate the chevron when it's open.
// Add this to an appropriate php file in your theme
// Change the function name and the "visually-hidden" class name as appropriate
// Note that this is a WireMedia theme, so is using their icons function.
// You can use css to create the chevron instead


require_once 'icons.php';

function j40a_parent_menu_item_buttons($output, $item, $depth, $args) {
  if (in_array('menu-item-has-children', $item->classes, true)) {
    $output = $output . '<button type="button" class="menu-item__toggle"
    

Full File One Per Week Segment

# Notes
Link to segment in Epsilon
https://ui.harmony.epsilon.com/data/segmentationCDS/63ee8a5a-8144-4636-9eae-6083feae81cf

Segment Name:Full File 
Folder: Live Segments Filters 
Scheduled List Name: Full File Daily Generated List
Schdeuled List Creation Time: Daily at 6 am, refreshes list each day

Full File Coupon Segment

# Notes
Link to segment in Epsilon


Segment Name:Full File Coupon
Folder: Live Segments Filters 
Scheduled List Name: Full File Coupon Daily Generated List
Schdeuled List Creation Time: Daily at ## am, refreshes list each day

Full File Segment Sample

# Notes
Link to segment in Epsilon
https://ui.harmony.epsilon.com/data/segmentationCDS/63ee8a5a-8144-4636-9eae-6083feae81cf

Segment Name:Full File 
Folder: Live Segments Filters 
Scheduled List Name: Full File Daily Generated List
Schdeuled List Creation Time: Daily at 6 am, refreshes list each day

Ejemplo de paralelizacion en MAT

# coding: utf-8
########################################################################################################################
###########################################                       ######################################################
###########################################  READ ONLY LIBRARIES  ######################################################
###########################################                       ######################################################

show posted time ago

/**/
function time_ago() {
	return __( 'há' ).' '. human_time_diff( get_the_time( 'U' ), current_time( 'timestamp' ) );
}

get reading time - show read time

/**/
function get_reading_time() {
    $article = get_post_field( 'post_content', get_the_ID() );
    $wordcount = str_word_count( strip_tags( $article ) );
    $time = ceil($wordcount / 250);
        
    if ($time == 1) {
        $label = " minuto";
    } else {
        $label = " minutos";
    }
        
    $totalString = $time . $label;
    return $totalString;        
}

Checkbox

/* -----------------------------
    CHECKBOX
   ----------------------------- */

.checkbox + label {
  position: relative;
  display: inline-block;
  padding-left: 30px;
  font-size: 14px;
  font-weight: 400;
  line-height: 1.2;
  color: var(--color-text-primary);
  cursor: pointer;
}

.checkbox + label::before,
.checkbox + label::after {
  content: "";
  position: absolute;
}

.checkbox + label::before {
  top: 50%;
  left: 0;
  width: 20px;
  height: 20px;
  border-radius: 3px;
  border: 1px