otwm

import java.io.{FileOutputStream, FileInputStream}

import scala.io.StdIn

/**
 * Created by YoungJoo on 2015-09-11.
 */
object DrearyDesign extends App {
  val path = "D:\\dev\\intellySpace\\ScalaStudy\\"
  //  Console.setIn(new FileInputStream(path + "testFile"))

otwm

    /**
     * ie 10 - 11 hack
     */
    @media screen and (-ms-high-contrast: active), (-ms-high-contrast: none) {
        .verify_wrap2 {
            position: relative;
            right: -10px;
            display: inline-block;
            width: 460px;
            float: right;

otwm

<style type="text/css">
    /**
     * ie 10 - 11 hack
     */
    @media screen and (-ms-high-contrast: active), (-ms-high-contrast: none) {
        .verify_wrap2 {
            position: relative;
            right: -10px;
            display: inline-block;
            width: 460px;

otwm

def generateSequence(end=100,head='MG',fill=17):
  for index in range(1,end):
    print(head + (index + '').zfill(fill)):

otwm

import codecs

sql = ""
sql += "merge into tn_year_cust t1 using (select '{year}' year,'{custId}' cust_Id from dual) t2"
sql += "    on (t1.year = t2.year and t1.cust_id= t2.cust_id)"
sql += "  WHEN MATCHED THEN"
sql += "				UPDATE SET"
sql += "				     SITE_TARGET_YN = '{siteTargetYn}'"
sql += "					,SITE_TARGET_DT	= '{siteTargetDt}'"
sql += "					,SITE_COMPLETE_YN = '{siteCompleteYn}'"

otwm

find ./jsp -exec touch {} \;

otwm

apply plugin: 'spring-boot'


jar {
    baseName = 'core'
    version = '0.5.0'
}

sourceSets {
    generated {

otwm

sed -i 's/kr.archive.ubuntu.com/ftp.daum.net/g' /etc/apt/sources.list

otwm

-- 만료기간 검색
select resource_name, limit from dba_profiles
where profile='DEFAULT'
;

-- 만료기간 무제한 설정
alter profile default limit password_life_time unlimited;

-- 만료 계정 검색
select username,account_status,lock_date,expiry_date from dba_users

otwm

1. 계정의 테이블 스페이스 생성

create tablespace [tablespace_name] 
datafile '/home/oracle/oradata/DANBEE/[file_name].dbf' size 500m;

예)
CREATE TABLESPACE ADMIN DATAFILE 'D:\ORACLE\ORADATA\XE\ADMIN.dbf' SIZE  500M ;


2. 오라클 유저 만들기