SanthoshBabuMR

-- find tables
SELECT *
FROM information_schema.tables
WHERE table_schema = 'public'
and table_name like '%pattern%'
ORDER BY table_type, table_name;

-- DESC table
SELECT 
   table_name, 

SanthoshBabuMR

apply plugin: 'java'

version = 0.1
sourceCompatibility = 1.8

// location to download the depenedencies
repositories {
  mavenCentral()
}

SanthoshBabuMR

Gradle Wrapper

• project-root
  • gradle
    • gradle-wrapper.jar (download, unpack gradle specified in properties file)
    • gradle-wrapper.properties (gradle home path, gradle version to download)
  • gradlew
  • gradlew.bat

Gradle location

• ~/.gradle/wrapper/dists (gradle installation by wrapper)

SanthoshBabuMR

Java (Maven) Project layout

• src
  • main
    • java
    • resources
  • test
    • java
    • resources

Java (Maven) Project layout:: Web Application

SanthoshBabuMR

cmd

• git revert <commit-id-to-be-reverted> -m 1 <parent-commit-hash>

Ref

• https://stackoverflow.com/questions/7099833/how-to-revert-a-merge-commit-thats-already-pushed-to-remote-branch/7100005#7100005

SanthoshBabuMR

# Connect to psql
psql -d <db_name>

# show current DB
/c

# switch DB
/c <db_name>

# create DB

SanthoshBabuMR

/* 
 * site: https://www.oxfordlearnersdictionaries.com/
 */
#ad_btmslot_a, iframe {
  visibility: hidden;
}

/* 
 * site: https://learning.oreilly.com/ 

SanthoshBabuMR

http://dockerlabs.collabnix.com/docker/cheatsheet/

SanthoshBabuMR

--Analysing user_objects and all_objects views
select * from user_objects;
select * from cat;
select * from user_catalog;
select * from all_objects;
select * from dba_objects;
--Searching in tables (user_tables)
select * from user_tables;
select * from all_tables;
select * from dba_tables;

SanthoshBabuMR

function smallestSubStr(sentence, str) {
  if(!sentence || !str) { return null; }

  let beginCharacter = str[0].toLowerCase();
  let probableMatches = [];
  let smallestSubStrMap = {
    len: Number.MAX_SAFE_INTEGER,
    text: null
  };