rajasgs

Postgres-Docker Installation:

docker pull postgres

mkdir -p $HOME/docker/volumes/postgres

docker run --name pgdocker -e POSTGRES_PASSWORD=postgres -d -p 5432:5432 -v $HOME/docker/volumes/postgres:/var/lib/postgresql/data  postgres

docker exec -it pgdocker bash

rajasgs

package org.rj;

import java.sql.*; 

public class Oracle12CEETest {

	private final static String DB_URL = "jdbc:oracle:thin:@//127.0.0.1:1521/orcl";
	private final static String USER = "system";
	private final static String PASS = "oracle";

rajasgs

docker run -d --name or12cee \ --privileged -v $(pwd)/oradata:/u01/app/oracle \ -e ORACLE_ALLOW_REMOTE=true \ -p 8082:8080 -p 1521:1521 absolutapps/oracle-12c-ee

docker exec -it or12cee /bin/bash

docker logs -f or12cee

sqlplus system/oracle@//localhost:1521/orcl

SQL>desc v$instance;

rajasgs

def add_check_digit(upc_str):
    """
    Returns a 12 digit upc-a string from an 11-digit upc-a string by adding 
    a check digit

    >>> add_check_digit('02345600007')
    '023456000073'
    >>> add_check_digit('21234567899')
    '212345678992'
    >>> add_check_digit('04210000526')

rajasgs

public class Oracle11GDebianTest {

	private final static String DB_URL = "jdbc:oracle:thin:@//127.0.0.1:1522/XE";
	private final static String USER = "SYSTEM";
	private final static String PASS = "oracle";

	public static void main(String[] args) {
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");

rajasgs

Reset mysql root password in Mac OS:

First Stop MySQL:

1. Go to: 'System Preferences' >> 'MySQL' and stop MySQL

OR,

1. sudo /usr/local/mysql/support-files/mysql.server start
2. sudo /usr/local/mysql/support-files/mysql.server stop

rajasgs

alias blah="/usr/bin/blah"
  
alias lh="ls -hal"

alias hiry="history"

alias clearme="history -c"

alias cls="clear"