Wednesday, May 8, 2024

Excel Formula to check values in two columns. =IF

Excel Formula to check values in two columns.

Use case: columns E1 and I1 can have any number. If values are 5 or 6 or 7 in both columns then I should get matched else notMatched.

 =IF(AND(IF(OR(E1={5,6,7}), 1,0),IF(OR(I1={5,6,7}), 1,0)),"matched","notMatched")

Saturday, February 18, 2023

Dynamic List Region displaying as Badges | Oracle APEX

 This list template provides a list of links which can be used for navigation and other action-oriented tasks. I have used badges. You can optionally show badges, icons, sub list items, and more.

Shared Components


Create List


Dynamic List


Region Attributes


Run Page




Tuesday, September 20, 2022

How to Generate RSA Private Keys in Oracle Cloud Infrastructure OCI Tenancy?

 RSA Private Keys

Click on your Profile > Go to oracleidentitycloudservice/_userid_





At the bottom of this page, you will find API Keys


Click on Add Key to generate private or public keys.



Download Private RSA keys


                                                    ✍ It's Done. ✌

Friday, August 26, 2022

Get Month name and Week name in Dart Flutter

 import 'package:intl/intl.dart';


void main() {

  print(DateTime.now().month); // get current month number

  print(DateTime.november); // get given month number

 

  DateTime date = DateTime.now();

  print(DateFormat('MMMM').format(date)); // get current month name

  print(DateFormat('EEEE').format(date)); // get current week name

}


// below url has the supported set of skeletons, e.g., 'MMMM', 'EEEE'

// https://api.flutter.dev/flutter/intl/DateFormat-class.html#:~:text=constructor%20is%20preferred.-,ICU,-Name%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Skeleton%0A%20%2D%2D%2D%2D%2D%2D%2D%2D%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2D%2D%2D%2D%2D%2D%2D%2D%0A%20DAY


.map() method in DART

 import 'dart:convert';

Welcome welcomeFromJson(String str) => Welcome.fromJson(json.decode(str));

void main() {
  Map<String, dynamic> json = {"items":[{"id":83,"description":"Test 1"}]};
  List myList = List<Item>.from(json["items"].map(myFunc));//(x) => Item.fromJson(x)));
  print(myList[0].eId);
  print(myList[0].eDescription);
}

myFunc(x) {
  print(x); // {id: 83, description: Test 1} // output of .map() method
  return Item.fromJson(x);
}

class Welcome {
    Welcome({
        required this.items,
    });

    List<Item> items;
 
    factory Welcome.fromJson(Map<String, dynamic> json) => Welcome(
        items: List<Item>.from(json["items"].map((x) => Item.fromJson(x))),
    );  
}

class Item {
    Item({
        this.eId,
        this.eDescription,
    });

    int? eId;
    String? eDescription;

    factory Item.fromJson(Map<String, dynamic> json) => Item(
        eId: json["id"],
        eDescription: json["description"],
    );
}

Monday, March 22, 2021

Remove duplicates from a string separated by colon Oracle SQL using REGEXP


Remove duplicates from a string separated by colon or by any keyword



select distinct str from (
select regexp_substr('abc:xyz:abc:pqr:xyz','[^:]+',1,level) str from dual
connect by level <= regexp_count('abc:xyz:abc:pqr:xyz','[^:]+', 1)
);



Monday, July 16, 2018

How to get MAX DATE for each ID in Oracle?


Take the max from sub-query using group by and in outer query set equal (=) condition of max_date


SELECT T1.ACC_ID, T1.DATE AS MAX_DATE, T1.COL1, T1.COL2
  FROM EMP T1,

       (SELECT ACC_ID, MAX(DATE) AS MAX_DATE_I FROM EMP GROUP BY ACC_ID) T2

 WHERE T1.ACC_ID = T2.ACC_ID
   AND T1.MAX_DATE = T2.MAX_DATE_I
   AND ACTIVE_FLAG = 'Y';

--===============================================================

SELECT T1.DEPTNO, T1.HIREDATE
  FROM EMP T1,
       (SELECT DEPTNO, MAX(HIREDATE) AS MAX_DATE FROM EMP GROUP BY DEPTNO) T2
 WHERE T1.DEPTNO = T2.DEPTNO
   AND T1.HIREDATE = T2.MAX_DATE;