- https://hub.docker.com/_/oracle-database-enterprise-edition
- accept agreement
- pull image
docker login
docker pull store/oracle/database-enterprise:12.2.0.1| function smallestSubStr(sentence, str) { | |
| if(!sentence || !str) { return null; } | |
| let searchStrIndex = 0; | |
| let startsAtIndex; | |
| let smallestSubStrMap = { | |
| len: Number.MAX_SAFE_INTEGER, | |
| text: null | |
| }; |
docker login
docker pull store/oracle/database-enterprise:12.2.0.1| select * from V$version; | |
| ## DB Version | |
| desc hr.employees; | |
| -- shortcut: select table_name and hit: shift + f4 | |
| info hr.employees; | |
| info+ hr.employees; | |
| -- additional info to desc cmd | |
| -- primary key, cols(min,max,distinct), default, comments, indexes references |
| // https://www.youtube.com/watch?v=gcULXE7ViZw | |
| // TreeHouse: delete node : https://www.youtube.com/watch?v=5cU1ILGy6dM | |
| class Node { | |
| constructor(value){ | |
| this.left = null; | |
| this.right = null; | |
| this.value = value; | |
| } | |
| } |
| -- ## | |
| -- Basic Queries & Operators | |
| -- ## | |
| SELECT column1, column2 FROM table; | |
| -- Query data in columns column1, column2 from a table. | |
| SELECT * FROM table; | |
| -- Query all rows and columns from a table |
| import java.util.*; | |
| public class HashMapToList { | |
| public static void main(String[] args) { | |
| HashMapToList hashMapToList = new HashMapToList(); | |
| hashMapToList.init(); | |
| } | |
| private void init() { | |
| List<User> users = toList(getData()); |
| # install nginx | |
| apt-get update | |
| apt-get install nginx | |
| unlink /etc/nginx/sites-enabled/default | |
| # configure | |
| cat > /etc/nginx/sites-available/reverse-proxy.conf | |
| server { | |
| listen 8443; |
Instructions
Ref
| -- get centos image | |
| docker pull centos | |
| -- run with interactive shell | |
| -- docker run -it --name minishift centos /bin/bash: centos has issues with running serivce | |
| docker run -it --name minishift phusion/baseimage /bin/bash -- Ubuntu 16.04.3 LTS | |
| -- check OS name/version | |
| cat /etc/*-release | |
| -- if service is unavailable in docker centos | |
| yum -y install initscripts && yum clean all |
| package com.babusa.learn.json; | |
| import com.fasterxml.jackson.annotation.*; | |
| import com.fasterxml.jackson.core.JsonParser; | |
| import com.fasterxml.jackson.core.JsonProcessingException; | |
| import com.fasterxml.jackson.databind.DeserializationContext; | |
| import com.fasterxml.jackson.databind.JsonDeserializer; | |
| import com.fasterxml.jackson.databind.ObjectMapper; | |
| import com.fasterxml.jackson.databind.annotation.JsonDeserialize; |