public boolean isLdapUserCheck(String account, String password) {
        boolean ret = true;
        DirContext ctx = null;
        try {
            Hashtable<String, String> env = new Hashtable<String, String>();
            env.put(Context.INITIAL_CONTEXT_FACTORY,"com.sun.jndi.ldap.LdapCtxFactory");
            env.put(Context.PROVIDER_URL, "ldap://192.168.0.30:389/");
            env.put(Context.SECURITY_AUTHENTICATION, "simple");
            env.put(Context.SECURITY_PRINCIPAL, account + "@tradewin-dalian.cn");
            env.put(Context.SECURITY_CREDENTIALS, password);
            ctx = new InitialDirContext(env);
        } catch (Exception e) {
            ret = false;
        } finally {
            if (ctx != null) {
                try {
                    ctx.close();
                } catch (NamingException e) {
                    ret = false;
                }
            }
        }
        return ret;
    }

-- Create table
create table SSM_ORDER
(
  ORDER_NO        NUMBER not null,
  USER_ID         VARCHAR2(20),
  SHOP_ID         VARCHAR2(20),
  MEAL_ID         NUMBER not null,
  AMOUNT          NUMBER,
  DELETE_FLAG     CHAR(1),
  CREATE_DATETIME DATE,
  CREATE_USER_ID  VARCHAR2(20),
  CREATE_HOST_IP  VARCHAR2(17),
  UPDATE_DATETIME DATE,
  UPDATE_USER_ID  VARCHAR2(20),
  UPDATE_HOST_IP  VARCHAR2(17)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table SSM_ORDER
  add constraint SSM_ORDER_MEAL_PK primary key (ORDER_NO)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

ID/PASS
02494517/dalian
http://www.moneypartners.co.jp/

package cn.tradewin.ssm.listener;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Properties;
import org.apache.ibatis.builder.xml.dynamic.ForEachSqlNode;
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.ParameterMode;
import org.apache.ibatis.mapping.ResultMap;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Invocation;
import org.apache.ibatis.plugin.Plugin;
import org.apache.ibatis.plugin.Signature;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.reflection.property.PropertyTokenizer;
import org.apache.ibatis.session.ResultHandler;
import org.apache.ibatis.session.RowBounds;

@Intercepts(value = {
        @Signature(args = { MappedStatement.class, Object.class,
                RowBounds.class, ResultHandler.class }, method = "query", type = Executor.class),
        @Signature(type = Executor.class, method = "update", args = {
                MappedStatement.class, Object.class }) })
public class MybatisSqlListener implements Interceptor {

    private Properties properties;

    @SuppressWarnings("unchecked")
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        try {
            MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[0];
            Object parameter = invocation.getArgs()[1];
            BoundSql boundSql = mappedStatement.getBoundSql(parameter);
            List<ResultMap> resultMap = mappedStatement.getResultMaps();
            MyBatisSql<Object> myBatisSql = new MyBatisSql<Object>();
            if (resultMap != null && resultMap.size() > 0) {
                ResultMap ResultMap = mappedStatement.getResultMaps().get(0);
                myBatisSql.setResultClass(ResultMap.getType());
            }
            myBatisSql.setSql(boundSql.getSql());
            List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();
            if (parameterMappings != null) {
                Object[] parameterArray = new Object[parameterMappings.size()];
                MetaObject metaObject = parameter == null ? null : MetaObject.forObject(parameter);
                for (int i = 0; i < parameterMappings.size(); i++) {
                    ParameterMapping parameterMapping = parameterMappings.get(i);
                    if (parameterMapping.getMode() != ParameterMode.OUT) {
                        Object value;
                        String propertyName = parameterMapping.getProperty();
                        PropertyTokenizer prop = new PropertyTokenizer(propertyName);
                        if (parameter == null) {
                            value = null;
                        } else if (mappedStatement.getConfiguration().getTypeHandlerRegistry().hasTypeHandler(parameter.getClass())) {
                            value = parameter;
                        } else if (boundSql.hasAdditionalParameter(propertyName)) {
                            value = boundSql.getAdditionalParameter(propertyName);
                        } else if (propertyName.startsWith(ForEachSqlNode.ITEM_PREFIX) && boundSql.hasAdditionalParameter(prop.getName())) {
                            value = boundSql.getAdditionalParameter(prop.getName());
                            if (value != null) {
                                value = MetaObject.forObject(value).getValue(propertyName.substring(prop.getName().length()));
                            }
                        } else {
                            value = metaObject == null ? null : metaObject.getValue(propertyName);
                        }
                        parameterArray[i] = value;
                    }
                }
                myBatisSql.setParameters(parameterArray);
            }
            System.out.println("=======================SQL=========================");
            System.out.println("SQL ID:" + mappedStatement.getId());
            System.out.println(myBatisSql.toString());
        } catch (Exception e) {
            System.out.println("=======================analyze SQL error===========");
        }
        return invocation.proceed();
    }

    @Override
    public Object plugin(Object target) {
        // TODO Auto-generated method stub
        return Plugin.wrap(target, this);
    }

    @Override
    public void setProperties(Properties properties) {
        this.properties = properties;
    }

    public Properties getProperties() {
        return properties;
    }
}

class MyBatisSql<T> {
    private String sql;
    private Object[] parameters;
    private Class<T> resultClass;

    public Class<T> getResultClass() {
        return resultClass;
    }

    public void setResultClass(Class<T> resultClass) {
        this.resultClass = resultClass;
    }

    public void setSql(String sql) {
        this.sql = sql;
    }

    public String getSql() {
        return sql;
    }

    public void setParameters(Object[] parameters) {
        this.parameters = parameters;
    }

    public Object[] getParameters() {
        return parameters;
    }

    @Override
    public String toString() {
        if (parameters == null || sql == null) {
            return "";
        }
        List<Object> parametersArray = Arrays.asList(parameters);
        List<Object> list = new ArrayList<Object>(parametersArray);
        while (sql.indexOf("?") != -1 && list.size() > 0
                && parameters.length > 0) {
            sql = sql.replaceFirst("\\?", "'" + list.get(0).toString() + "'");
            list.remove(0);
        }
        return "        " + sql.replaceAll("(\r?\n(\\s*\r?\n)+)", "\r\n");
    }
}

http://srh.bankofchina.com/search/whpj/search.jsp?erectDate=2013-03-11¬hing=2013-03-11&pjname=1323

    public static String getPreMonthRate() {
        try {
            HttpURLConnection.setFollowRedirects(true);
            Calendar calendar = Calendar.getInstance();
            calendar.set(Calendar.MONTH, calendar.get(Calendar.MONTH) - 1);
            calendar.set(Calendar.DATE, calendar.getActualMaximum(Calendar.DATE));
            String d = new SimpleDateFormat("yyyy-MM-dd").format(calendar.getTime());
            String url = "http://srh.bankofchina.com/search/whpj/search.jsp?erectDate=" + d + "¬hing=" + d + "&pjname=1323";
            URL netUrl = new URL(url);
            HttpURLConnection conn = (HttpURLConnection) netUrl.openConnection();
            conn.setInstanceFollowRedirects(false);
            conn.connect();
            Parser parser = new Parser(conn);
            AndFilter andFilter = new AndFilter(new TagNameFilter("td"), new HasAttributeFilter("class","hui12_20"));
            NodeList nodes = parser.extractAllNodesThatMatch(andFilter);
            return nodes.elementAt(6).getChildren().toHtml();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

SELECT t2.request_id,
       t2.group_rn,
       COUNT(*) - 1
from
(
    select t1.*,
      t1.audit_order - IF(@groupid = concat(t1.request_id,t1.audit_status),@rank := @rank + 1,@rank := 1) group_rn,
      @groupid := concat(t1.request_id,t1.audit_status)
    from (
            SELECT 'a' request_id, 0 audit_order,1 audit_status  UNION ALL
            SELECT 'a' request_id, 1 audit_order,1 audit_status  UNION ALL
            SELECT 'a' request_id, 2 audit_order,1 audit_status  UNION ALL
            SELECT 'a' request_id, 3 audit_order,1 audit_status  UNION ALL
            SELECT 'a' request_id, 4 audit_order,9 audit_status  UNION ALL
            SELECT 'a' request_id, 5 audit_order,1 audit_status  UNION ALL
            SELECT 'a' request_id, 6 audit_order,2 audit_status  UNION ALL
            SELECT 'a' request_id, 7 audit_order,0 audit_status  UNION ALL
            SELECT 'b' request_id, 0 audit_order,1 audit_status  UNION ALL
            SELECT 'b' request_id, 1 audit_order,1 audit_status  UNION ALL
            SELECT 'b' request_id, 2 audit_order,1 audit_status  UNION ALL
            SELECT 'b' request_id, 3 audit_order,0 audit_status  UNION ALL
            SELECT 'c' request_id, 0 audit_order,1 audit_status  UNION ALL
            SELECT 'c' request_id, 1 audit_order,9 audit_status  UNION ALL
            SELECT 'c' request_id, 2 audit_order,1 audit_status  UNION ALL
            SELECT 'c' request_id, 3 audit_order,2 audit_status  UNION ALL
            SELECT 'd' request_id, 0 audit_order,9 audit_status  UNION ALL
            SELECT 'd' request_id, 1 audit_order,1 audit_status  UNION ALL
            SELECT 'd' request_id, 2 audit_order,1 audit_status  UNION ALL
            SELECT 'd' request_id, 3 audit_order,2 audit_status
        ) t1,
        (SELECT @rank := 0,@groupid := '') m
) t2
 WHERE t2.group_rn = -1
 GROUP BY t2.request_id,
          t2.group_rn
 ORDER BY t2.request_id,
          t2.group_rn

SELECT h.*
  FROM (
    SELECT m.*,
           CASE WHEN m.audit_status = 0 THEN @rownum := 0
                ELSE IF(@groupid = m.request_id,@rownum := @rownum + 1,@rownum := 1)
           END last_confirmer,
           @groupid := m.request_id
      FROM (
      	    SELECT t1.*
              FROM tb t1
             WHERE t1.request_id IN
                       (SELECT t.request_id
                          FROM tb t
                         GROUP BY t.request_id
                        HAVING SUM(CASE WHEN t.audit_status = 1 THEN 0 
                        	            WHEN t.audit_status = 8 THEN - 999 ELSE 1 END) > 0)
             ORDER BY t1.request_id,t1.audit_order DESC
            ) m,
            (SELECT @groupid := '',@rownum := 0) n
        ) h
 where h.last_confirmer = 1

SELECT 'a' request_id, 0 audit_order,1 audit_status,'a' group_id UNION ALL
SELECT 'a' request_id, 1 audit_order,0 audit_status,'a' group_id UNION ALL
SELECT 'a' request_id, 2 audit_order,0 audit_status,'a' group_id UNION ALL
SELECT 'a' request_id, 3 audit_order,0 audit_status,'a' group_id UNION ALL

SELECT 'b' request_id, 0 audit_order,1 audit_status,'b' group_id UNION ALL
SELECT 'b' request_id, 1 audit_order,1 audit_status,'b' group_id UNION ALL
SELECT 'b' request_id, 2 audit_order,1 audit_status,'b' group_id UNION ALL
SELECT 'b' request_id, 3 audit_order,0 audit_status,'b' group_id UNION ALL

SELECT 'c' request_id, 0 audit_order,1 audit_status,'c' group_id UNION ALL
SELECT 'c' request_id, 1 audit_order,1 audit_status,'c' group_id UNION ALL
SELECT 'c' request_id, 2 audit_order,1 audit_status,'c' group_id UNION ALL
SELECT 'c' request_id, 3 audit_order,1 audit_status,'c' group_id UNION ALL

SELECT 'd' request_id, 0 audit_order,9 audit_status,'d' group_id UNION ALL
SELECT 'd' request_id, 1 audit_order,1 audit_status,'d' group_id UNION ALL
SELECT 'd' request_id, 2 audit_order,1 audit_status,'d' group_id UNION ALL
SELECT 'd' request_id, 3 audit_order,2 audit_status,'d' group_id UNION ALL
SELECT 'd' request_id, 4 audit_order,0 audit_status,'d' group_id UNION ALL

SELECT 'e' request_id, 0 audit_order,1 audit_status,'e' group_id UNION ALL
SELECT 'e' request_id, 1 audit_order,0 audit_status,'e' group_id UNION ALL
SELECT 'e' request_id, 2 audit_order,1 audit_status,'e' group_id UNION ALL
SELECT 'e' request_id, 3 audit_order,2 audit_status,'e' group_id UNION ALL
SELECT 'e' request_id, 4 audit_order,0 audit_status,'e' group_id UNION ALL

SELECT 'f' request_id, 0 audit_order,8 audit_status,'f' group_id UNION ALL
SELECT 'f' request_id, 1 audit_order,1 audit_status,'f' group_id UNION ALL
SELECT 'f' request_id, 2 audit_order,1 audit_status,'f' group_id UNION ALL
SELECT 'f' request_id, 3 audit_order,2 audit_status,'f' group_id UNION ALL
SELECT 'f' request_id, 4 audit_order,0 audit_status,'f' group_id UNION ALL

SELECT 'g' request_id, 0 audit_order,1 audit_status,'f' group_id UNION ALL
SELECT 'g' request_id, 1 audit_order,0 audit_status,'f' group_id UNION ALL
SELECT 'g' request_id, 2 audit_order,0 audit_status,'f' group_id

<html xmlns:t="http://tapestry.apache.org/schema/tapestry_5_1_0.xsd">
    <head>
        <title>app Start Page</title>
    </head>
    <body>
        <t:form>
            
			<t:loop t:source="files" t:value="currentFile" t:index="index">
		        <input t:type="upload" t:value="currentFile" />
		        <br/>
		    </t:loop>
    
            <input type="submit" value="Upload"/>
        </t:form>
    </body>
</html>

package cn.tradewin.action.pages;

import java.io.File;

import org.apache.tapestry5.annotations.Property;
import org.apache.tapestry5.upload.services.UploadedFile;

public class Main {
	@Property
	private UploadedFile[] files = new UploadedFile[2];
	
	@Property
	private int index;
	
	
	public UploadedFile getCurrentFile() {
		return files[index];
	}

	public void setCurrentFile(UploadedFile currentFile) {
		files[index] = currentFile;
	}

	public void onSuccess() {
		try {
			if (files != null) {
				for (UploadedFile file : files) {
					File copied = new File("C:/" + file.getFileName());
					file.write(copied);
					System.out.println(file.getFileName());
				}					
			} else {
				System.out.println("null");
			}
		
		} catch(Exception e) {
			e.printStackTrace();
		}
	}
}


	
	void pageLoaded() {
		log.info("==========================pageLoaded");
	}
	void pageAttached() {
		log.info("==========================pageAttached");
	}
	
	void onPassivate() {
		log.info("==========================onPassivate");
	}
	
	void pageDetached() {
		log.info("==========================pageDetached");
	}
	
	void onActivate() {
		log.info("==========================onActivate");
	}
	void SetupRender() {
		log.info("==========================SetupRender");
	}
	
	void beginRender() {
		log.info("==========================beginRender");
	}
	
	void onPrepareForRender() {
		log.info("==========================onPrepareForRender");
	}
	
	void onPrepare() {
		log.info("==========================onPrepare");
	}
	
	void afterRender() {
		log.info("==========================afterRender");
	}
	
	void cleanupRender() {
		log.info("==========================cleanupRender");
	}
	
	void onAction() {
		log.info("==========================onAction");
	}
	
	void onPrepareForSubmit() {
		log.info("==========================onPrepareForSubmit");
	}
	
	void onSelected() {
		log.info("==========================onSelected");
	}
	
	void onSuccess() {
		log.info("==========================onSuccess");
	}
	
	void onSubmit() {
		log.info("==========================onSubmit");
	}

<!DOCTYPE html>
<html>
    <head>
        <title>Main</title>
        <meta charset="UTF-8">
        <link rel="stylesheet" href="yaml/core/base.css" />
        <link rel="stylesheet" href="yaml/navigation/hlist.css" />
        <link rel="stylesheet" href="yaml/forms/gray-theme.css" />        
        <link rel="stylesheet" href="yaml/screen/typography.css" />
        <link rel="stylesheet" href="yaml/screen/screen-PAGE-layout.css" />
        <link rel="stylesheet" href="yaml/print/print.css" />
        <!--
        <link rel="stylesheet" href="yaml/core/base.css" />
        <link rel="stylesheet" href="yaml/navigation/hlist.css" />
        <link rel="stylesheet" href="yaml/forms/gray-theme.css" />        
        <link rel="stylesheet" href="yaml/screen/typography.css" />
        <link rel="stylesheet" href="yaml/screen/screen-PAGE-layout.css" />
        <link rel="stylesheet" href="yaml/print/print.css" />
        <link rel="stylesheet" href="css/my_hlist.css" />
        -->
        
        
        <style type="text/css">
.ym-hlist {
    overflow: auto;
    position: static;
}
.ym-hlist ul li li {
    width: 188px;
}
/*
.ym-hlist ul {
    padding-right: 0px; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px; list-style-type: none;
}
.ym-hlist ul ul {
    padding-right: 0px; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px; list-style-type: none;
}
*/
.ym-hlist ul ul {
    padding-right: 0px; 
    display: none;
    margin-top: 7px;
    padding-left: 0px; 
    z-index: 2000; 
    background: red left bottom; 
    padding-bottom: 18px; padding-top: 0px; position: absolute; top: auto;
}
.ym-hlist ul ul ul {
    margin-top: 1px; left: 100%; margin-left: -1px; top: 0px;
}
.ym-hlist ul li {
    float: left; 
    margin-left: -1px; 
    margin-right: 20px;
    line-height:1.0em;
}
.ym-hlist ul li li {
    margin-top: -1px; float: none; margin-left: 0px; margin-right: 0px; position: relative;
}

.ym-hlist ul li:hover ul {
    display: none
}

.ym-hlist ul li:hover ul {
    display: block;
}




        </style>
    </head>
    <body>
        <div class="ym-wrapper">
            <div class="ym-wbox">
                <!-- head -->
                <header>
                    This is head
                </header>

                <!-- navigation -->
                <nav id="nav">
                    <div class="ym-hlist">
                        <ul>
                            <li>
                                <a><span>FFFFF</span></a>
                                <ul>
                                    <li>
                                        <a><span>AAA</span></a>
                                    </li>
                                    <li>
                                        <a><span>BBB</span></a>
                                    </li>
                                </ul>
                            </li>
                            <li><a href="#">Link</a></li>
                            <li><a href="#">Link</a></li>
                            <li><a href="#">Link</a></li>
                            <li><a href="#">Link</a></li>
                        </ul>
                        <form class="ym-searchform">
                            <input class="ym-searchfield" type="search" placeholder="Search...">
                            <input class="ym-searchbutton" type="submit" value="Search">
                        </form>
                    </div>
                </nav>
                <!-- main -->
                <div id="main">
                    <section class="box info" style="height:400px;">
                        <h2>Main Content</h2>
                        <p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
                        <a class="ym-button ym-next" href="#">Read More</a>

                        <table class="bordertable narrow">
                            <thead>
                                <tr>
                                    <th>Id</th>
                                    <th>Product Name</th>
                                    <th>Value</th>
                                </tr>
                            </thead>
                            <tbody>

                            </tbody>
                            <tr>
                                <td>aaa</td>
                                <td>bbb</td>
                                <td>ccc</td>
                            </tr>
                            <tr>
                                <td>aaa</td>
                                <td>bbb</td>
                                <td>ccc</td>
                            </tr>
                        </table>
                    </section>
                </div>
            </div>
        </div>

    </body>
</html>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	<title>Untitled</title>
    <style>
    /*
#primary-nav ul {
	display: none;
}
#primary-nav li:hover ul {
	display: block;
}
*/
#primary-nav li li {
	width: 188px;
}
#primary-nav, #primary-nav ul {
	list-style: none;
	margin: 0px;
	padding: 0px;
}
#primary-nav ul {
	position: absolute;
	top: auto;
	display: none;
	padding: 0px 0px 18px;
	background: url(http://themes.cmsmadesimple.org/uploads/new2col/uldrop.png) left bottom;
	z-index:2000;
}
#primary-nav ul ul {
	margin-top: 1px;
	margin-left: -1px;
	left: 100%;
	top: 0px;
}
#primary-nav li {
	margin-left: -1px;
    margin-right:20px;
	float: left;
}
#primary-nav li li {
	margin-left: 0px;
	margin-top: -1px;
    margin-right:0px;
	float: none;
	position: relative;
}
#primary-nav a {
	display: block;
	margin: 0px;
	padding: 0px 0px;
	text-decoration: none;
	color: #FFF;
	background-image: url(http://themes.cmsmadesimple.org/uploads/new2col/lilft.png);
	background-repeat: no-repeat;
    background-position: left top;
}
#primary-nav a span {
	display: block;
	margin: 0px;
	padding: 6px 10px 7px;
	text-decoration: none;
	color: #FFF;
	background-image: url(http://themes.cmsmadesimple.org/uploads/new2col/lirt.png);
	background-repeat: no-repeat;
    background-position: right top;
}
#primary-nav li a {
}
#primary-nav li li a, #primary-nav li li a span {
	background-image: none;
}
#primary-nav li li {
        border-bottom: 1px solid
}
#primary-nav li.menuactive a,
#primary-nav li:hover a,
#primary-nav li.menuh a,
#primary-nav li.menuparenth a,
#primary-nav li.menuactiveh a {
	background-position: left -25px;
}
#primary-nav li.menuactive a span,
#primary-nav li:hover a span,
#primary-nav li.menuh a span,
#primary-nav li.menuparenth a span,
#primary-nav li.menuactiveh a span {
	background-position: right -25px;
}
#primary-nav li:hover a span,
#primary-nav li.menuh a span,
#primary-nav li.menuparenth a span,
#primary-nav li.menuactiveh a span {
	padding: 6px 10px 16px;
}
#primary-nav li:hover li a span,
#primary-nav li.menuh li a span,
#primary-nav li.menuparenth li a span,
#primary-nav li.menuactiveh li a span {
	padding: 10px 0px 10px 10px;
}
#primary-nav ul li.menuparent,
#primary-nav ul li.menuparent:hover,
#primary-nav ul li.menuparenth {
	background-image: url(http://themes.cmsmadesimple.org/uploads/new2col/arrow.gif);
	background-position: center right;
	background-repeat: no-repeat;
}
#primary-nav li li:hover,
#primary-nav li li.menuh,
#primary-nav li li.menuparenth,
#primary-nav li li.menuactiveh {
	background: url(http://themes.cmsmadesimple.org/uploads/new2col/dropactive.png);
}
#primary-nav ul,
#primary-nav li:hover ul,
#primary-nav li:hover ul ul,
#primary-nav li:hover ul ul ul,
#primary-nav li.menuparenth ul,
#primary-nav li.menuparenth ul ul,
#primary-nav li.menuparenth ul ul ul {
	display: none;
}
#primary-nav li:hover ul,
#primary-nav ul li:hover ul,
#primary-nav ul ul li:hover ul,
#primary-nav ul ul ul li:hover ul,
#primary-nav li.menuparenth ul,
#primary-nav ul li.menuparenth ul,
#primary-nav ul ul li.menuparenth ul,
#primary-nav ul ul ul li.menuparenth ul {
	display: block;
}
/* IE Hacks */
#primary-nav li li {
	float: left;
	clear: both;
}
#primary-nav li li a {
	height: 1%;
}
    </style>
</head>

<body>

          <ul id="primary-nav">
            <li>
              <a href="http://www.cmsmadesimple.org/"><span>CMS Made Simple</span></a>
            </li>

            <li class="menuparent">
              <a class="menuparent" href="http://themes.cmsmadesimple.org/"><span>Home</span></a>
              <ul class="unli">
                <li>
                  <a href="http://themes.cmsmadesimple.org/Download_Themes/Full_Themes.html"><span>Browse all Full Themes</span></a>
                </li>

                <li>
                  <a href="http://themes.cmsmadesimple.org/Download_Themes/Theme_Frameworks.html"><span>Browse all Basic Themes</span></a>
                </li>
              </ul>
            </li>
          </ul>

</body>
</html>

SELECT MIN(UNIQUE_ID)
  FROM sms.VIEW_Q_MT_107710 A
 WHERE UNIQUE_ID > (SELECT B.UNIQUE_ID_END
                      FROM sms.Q_INFO B
                     WHERE B.Q_KEY = 'MT_107710')
                     
Elapsed: 00:00:37.25

Execution Plan
----------------------------------------------------------
Plan hash value: 755455310

--------------------------------------------------------------------------------------------------
| Id  | Operation                       | Name                  | Rows  | Bytes | Cost(%CPU) | Time      |
--------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                |                       |     1 |    14 | 10273   (2)| 00:02:04  |
|   1 |  SORT AGGREGATE                 |                       |     1 |    14 |            |           |
|*  2 |   VIEW                          | index$_join$_003      | 48673 |   665K| 10272   (2)| 00:02:04  |
|*  3 |    HASH JOIN                    |                       |       |       |            |           |
|*  4 |     INDEX FAST FULL SCAN        | IDX_AREA_ID_Q_MT      | 48673 |   665K|  3777   (2)| 00:00:46  |
|   5 |     INDEX FAST FULL SCAN        | PK_Q_MT_PART          | 48673 |   665K|  3773   (2)| 00:00:46  |
|   6 |    TABLE ACCESS BY INDEX ROWID  | Q_INFO                |     1 |    15 |     1   (0)| 00:00:01  |
|*  7 |     INDEX UNIQUE SCAN           | PK_Q_INFO             |     1 |       |     0   (0)| 00:00:01  |

--------------------------------------------------------------------------------------------------


Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("AREA_ID"='107710' AND "UNIQUE_ID"> (SELECT "B"."UNIQUE_ID_END" FROM "SMS"."Q_INFO" "B" WHERE "B"."Q_KEY"='MT_107710'))
   3 - access(ROWID=ROWID)
   4 - filter("AREA_ID"='107710')
   7 - access("B"."Q_KEY"='MT_107710')

Statistics
----------------------------------------------------------
307   recursive calls
  2   db block gets
6987  consistent gets
20832 physical reads
132   redo size
421   bytes sent via SQL*Net to client
385   bytes received via SQL*Net from client
  2   SQL*Net roundtrips to/from client
  5   sorts (memory)
  0   sorts (disk)
  1   rows processed

CREATE OR REPLACE PACKAGE BODY five IS

SUBTYPE v IS VARCHAR(99);

TYPE POINT_TYPE IS RECORD (
    row_idx v,
    col_idx v,
    point_value v,
    status v
);

TYPE POINT_ARRAYS_TYPE IS TABLE OF POINT_TYPE INDEX BY BINARY_INTEGER;

TYPE SHAPE_TYPE IS RECORD (
    row_width v,
    col_width v,
    shape_id  v,
    shape_value v,
    points POINT_ARRAYS_TYPE,
    min_point POINT_TYPE,
    shape_cnt v,
    isBaseShape v
);

TYPE SHAPE_LIST_TYPE IS TABLE OF SHAPE_TYPE INDEX BY BINARY_INTEGER;

TYPE HASH_MAP_TYPE IS TABLE OF v INDEX BY v;

TYPE row_type IS TABLE OF POINT_ARRAYS_TYPE INDEX BY BINARY_INTEGER;

TYPE array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
a array_type;
M NUMBER := 25;
N NUMBER := 5;
shape_list SHAPE_LIST_TYPE;

--point_arrays POINT_ARRAYS_TYPE;

point_values row_type;

shape_null SHAPE_TYPE;

g_shape SHAPE_TYPE;
g_point POINT_TYPE;
g_v1 v;
g_v2 v;
loop_cnt NUMBER;

CURSOR c1 IS
WITH t AS (
    SELECT LEVEL - 1 idx,LEVEL v FROM DUAL CONNECT BY LEVEL <= 5
)
,tb AS (
    SELECT t1.idx row_idx,t2.idx col_idx,t1.idx * 5 + t2.v v FROM t t1,t t2
)
SELECT a.row_idx row_idx1,
       a.col_idx col_idx1,
       b.row_idx row_idx2,
       b.col_idx col_idx2,
       c.row_idx row_idx3,
       c.col_idx col_idx3,
       d.row_idx row_idx4,
       d.col_idx col_idx4,
       e.row_idx row_idx5,
       e.col_idx col_idx5,
       GREATEST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) - LEAST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) + 1 row_width,
       GREATEST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) - LEAST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) + 1 col_width,
       LEAST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) min_row,
       LEAST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) min_col
  FROM tb a,
       tb b,
       tb c,
       tb d,
       tb e
 WHERE a.v < b.v
   AND b.v < c.v
   AND c.v < d.v
   AND d.v < e.v;

PROCEDURE p(s v,f v DEFAULT '')
AS
BEGIN
    IF f=1 THEN
        DBMS_OUTPUT.PUT_LINE(s);
    ELSE
        DBMS_OUTPUT.PUT(s);
    END IF;
    
END;

PROCEDURE printShape(shape SHAPE_TYPE,flag v) IS
    tmp_arrays row_type;
BEGIN
    tmp_arrays := point_values;
    FOR i IN shape.points.FIRST .. shape.points.LAST LOOP
        tmp_arrays(shape.points(i).row_idx)(shape.points(i).col_idx).status := 1;
    END LOOP;

    FOR i IN 0..4 LOOP
        IF i=2 THEN
            IF flag = 1 THEN
                p(RPAD(shape.shape_value,10,' '));
            ELSE
                p(RPAD(shape.shape_value,14,' ') || RPAD(shape.shape_cnt,10,' '));
            END IF;
        ELSE
            IF flag = 1 THEN
                p(RPAD(' ',10,' '));
            ELSE
                p(RPAD(' ',24,' '));
            END IF;
        END IF;
        FOR j IN 0..4 LOOP
            IF tmp_arrays(i)(j).status=1 THEN
                p('■');
            ELSE
                p('□');
            END IF;
        END LOOP;
        p('',1);
    END LOOP;
    p(' ',1);
END;

FUNCTION getShapeId(points POINT_ARRAYS_TYPE) RETURN v IS
    str v;
    tab sys.owa_util.num_arr;
    type sorted_tab is table of v index by BINARY_INTEGER;
    sorted sorted_tab;
    id1 pls_integer;
    id2 v;
BEGIN
    FOR i IN points.FIRST .. points.LAST LOOP
        tab(i) := point_values(points(i).row_idx)(points(i).col_idx).point_value;
    END LOOP;
    id1 := tab.FIRST;
    WHILE id1 IS NOT NULL LOOP
            sorted(tab(id1)) := tab(id1);
            id1 := tab.NEXT(id1);
    END LOOP;
    id2  := sorted.FIRST;
    WHILE id2 IS NOT NULL LOOP
            str := str || '_' || sorted(id2);
            id2 := sorted.NEXT(id2);
    END LOOP;
    RETURN str;
END;

FUNCTION isCorrectShape(shape SHAPE_TYPE) RETURN BOOLEAN IS
    p_map POINT_ARRAYS_TYPE;
    --points POINT_ARRAYS_TYPE := shape.points;
    point_value v;
BEGIN
    --p_map := point_arrays;
    FOR i IN 0 .. 4 LOOP
        FOR j IN 0 .. 4 LOOP
            g_point := shape.points(j);
            point_value := point_values(g_point.row_idx)(g_point.col_idx).point_value;
            IF NOT p_map.EXISTS(point_value) THEN
                g_v1:=0;
                IF p_map.COUNT = 0 THEN
                    g_v1:=1;
                END IF;
                g_v2 := p_map.FIRST;
                WHILE g_v2 IS NOT NULL LOOP
                    IF (g_point.col_idx = p_map(g_v2).col_idx AND ABS(g_point.row_idx - p_map(g_v2).row_idx) = 1) OR
                       (g_point.row_idx = p_map(g_v2).row_idx AND ABS(g_point.col_idx - p_map(g_v2).col_idx) = 1) THEN
                       g_v1:=1;
                    END IF;
                    g_v2 := p_map.NEXT(g_v2);
                END LOOP;
               IF g_v1=1 THEN
                    p_map(point_value) := g_point;
                    EXIT;
               END IF;
            END IF;
        END LOOP;
    END LOOP;
    RETURN p_map.COUNT=5;
END;

FUNCTION rotateMirrorShape(shape SHAPE_TYPE,flag v) RETURN SHAPE_TYPE IS
    row_idx v;
    col_idx v;
    min_row v;
    min_col v;
    newShape SHAPE_TYPE;
    sum_val v := 0;
BEGIN
    newShape.row_width := shape.col_width;
    newShape.col_width := shape.row_width;
    IF flag = 5 THEN
        newShape.row_width := shape.row_width;
        newShape.col_width := shape.col_width;
    END IF;
    min_row := shape.min_point.row_idx;
    min_col := shape.min_point.col_idx;
    FOR i IN 0..4 LOOP
        IF flag = 5 THEN
            row_idx := shape.points(i).row_idx;
            col_idx := newShape.col_width - shape.points(i).col_idx - 1;
        ELSE
            row_idx := -shape.points(i).col_idx + min_col+ newShape.row_width - 1;
            col_idx := shape.points(i).row_idx - min_row;
        END IF;
        newShape.points(i).row_idx := row_idx;
        newShape.points(i).col_idx := col_idx;
        sum_val := sum_val + point_values(row_idx)(col_idx).point_value;
    END LOOP;
    newShape.min_point.row_idx := 0;
    newShape.min_point.col_idx := 0;
    newShape.shape_value := sum_val;
    newShape.shape_id := getShapeId(newShape.points);
    RETURN newShape;
END;

PROCEDURE selectShape(flag v) IS
    newShape SHAPE_TYPE;
    shape_map HASH_MAP_TYPE;
    min_shape_value v := 0;
    min_shape_value_index v := 0;
    min_shape_id v;
    rn v;
    not_exists_flag v;
    shape_cnt v;
    newPoint POINT_TYPE;
    tmp_shape   SHAPE_TYPE;
BEGIN
    shape_list.DELETE;

    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            newPoint.row_idx := i;
            newPoint.col_idx := j;
            newPoint.point_value := i * 5 + j + 1;
            newPoint.status := 0;
            point_values(i)(j) := newPoint;
        END LOOP;
    END LOOP;
    
    OPEN c1;
    LOOP
       newShape := shape_null;
       FETCH c1 INTO newShape.points(0).row_idx,newShape.points(0).col_idx,
                     newShape.points(1).row_idx,newShape.points(1).col_idx,
                     newShape.points(2).row_idx,newShape.points(2).col_idx,
                     newShape.points(3).row_idx,newShape.points(3).col_idx,
                     newShape.points(4).row_idx,newShape.points(4).col_idx,
                     newShape.row_width,
                     newShape.col_width,
                     newShape.min_point.row_idx,
                     newShape.min_point.col_idx;
       EXIT WHEN c1%NOTFOUND;
       IF isCorrectShape(newShape) THEN
           min_shape_value_index := 0;
           min_shape_value := 0;
           not_exists_flag := 0;
           shape_cnt := 0;
           FOR i IN 1 .. 8 LOOP
               newShape := rotateMirrorShape(newShape,i);
               IF NOT shape_map.EXISTS(newShape.shape_id) THEN
                   rn := shape_list.COUNT;
                   shape_list(rn) :=  newShape;
                   shape_map(newShape.shape_id) := newShape.shape_id;
                   shape_cnt := shape_cnt + 1;
                   IF min_shape_value = 0 OR newShape.shape_value < min_shape_value OR newShape.shape_value = min_shape_value AND newShape.shape_id < min_shape_id THEN
                       min_shape_value := newShape.shape_value;
                       min_shape_value_index := rn;
                       min_shape_id := newShape.shape_id;
                   END IF;
                   not_exists_flag := 1;
               END IF;
           END LOOP;
           IF not_exists_flag=1 THEN
               shape_list(min_shape_value_index).isBaseShape := 1;
               shape_list(min_shape_value_index).shape_cnt := shape_cnt;
           END IF;
       END IF;
    END LOOP;

    FOR i IN REVERSE 0 .. shape_list.COUNT - 1
    LOOP
      FOR j  IN 1 .. i
      LOOP
          g_shape := shape_list(j-1);
          IF g_shape.shape_value < shape_list(j).shape_value OR g_shape.shape_value = shape_list(j).shape_value AND g_shape.shape_id < shape_list(j).shape_id THEN
              tmp_shape := g_shape;
              shape_list (j-1) := shape_list (j);
              shape_list (j) := tmp_shape;
          END IF;
      END LOOP;
      IF flag=1 OR shape_list(i).isBaseShape = 1 THEN
          printShape(shape_list(i),flag);
      END IF;
    END LOOP;
    
    CLOSE c1;
END;

PROCEDURE printArray(r array_type) IS
    str v;
BEGIN
    FOR i IN r.FIRST .. r.LAST LOOP
        str := str || ',' || r(i);
    END LOOP;
    dbms_output.put_line(str);
    --loopShape(0, 1, r, 5);
END;

PROCEDURE processShape(r array_type) IS
    newShape SHAPE_TYPE;
    max_col_idx NUMBER := 0;
    min_col_idx NUMBER := 0;
BEGIN
    NULL;
    newShape := shape_null;
    FOR i IN r.FIRST .. r.LAST LOOP
        NULL;
        newShape := shape_null;
        newShape.points(i).row_idx := CEIL(r(i) / 5);
        newShape.points(i).col_idx := r(i) - 5 * (CEIL(r(i) / 5) - 1) - 1;
        IF newShape.points(i).col_idx > max_col_idx THEN
            max_col_idx := newShape.points(i).col_idx;
        END IF;
        IF newShape.points(i).col_idx < min_col_idx OR min_col_idx=0 THEN
            min_col_idx := newShape.points(i).col_idx;
        END IF;
    END LOOP;
    IF r(0) > 0 OR min_col_idx > 0 THEN
        RETURN;
    END IF;
    newShape.row_width := r(r.COUNT-1) - r(0) + 1;
    newShape.col_width := max_col_idx - min_col_idx + 1;
    
    IF isCorrectShape(newShape) THEN
        NULL;
    ELSE
        RETURN;
    END IF;
END;
PROCEDURE recursionShape(head NUMBER, idx NUMBER,r IN OUT array_type, k NUMBER) IS

BEGIN
    FOR i IN head .. a.COUNT + idx - k - 1 LOOP
        IF idx < k THEN
            r(idx - 1) := a(i);
            recursionShape(i + 1, idx + 1, r, k);
        ELSIF idx = k THEN
            r(idx - 1) := a(i);
            --//printArray(r);
            processShape(r);
            --loop_cnt := loop_cnt + 1;
            recursionShape(i + 1, idx + 1, r, k);
        ELSE
            RETURN;
        END IF;
    END LOOP;
END;

PROCEDURE loopShape(head NUMBER, idx NUMBER,r IN OUT array_type, k NUMBER) IS

BEGIN
    FOR i IN head .. a.COUNT + idx - k - 1 LOOP
        IF idx < k THEN
            r(idx - 1) := a(i);
            recursionShape(i + 1, idx + 1, r, k);
        ELSIF idx = k THEN
            r(idx - 1) := a(i);
            --printArray(r);
            loop_cnt := loop_cnt + 1;
            recursionShape(i + 1, idx + 1, r, k);
        ELSE
            RETURN;
        END IF;
    END LOOP;
END;

PROCEDURE output_allshapes IS
    r array_type;
BEGIN
    
    FOR i IN 1 .. M LOOP
        a(i-1) := i;
    END LOOP;
    loop_cnt := 0;
    recursionShape(0, 1, r, N);
    dbms_output.put_line(loop_cnt);
END;

PROCEDURE output_allbaseshapes IS
BEGIN
    p('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);
    selectShape(2);
END;


END five;

http://fsh430623.iteye.com/blog/752595

CREATE OR REPLACE PACKAGE BODY five IS

SUBTYPE v IS VARCHAR(99);

TYPE POINT_TYPE IS RECORD (
    row_idx v,
    col_idx v,
    point_value v,
    status v
);

TYPE POINT_ARRAYS_TYPE IS TABLE OF POINT_TYPE INDEX BY BINARY_INTEGER;

TYPE SHAPE_TYPE IS RECORD (
    row_width v,
    col_width v,
    shape_id  v,
    shape_value v,
    points POINT_ARRAYS_TYPE,
    min_point POINT_TYPE,
    shape_cnt v,
    isBaseShape v
);

TYPE SHAPE_LIST_TYPE IS TABLE OF SHAPE_TYPE INDEX BY BINARY_INTEGER;

TYPE HASH_MAP_TYPE IS TABLE OF v INDEX BY v;

TYPE row_type IS TABLE OF POINT_ARRAYS_TYPE INDEX BY BINARY_INTEGER;

TYPE array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
a array_type;
shape_list SHAPE_LIST_TYPE;

--point_arrays POINT_ARRAYS_TYPE;

point_values row_type;

shape_null SHAPE_TYPE;

g_shape SHAPE_TYPE;
g_point POINT_TYPE;
g_v1 v;
g_v2 v;
loop_cnt NUMBER;

CURSOR c1 IS
WITH t AS (
    SELECT LEVEL - 1 idx,LEVEL v FROM DUAL CONNECT BY LEVEL <= 5
)
,tb AS (
    SELECT t1.idx row_idx,t2.idx col_idx,t1.idx * 5 + t2.v v FROM t t1,t t2
)
SELECT a.row_idx row_idx1,
       a.col_idx col_idx1,
       b.row_idx row_idx2,
       b.col_idx col_idx2,
       c.row_idx row_idx3,
       c.col_idx col_idx3,
       d.row_idx row_idx4,
       d.col_idx col_idx4,
       e.row_idx row_idx5,
       e.col_idx col_idx5,
       GREATEST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) - LEAST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) + 1 row_width,
       GREATEST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) - LEAST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) + 1 col_width,
       LEAST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) min_row,
       LEAST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) min_col
  FROM tb a,
       tb b,
       tb c,
       tb d,
       tb e
 WHERE a.v < b.v
   AND b.v < c.v
   AND c.v < d.v
   AND d.v < e.v;

PROCEDURE p(s v,f v DEFAULT '')
AS
BEGIN
    IF f=1 THEN
        DBMS_OUTPUT.PUT_LINE(s);
    ELSE
        DBMS_OUTPUT.PUT(s);
    END IF;
    
END;

PROCEDURE printShape(shape SHAPE_TYPE,flag v) IS
    tmp_arrays row_type;
BEGIN
    tmp_arrays := point_values;
    FOR i IN shape.points.FIRST .. shape.points.LAST LOOP
        tmp_arrays(shape.points(i).row_idx)(shape.points(i).col_idx).status := 1;
    END LOOP;

    FOR i IN 0..4 LOOP
        IF i=2 THEN
            IF flag = 1 THEN
                p(RPAD(shape.shape_value,10,' '));
            ELSE
                p(RPAD(shape.shape_value,14,' ') || RPAD(shape.shape_cnt,10,' '));
            END IF;
        ELSE
            IF flag = 1 THEN
                p(RPAD(' ',10,' '));
            ELSE
                p(RPAD(' ',24,' '));
            END IF;
        END IF;
        FOR j IN 0..4 LOOP
            IF tmp_arrays(i)(j).status=1 THEN
                p('■');
            ELSE
                p('□');
            END IF;
        END LOOP;
        p('',1);
    END LOOP;
    p(' ',1);
END;

FUNCTION getShapeId(points POINT_ARRAYS_TYPE) RETURN v IS
    str v;
    tab sys.owa_util.num_arr;
    type sorted_tab is table of v index by BINARY_INTEGER;
    sorted sorted_tab;
    id1 pls_integer;
    id2 v;
BEGIN
    FOR i IN points.FIRST .. points.LAST LOOP
        tab(i) := point_values(points(i).row_idx)(points(i).col_idx).point_value;
    END LOOP;
    id1 := tab.FIRST;
    WHILE id1 IS NOT NULL LOOP
            sorted(tab(id1)) := tab(id1);
            id1 := tab.NEXT(id1);
    END LOOP;
    id2  := sorted.FIRST;
    WHILE id2 IS NOT NULL LOOP
            str := str || '_' || sorted(id2);
            id2 := sorted.NEXT(id2);
    END LOOP;
    RETURN str;
END;

FUNCTION isCorrectShape(shape SHAPE_TYPE) RETURN BOOLEAN IS
    p_map POINT_ARRAYS_TYPE;
    --points POINT_ARRAYS_TYPE := shape.points;
    point_value v;
BEGIN
    --p_map := point_arrays;
    FOR i IN 0 .. 4 LOOP
        FOR j IN 0 .. 4 LOOP
            g_point := shape.points(j);
            point_value := point_values(g_point.row_idx)(g_point.col_idx).point_value;
            IF NOT p_map.EXISTS(point_value) THEN
                g_v1:=0;
                IF p_map.COUNT = 0 THEN
                    g_v1:=1;
                END IF;
                g_v2 := p_map.FIRST;
                WHILE g_v2 IS NOT NULL LOOP
                    IF (g_point.col_idx = p_map(g_v2).col_idx AND ABS(g_point.row_idx - p_map(g_v2).row_idx) = 1) OR
                       (g_point.row_idx = p_map(g_v2).row_idx AND ABS(g_point.col_idx - p_map(g_v2).col_idx) = 1) THEN
                       g_v1:=1;
                    END IF;
                    g_v2 := p_map.NEXT(g_v2);
                END LOOP;
               IF g_v1=1 THEN
                    p_map(point_value) := g_point;
                    EXIT;
               END IF;
            END IF;
        END LOOP;
    END LOOP;
    RETURN p_map.COUNT=5;
END;

FUNCTION rotateMirrorShape(shape SHAPE_TYPE,flag v) RETURN SHAPE_TYPE IS
    row_idx v;
    col_idx v;
    min_row v;
    min_col v;
    newShape SHAPE_TYPE;
    sum_val v := 0;
BEGIN
    newShape.row_width := shape.col_width;
    newShape.col_width := shape.row_width;
    IF flag = 5 THEN
        newShape.row_width := shape.row_width;
        newShape.col_width := shape.col_width;
    END IF;
    min_row := shape.min_point.row_idx;
    min_col := shape.min_point.col_idx;
    FOR i IN 0..4 LOOP
        IF flag = 5 THEN
            row_idx := shape.points(i).row_idx;
            col_idx := newShape.col_width - shape.points(i).col_idx - 1;
        ELSE
            row_idx := -shape.points(i).col_idx + min_col+ newShape.row_width - 1;
            col_idx := shape.points(i).row_idx - min_row;
        END IF;
        newShape.points(i).row_idx := row_idx;
        newShape.points(i).col_idx := col_idx;
        sum_val := sum_val + point_values(row_idx)(col_idx).point_value;
    END LOOP;
    newShape.min_point.row_idx := 0;
    newShape.min_point.col_idx := 0;
    newShape.shape_value := sum_val;
    newShape.shape_id := getShapeId(newShape.points);
    RETURN newShape;
END;

PROCEDURE selectShape(flag v) IS
    newShape SHAPE_TYPE;
    shape_map HASH_MAP_TYPE;
    min_shape_value v := 0;
    min_shape_value_index v := 0;
    min_shape_id v;
    rn v;
    not_exists_flag v;
    shape_cnt v;
    newPoint POINT_TYPE;
    tmp_shape   SHAPE_TYPE;
BEGIN
    shape_list.DELETE;

    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            newPoint.row_idx := i;
            newPoint.col_idx := j;
            newPoint.point_value := i * 5 + j + 1;
            newPoint.status := 0;
            point_values(i)(j) := newPoint;
        END LOOP;
    END LOOP;
    
    OPEN c1;
    LOOP
       newShape := shape_null;
       FETCH c1 INTO newShape.points(0).row_idx,newShape.points(0).col_idx,
                     newShape.points(1).row_idx,newShape.points(1).col_idx,
                     newShape.points(2).row_idx,newShape.points(2).col_idx,
                     newShape.points(3).row_idx,newShape.points(3).col_idx,
                     newShape.points(4).row_idx,newShape.points(4).col_idx,
                     newShape.row_width,
                     newShape.col_width,
                     newShape.min_point.row_idx,
                     newShape.min_point.col_idx;
       EXIT WHEN c1%NOTFOUND;
       IF isCorrectShape(newShape) THEN
           min_shape_value_index := 0;
           min_shape_value := 0;
           not_exists_flag := 0;
           shape_cnt := 0;
           FOR i IN 1 .. 8 LOOP
               newShape := rotateMirrorShape(newShape,i);
               IF NOT shape_map.EXISTS(newShape.shape_id) THEN
                   rn := shape_list.COUNT;
                   shape_list(rn) :=  newShape;
                   shape_map(newShape.shape_id) := newShape.shape_id;
                   shape_cnt := shape_cnt + 1;
                   IF min_shape_value = 0 OR newShape.shape_value < min_shape_value OR newShape.shape_value = min_shape_value AND newShape.shape_id < min_shape_id THEN
                       min_shape_value := newShape.shape_value;
                       min_shape_value_index := rn;
                       min_shape_id := newShape.shape_id;
                   END IF;
                   not_exists_flag := 1;
               END IF;
           END LOOP;
           IF not_exists_flag=1 THEN
               shape_list(min_shape_value_index).isBaseShape := 1;
               shape_list(min_shape_value_index).shape_cnt := shape_cnt;
           END IF;
       END IF;
    END LOOP;

    FOR i IN REVERSE 0 .. shape_list.COUNT - 1
    LOOP
      FOR j  IN 1 .. i
      LOOP
          g_shape := shape_list(j-1);
          IF g_shape.shape_value < shape_list(j).shape_value OR g_shape.shape_value = shape_list(j).shape_value AND g_shape.shape_id < shape_list(j).shape_id THEN
              tmp_shape := g_shape;
              shape_list (j-1) := shape_list (j);
              shape_list (j) := tmp_shape;
          END IF;
      END LOOP;
      IF flag=1 OR shape_list(i).isBaseShape = 1 THEN
          printShape(shape_list(i),flag);
      END IF;
    END LOOP;
    
    CLOSE c1;
END;

PROCEDURE printArray(r array_type) IS
    str v;
BEGIN
    
    FOR i IN r.FIRST .. r.LAST LOOP
        str := str || ',' || r(i);
    END LOOP;
    dbms_output.put_line(str);
    --loopShape(0, 1, r, 5);
END;

PROCEDURE recursionShape(head NUMBER, idx NUMBER,r IN OUT array_type, k NUMBER) IS

BEGIN
    FOR i IN head .. a.COUNT + idx - k - 1 LOOP
        IF idx < k THEN
            r(idx - 1) := a(i);
            recursionShape(i + 1, idx + 1, r, k);
        ELSIF idx = k THEN
            r(idx - 1) := a(i);
            --printArray(r);
            loop_cnt := loop_cnt + 1;
            recursionShape(i + 1, idx + 1, r, k);
        ELSE
            RETURN;
        END IF;
    END LOOP;
END;



PROCEDURE output_allshapes IS
    r array_type;
    M NUMBER := 25;
    N NUMBER := 9;
BEGIN
    --p('SHAPE_VAL SHAPE',1);
    --selectShape(1);
    
    FOR i IN 1 .. M LOOP
        a(i-1) := i;
        --dbms_output.put_line(a(i-1));
    END LOOP;
    loop_cnt := 0;
    recursionShape(0, 1, r, N);
    dbms_output.put_line(loop_cnt);
END;

PROCEDURE output_allbaseshapes IS
BEGIN
    p('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);
    selectShape(2);
END;


END five;

http://blog.sina.com.cn/swingjava

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Drawing2D;
using System.Media;
namespace JP1Test
{
    public partial class Form1 : Form
    {
        private Point currentPoint;
        private List<JobEntity> jobList;
        private Rectangle m_Rect;
        private Point m_LastMSPoint;
        bool isOnJobMouseDown = false;

        public Form1()
        {
            InitializeComponent();
            jobList = new List<JobEntity>();
        }

        protected override void OnPaint(PaintEventArgs e)
        {
            JobEntity deleteJob = null;
            foreach (JobEntity job in jobList) {
                Brush brush = SystemBrushes.ControlDark;
                switch (job.Status)
                {
                    case JobStatusEnum.Default:
                        break;                    
                    case JobStatusEnum.Add:
                        break;
                    case JobStatusEnum.Delete:
                        brush = new SolidBrush(this.BackColor);
                        deleteJob = job;
                        break;
                    case JobStatusEnum.Move:
                        job.Rect = m_Rect;
                        break;
                    default :
                        break;
                    
                }
                e.Graphics.FillRectangle(brush, job.Rect);
                job.Status = JobStatusEnum.Default;
            }

            if (deleteJob != null)
            {
                jobList.Remove(deleteJob);
            }
        }

        protected override void OnMouseDown(MouseEventArgs e)
        {
            base.OnMouseDown(e);
            currentPoint = e.Location;
            for (int i = 0; i < jobList.Count; i++)
            {
                if (jobList[i].Rect.Contains(currentPoint))
                {
                    m_Rect = jobList[i].Rect;
                    this.m_LastMSPoint = e.Location;
                    isOnJobMouseDown = true;
                    jobList[i].MouseDown = true;
                    break;
                }
            }
        }
        protected override void OnMouseMove(MouseEventArgs e)
        {
            base.OnMouseMove(e);

            if (e.Button != MouseButtons.Left)
            {
                return;
            }

            if (isOnJobMouseDown)
            {
                foreach (JobEntity job in jobList)
                {
                    if (job.MouseDown)
                    {
                        job.Status = JobStatusEnum.Move;
                    }
                }

                this.m_Rect.Offset(e.Location.X - this.m_LastMSPoint.X, e.Location.Y - this.m_LastMSPoint.Y);
                this.Invalidate();
                this.m_LastMSPoint = e.Location;
            }
        }
        protected override void OnMouseUp(MouseEventArgs e)
        {
            isOnJobMouseDown = false;
            for (int i = 0; i < jobList.Count; i++)
            {
                jobList[i].MouseDown = false;
            }
        }

        private void contextMenuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            for (int i = 0; i < contextMenuStrip1.Items.Count; i++)
            {
                if (contextMenuStrip1.Items[i].Selected)
                {
                    if (contextMenuStrip1.Items[i].Text == "add")
                    {
                        add();
                    }
                    else if (contextMenuStrip1.Items[i].Text == "delete")
                    {
                        delete();
                    }
                }
            }
        }

        // create a job
        private void add()
        {
            JobEntity job = new JobEntity();
            job.Rect = new Rectangle(currentPoint.X, currentPoint.Y, 50, 50);
            job.Status = JobStatusEnum.Add;
            jobList.Add(job);
            this.Invalidate();
        }

        // delete a job
        private void delete()
        {
            for (int i = 0; i < jobList.Count; i++)
            {
                if (jobList[i].Rect.Contains(currentPoint))
                {
                    jobList[i].Status = JobStatusEnum.Delete;
                    break;
                }
            }
            this.Invalidate();
        }


        private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
        {
            //e.Cancel = !isOpenContextMenu;
        }

        private void contextMenuStrip1_Opened(object sender, EventArgs e)
        {
            bool selected = false;
            for (int i = 0; i < jobList.Count; i++)
            {
                if (jobList[i].Rect.Contains(currentPoint))
                {
                    jobList[i].Selected = true;
                    selected = true;
                    break;
                }
            }

            contextMenuStrip1.Items[0].Enabled = !selected;
            contextMenuStrip1.Items[1].Enabled = selected;
        }

    }
}

CREATE OR REPLACE PACKAGE BODY five IS


TYPE P_ IS RECORD(r v,c v,p v,b v);
TYPE E IS TABLE OF P_ INDEX BY v;
TYPE D IS RECORD(r v,c v,k v,s v,x E,m P_,n v,b v);
TYPE SS_ IS TABLE OF D INDEX BY v;
TYPE M_ IS TABLE OF v INDEX BY v;
TYPE R_ IS TABLE OF E INDEX BY v;
q P_;x v;y v;g D;su D;z SS_;a R_;l v:=' ';
CURSOR c IS
WITH t AS(SELECT LEVEL-1 x,LEVEL v FROM DUAL CONNECT BY LEVEL<=5),
o AS (SELECT m.x r,n.x c,m.x*5+n.v v FROM t m,t n)
SELECT a.r,a.c,b.r,b.c,c.r,c.c,d.r,d.c,e.r,e.c,e.r-a.r+1,GREATEST(a.c,b.c,c.c,d.c,e.c)-LEAST(a.c,b.c,c.c,d.c,e.c)+1,a.r,LEAST(a.c,b.c,c.c,d.c,e.c)
  FROM o a,o b,o c,o d,o e
 WHERE a.v<b.v AND b.v<c.v AND c.v<d.v AND d.v<e.v
   AND ic2(a.r,a.c,b.r,b.c,c.r,c.c,d.r,d.c,e.r,e.c)=1
 ;
PROCEDURE w(s v,f v)AS BEGIN IF f=1 THEN DBMS_OUTPUT.PUT_LINE(s);ELSE DBMS_OUTPUT.PUT(s);END IF;END;
PROCEDURE ws(s D,f v) IS
    t R_;
BEGIN
    t:=a;
    FOR i IN 0..4 LOOP
        t(s.x(i).r)(s.x(i).c).b:=1;
    END LOOP;
    FOR i IN 0..4 LOOP
        x:='';
        y:='';
        IF i=2 THEN
            x:=s.s;
            IF f=2 THEN
                y:=s.n;
            END IF;
        ELSE
            x:=l;
            IF f=2 THEN
                y:=l;
            END IF;
        END IF;
        w(RPAD(x,14)||RPAD(y,10),2);    
        FOR j IN 0..4 LOOP
            IF t(i)(j).b=1 THEN
                w('■',2);
            ELSE
                w('□',2);
            END IF;
        END LOOP;
        w(l,1);
    END LOOP;
    w(l,1);
END;
FUNCTION ro(h D,f v) RETURN D IS
    r v;c v;s D;t v:=0;
BEGIN
    s.r:=h.c;
    s.c:=h.r;
    IF f=5 THEN
        s.r:=h.r;
        s.c:=h.c;
    END IF;
    x:=h.m.r;
    y:=h.m.c;
    FOR i IN 0..4 LOOP
        r:=-h.x(i).c+y+s.r-1;
        c:=h.x(i).r-x;
        IF f=5 THEN
            r:=h.x(i).r;
            c:=s.c-h.x(i).c-1;
        END IF;
        s.x(i).r:=r;
        s.x(i).c:=c;
        s.x(i).p:=a(r)(c).p;
        t:=t+a(r)(c).p;
    END LOOP;
    s.m.r:=0;
    s.m.c:=0;
    s.s:=t;
    y:='';
    FOR i IN REVERSE 0..4 LOOP
        FOR j IN 0..i-1 LOOP
            IF s.x(j).p<s.x(j+1).p+0 THEN
                q:=s.x(j);
                s.x(j):=s.x(j+1);
                s.x(j+1):=q;
            END IF;
        END LOOP;
        y:=y||l||s.x(i).p;
    END LOOP;
    s.k:=y;
    RETURN s;
END;
FUNCTION ro2(h D,f v) RETURN D IS
    r v;c v;s D;t v:=0;p P_;
    --ms M_;
BEGIN
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            p.r:=i;
            p.c:=j;
            p.p:=i*5+j+1;
            p.b:=0;
            a(i)(j):=p;
        END LOOP;
    END LOOP;
    s.r:=h.c;
    s.c:=h.r;
    IF f=5 THEN
        s.r:=h.r;
        s.c:=h.c;
    END IF;
    x:=0;
    y:=0;
    FOR i IN 0..4 LOOP
        r:=-h.x(i).c+y+s.r-1;
        c:=h.x(i).r-x;
        IF f=5 THEN
            r:=h.x(i).r;
            c:=s.c-h.x(i).c-1;
        END IF;
        s.x(i).r:=r;
        s.x(i).c:=c;
        s.x(i).p:=a(r)(c).p;
       t:=t+a(r)(c).p;
    END LOOP;
    s.m.r:=0;
    s.m.c:=0;
    s.s:=t;
    y:='';
    FOR i IN REVERSE 0..4 LOOP
        FOR j IN 0..i-1 LOOP
            IF s.x(j).p<s.x(j+1).p+0 THEN
                q:=s.x(j);
                s.x(j):=s.x(j+1);
                s.x(j+1):=q;
            END IF;
        END LOOP;
        y:=y||'_'||s.x(i).p;
    END LOOP;
    s.k:=y;
    --ms(y) := t;
    RETURN s;
END;
FUNCTION base_shape_id(r1 v,c1 v,
                       r2 v,c2 v,
                       r3 v,c3 v,
                       r4 v,c4 v,
                       r5 v,c5 v,
                       row_width v,
                       col_width v
                       ) RETURN v IS
    
    --vs V_TYPE := V_TYPE(v1,v2,v3,v4,v5);
    s D;m M_;u v;h v;k v;r v;b v;n v;p P_;t D;
    min_s D;
BEGIN
    NULL;

    s.x(0).r := r1;s.x(0).c := c1;
    s.x(1).r := r2;s.x(1).c := c2;
    s.x(2).r := r3;s.x(2).c := c3;
    s.x(3).r := r4;s.x(3).c := c4;
    s.x(4).r := r5;s.x(4).c := c5;
    s.r := row_width;
    s.c := col_width;
    min_s.s := 0;
    FOR i IN 1..8 LOOP
       s:=ro2(s,i);
       IF min_s.s = 0 OR s.s < min_s.s OR (s.s = min_s.s AND s.k < min_s.k) THEN
           min_s := s;
       END IF;
    END LOOP;
    RETURN min_s.k;
END;
FUNCTION gk(v1 v,v2 v,v3 v,v4 v,v5 v) RETURN v IS
    vs V_TYPE := V_TYPE(v1,v2,v3,v4,v5);
BEGIN
    y:='';
    FOR i IN REVERSE 1..5 LOOP
        FOR j IN 1..i-1 LOOP
            IF vs(j)<vs(j+1)+0 THEN
                x:=vs(j);
                vs(j):=vs(j+1);
                vs(j+1):=x;
            END IF;
        END LOOP;
        y:=y||'_'||vs(i);
    END LOOP;
    RETURN y;
END;

FUNCTION ic(h D) RETURN BOOLEAN IS
    o E;c v;
BEGIN
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            q:=h.x(j);
            x:=a(q.r)(q.c).p;
            IF NOT o.EXISTS(x) THEN
                c:=0;
                IF o.COUNT=0 THEN
                    c:=1;
                END IF;
                y:=o.FIRST;
                WHILE y IS NOT NULL LOOP
                    IF q.c=o(y).c AND ABS(q.r-o(y).r)=1 OR q.r=o(y).r AND ABS(q.c-o(y).c)=1 THEN
                       c:=1;
                    END IF;
                    y:=o.NEXT(y);
                END LOOP;
                IF c=1 THEN
                    o(x):=q;
                    EXIT;
                END IF;
            END IF;
        END LOOP;
    END LOOP;
    RETURN o.COUNT=5;
END;

FUNCTION ic2(r1 v,c1 v,r2 v,c2 v,r3 v,c3 v,r4 v,c4 v,r5 v,c5 v) RETURN VARCHAR2 IS
    h D;
    o E;c v;
    p P_;
BEGIN
    h.x(0).r := r1;h.x(0).c := c1;
    h.x(1).r := r2;h.x(1).c := c2;
    h.x(2).r := r3;h.x(2).c := c3;
    h.x(3).r := r4;h.x(3).c := c4;
    h.x(4).r := r5;h.x(4).c := c5;

    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            p.r:=i;
            p.c:=j;
            p.p:=i*5+j+1;
            p.b:=0;
            a(i)(j):=p;
        END LOOP;
    END LOOP;
    
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            q:=h.x(j);
            x:=a(q.r)(q.c).p;
            IF NOT o.EXISTS(x) THEN
                c:=0;
                IF o.COUNT=0 THEN
                    c:=1;
                END IF;
                y:=o.FIRST;
                WHILE y IS NOT NULL LOOP
                    IF q.c=o(y).c AND ABS(q.r-o(y).r)=1 OR q.r=o(y).r AND ABS(q.c-o(y).c)=1 THEN
                       c:=1;
                    END IF;
                    y:=o.NEXT(y);
                END LOOP;
                IF c=1 THEN
                    o(x):=q;
                    EXIT;
                END IF;
            END IF;
        END LOOP;
    END LOOP;
    IF o.COUNT=5 THEN
        RETURN 1;
    ELSE 
        RETURN 0;
    END IF;

END;
PROCEDURE se(f v) IS
    s D;m M_;u v;h v;k v;r v;b v;n v;p P_;t D;
BEGIN
    z.DELETE;
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            p.r:=i;
            p.c:=j;
            p.p:=i*5+j+1;
            p.b:=0;
            a(i)(j):=p;
        END LOOP;
    END LOOP;
    OPEN c;
    LOOP
       s:=su;
       FETCH c INTO s.x(0).r,s.x(0).c,s.x(1).r,s.x(1).c,s.x(2).r,s.x(2).c,s.x(3).r,s.x(3).c,s.x(4).r,s.x(4).c,s.r,s.c,s.m.r,s.m.c;
       EXIT WHEN c%NOTFOUND;
       IF ic(s) THEN
           h:=0;
           u:=0;
           b:=0;
           n:=0;
           FOR i IN 1..8 LOOP
               s:=ro(s,i);
               IF NOT m.EXISTS(s.k) THEN
                   r:=z.COUNT;
                   z(r):=s;
                   m(s.k):=s.k;
                   n:=n+1;
                   IF u=0 OR s.s<u OR s.s=u AND s.k<k THEN
                       u:=s.s;
                       h:=r;
                       k:=s.k;
                   END IF;
                   b:=1;
               END IF;
           END LOOP;
           IF b=1 THEN
               z(h).b:=1;
               z(h).n:=n;
           END IF;
       END IF;
    END LOOP;
    FOR i IN REVERSE 0..z.COUNT-1 LOOP
      FOR j IN 1..i LOOP
         g:=z(j-1);
         IF g.s<z(j).s OR g.s=z(j).s AND g.k<z(j).k THEN
            t:=g;
            z(j-1):=z(j);
            z(j):=t;
         END IF;
      END LOOP;
      IF f=1 OR z(i).b=1 THEN
          ws(z(i),f);
      END IF;
    END LOOP;
    CLOSE c;
END;
PROCEDURE output_allshapes IS
BEGIN
    w('SHAPE_VAL     SHAPE',1);se(1);
END;
PROCEDURE output_allbaseshapes IS
BEGIN
    w('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);se(2);
END;

END;

WITH t AS(SELECT LEVEL-1 x,LEVEL v FROM DUAL CONNECT BY LEVEL<=5),
o AS (SELECT m.x r,n.x c,m.x*5+n.v v FROM t m,t n)
SELECT * FROM (
SELECT  t1.*,
        row_number() over(PARTITION BY 
                five.base_shape_id(t1.r1,t1.c1,
                                   t1.r2,t1.c2,
                                   t1.r3,t1.c3,
                                   t1.r4,t1.c4,
                                   t1.r5,t1.c5,
                                   t1.row_width,
                                   t1.col_width
                                   ) 
                                   ORDER BY t1.shape_val,t1.shape_key
        ) rn


  FROM (
    SELECT a.r r1,a.c c1,a.v v1,
           b.r r2,b.c c2,b.v v2,
           c.r r3,c.c c3,c.v v3,
           d.r r4,d.c c4,d.v v4,
           e.r r5,e.c c5,e.v v5,
           e.r - a.r + 1 row_width,
           GREATEST(a.c, b.c, c.c, d.c, e.c) - LEAST(a.c, b.c, c.c, d.c, e.c) + 1 col_width,
           '_' || a.v || '_' || b.v || '_' || c.v || '_' || d.v  || '_' || e.v shape_key,
           a.v+b.v+c.v+d.v+e.v shape_val
      FROM o a,
           o b,
           o c,
           o d,
           o e
     WHERE a.v < b.v
       AND b.v < c.v
       AND c.v < d.v
       AND d.v < e.v
       AND five.ic2(a.r, a.c, b.r, b.c, c.r, c.c, d.r, d.c, e.r, e.c) = 1
       AND a.r = 0 AND LEAST(a.c, b.c, c.c, d.c, e.c) = 0
   ) t1
) m
WHERE m.rn = 1
ORDER BY m.shape_val,m.shape_key

WITH t AS(SELECT LEVEL-1 x,LEVEL v FROM DUAL CONNECT BY LEVEL<=5),
o AS (SELECT m.x r,n.x c,m.x*5+n.v v FROM t m,t n)
SELECT a.r r1,a.c c1,a.v v1,
       b.r r2,b.c c2,b.v v2,
       c.r r3,c.c c3,c.v v3,
       d.r r4,d.c c4,d.v v4,
       e.r r5,e.c c5,e.v v5,
       e.r - a.r + 1 row_width,
       GREATEST(a.c, b.c, c.c, d.c, e.c) - LEAST(a.c, b.c, c.c, d.c, e.c) + 1 col_width,
       a.r min_row,
       LEAST(a.c, b.c, c.c, d.c, e.c) min_col,
       a.v || '_' || b.v || '_' || c.v || '_' || d.v  || '_' || e.v shape_key
  FROM o a,
       o b,
       o c,
       o d,
       o e
 WHERE a.v < b.v
   AND b.v < c.v
   AND c.v < d.v
   AND d.v < e.v
   --AND a.v=1 AND b.v=2 AND c.v=3 AND d.v=4 AND e.v = 6
   AND five.ic2(a.r, a.c, b.r, b.c, c.r, c.c, d.r, d.c, e.r, e.c) = 1
   AND a.r = 0 AND LEAST(a.c, b.c, c.c, d.c, e.c) = 0

CREATE OR REPLACE PACKAGE BODY five IS


TYPE P_ IS RECORD(r v,c v,p v,b v);
TYPE E IS TABLE OF P_ INDEX BY v;
TYPE D IS RECORD(r v,c v,k v,s v,x E,m P_,n v,b v);
TYPE SS_ IS TABLE OF D INDEX BY v;
TYPE M_ IS TABLE OF v INDEX BY v;
TYPE R_ IS TABLE OF E INDEX BY v;
q P_;x v;y v;g D;su D;z SS_;a R_;l v:=' ';
CURSOR c IS
WITH t AS(SELECT LEVEL-1 x,LEVEL v FROM DUAL CONNECT BY LEVEL<=5),
o AS (SELECT m.x r,n.x c,m.x*5+n.v v FROM t m,t n)
SELECT a.r,a.c,b.r,b.c,c.r,c.c,d.r,d.c,e.r,e.c,e.r-a.r+1,GREATEST(a.c,b.c,c.c,d.c,e.c)-LEAST(a.c,b.c,c.c,d.c,e.c)+1,a.r,LEAST(a.c,b.c,c.c,d.c,e.c)
  FROM o a,o b,o c,o d,o e
 WHERE a.v<b.v AND b.v<c.v AND c.v<d.v AND d.v<e.v
   AND ic2(a.r,a.c,b.r,b.c,c.r,c.c,d.r,d.c,e.r,e.c)=1
 ;
PROCEDURE w(s v,f v)AS BEGIN IF f=1 THEN DBMS_OUTPUT.PUT_LINE(s);ELSE DBMS_OUTPUT.PUT(s);END IF;END;
PROCEDURE ws(s D,f v) IS
    t R_;
BEGIN
    t:=a;
    FOR i IN 0..4 LOOP
        t(s.x(i).r)(s.x(i).c).b:=1;
    END LOOP;
    FOR i IN 0..4 LOOP
        x:='';
        y:='';
        IF i=2 THEN
            x:=s.s;
            IF f=2 THEN
                y:=s.n;
            END IF;
        ELSE
            x:=l;
            IF f=2 THEN
                y:=l;
            END IF;
        END IF;
        w(RPAD(x,14)||RPAD(y,10),2);    
        FOR j IN 0..4 LOOP
            IF t(i)(j).b=1 THEN
                w('■',2);
            ELSE
                w('□',2);
            END IF;
        END LOOP;
        w(l,1);
    END LOOP;
    w(l,1);
END;
FUNCTION ro(h D,f v) RETURN D IS
    r v;c v;s D;t v:=0;
BEGIN
    s.r:=h.c;
    s.c:=h.r;
    IF f=5 THEN
        s.r:=h.r;
        s.c:=h.c;
    END IF;
    x:=h.m.r;
    y:=h.m.c;
    FOR i IN 0..4 LOOP
        r:=-h.x(i).c+y+s.r-1;
        c:=h.x(i).r-x;
        IF f=5 THEN
            r:=h.x(i).r;
            c:=s.c-h.x(i).c-1;
        END IF;
        s.x(i).r:=r;
        s.x(i).c:=c;
        s.x(i).p:=a(r)(c).p;
        t:=t+a(r)(c).p;
    END LOOP;
    s.m.r:=0;
    s.m.c:=0;
    s.s:=t;
    y:='';
    FOR i IN REVERSE 0..4 LOOP
        FOR j IN 0..i-1 LOOP
            IF s.x(j).p<s.x(j+1).p+0 THEN
                q:=s.x(j);
                s.x(j):=s.x(j+1);
                s.x(j+1):=q;
            END IF;
        END LOOP;
        y:=y||l||s.x(i).p;
    END LOOP;
    s.k:=y;
    RETURN s;
END;
FUNCTION ic(h D) RETURN BOOLEAN IS
    o E;c v;
BEGIN
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            q:=h.x(j);
            x:=a(q.r)(q.c).p;
            IF NOT o.EXISTS(x) THEN
                c:=0;
                IF o.COUNT=0 THEN
                    c:=1;
                END IF;
                y:=o.FIRST;
                WHILE y IS NOT NULL LOOP
                    IF q.c=o(y).c AND ABS(q.r-o(y).r)=1 OR q.r=o(y).r AND ABS(q.c-o(y).c)=1 THEN
                       c:=1;
                    END IF;
                    y:=o.NEXT(y);
                END LOOP;
                IF c=1 THEN
                    o(x):=q;
                    EXIT;
                END IF;
            END IF;
        END LOOP;
    END LOOP;
    RETURN o.COUNT=5;
END;

FUNCTION ic2(r1 v,c1 v,r2 v,c2 v,r3 v,c3 v,r4 v,c4 v,r5 v,c5 v) RETURN VARCHAR2 IS
    h D;
    o E;c v;
    p P_;
BEGIN
    h.x(0).r := r1;h.x(0).c := c1;
    h.x(1).r := r2;h.x(1).c := c2;
    h.x(2).r := r3;h.x(2).c := c3;
    h.x(3).r := r4;h.x(3).c := c4;
    h.x(4).r := r5;h.x(4).c := c5;

    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            p.r:=i;
            p.c:=j;
            p.p:=i*5+j+1;
            p.b:=0;
            a(i)(j):=p;
        END LOOP;
    END LOOP;
    
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            q:=h.x(j);
            x:=a(q.r)(q.c).p;
            IF NOT o.EXISTS(x) THEN
                c:=0;
                IF o.COUNT=0 THEN
                    c:=1;
                END IF;
                y:=o.FIRST;
                WHILE y IS NOT NULL LOOP
                    IF q.c=o(y).c AND ABS(q.r-o(y).r)=1 OR q.r=o(y).r AND ABS(q.c-o(y).c)=1 THEN
                       c:=1;
                    END IF;
                    y:=o.NEXT(y);
                END LOOP;
                IF c=1 THEN
                    o(x):=q;
                    EXIT;
                END IF;
            END IF;
        END LOOP;
    END LOOP;
    IF o.COUNT=5 THEN
        RETURN 1;
    ELSE 
        RETURN 0;
    END IF;

END;
PROCEDURE se(f v) IS
    s D;m M_;u v;h v;k v;r v;b v;n v;p P_;t D;
BEGIN
    z.DELETE;
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            p.r:=i;
            p.c:=j;
            p.p:=i*5+j+1;
            p.b:=0;
            a(i)(j):=p;
        END LOOP;
    END LOOP;
    OPEN c;
    LOOP
       s:=su;
       FETCH c INTO s.x(0).r,s.x(0).c,s.x(1).r,s.x(1).c,s.x(2).r,s.x(2).c,s.x(3).r,s.x(3).c,s.x(4).r,s.x(4).c,s.r,s.c,s.m.r,s.m.c;
       EXIT WHEN c%NOTFOUND;
       IF ic(s) THEN
           h:=0;
           u:=0;
           b:=0;
           n:=0;
           FOR i IN 1..8 LOOP
               s:=ro(s,i);
               IF NOT m.EXISTS(s.k) THEN
                   r:=z.COUNT;
                   z(r):=s;
                   m(s.k):=s.k;
                   n:=n+1;
                   IF u=0 OR s.s<u OR s.s=u AND s.k<k THEN
                       u:=s.s;
                       h:=r;
                       k:=s.k;
                   END IF;
                   b:=1;
               END IF;
           END LOOP;
           IF b=1 THEN
               z(h).b:=1;
               z(h).n:=n;
           END IF;
       END IF;
    END LOOP;
    FOR i IN REVERSE 0..z.COUNT-1 LOOP
      FOR j IN 1..i LOOP
         g:=z(j-1);
         IF g.s<z(j).s OR g.s=z(j).s AND g.k<z(j).k THEN
            t:=g;
            z(j-1):=z(j);
            z(j):=t;
         END IF;
      END LOOP;
      IF f=1 OR z(i).b=1 THEN
          ws(z(i),f);
      END IF;
    END LOOP;
    CLOSE c;
END;
PROCEDURE output_allshapes IS
BEGIN
    w('SHAPE_VAL     SHAPE',1);se(1);
END;
PROCEDURE output_allbaseshapes IS
BEGIN
    w('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);se(2);
END;

END;

CREATE OR REPLACE PACKAGE BODY FIVESQUARESHAPE IS
SUBTYPE v IS VARCHAR(999);
TYPE P_ IS RECORD(r v,c v,pv v,b v);
TYPE PS_ IS TABLE OF P_ INDEX BY v;
TYPE S_ IS RECORD(r v,c v,k v,sv v,x PS_,mp P_,sn v,b v);
TYPE SS_ IS TABLE OF S_ INDEX BY v;
TYPE M_ IS TABLE OF v INDEX BY v;
TYPE R_ IS TABLE OF PS_ INDEX BY v;
q P_;y v;g S_;su S_;z SS_;a R_;l v:=' ';
CURSOR c1 IS
WITH t AS (SELECT LEVEL-1 x,LEVEL v FROM DUAL CONNECT BY LEVEL<=5),
o AS (SELECT m.x r,n.x c,m.x*5+n.v v FROM t m,t n)
SELECT a.r,a.c,b.r,b.c,c.r,c.c,d.r,d.c,e.r,e.c,e.r-a.r + 1,GREATEST(a.c,b.c,c.c,d.c,e.c)-LEAST(a.c, b.c, c.c, d.c, e.c)+1,a.r,LEAST(a.c,b.c,c.c,d.c,e.c)
  FROM o a,o b,o c,o d,o e
 WHERE a.v<b.v AND b.v<c.v AND c.v<d.v AND d.v<e.v;
PROCEDURE w(s v,f v DEFAULT '')AS BEGIN IF f=1 THEN DBMS_OUTPUT.PUT_LINE(s);ELSE DBMS_OUTPUT.PUT(s);END IF;END;
PROCEDURE ws(s S_,f v) IS
    t R_;x v;
BEGIN
    t:=a;
    FOR i IN 0..4 LOOP
        t(s.x(i).r)(s.x(i).c).b:=1;
    END LOOP;
    FOR i IN 0..4 LOOP
        x:='';
        y:='';
        IF i=2 THEN
            x:=s.sv;
            IF f=2 THEN
                y:=s.sn;
            END IF;
        ELSE
            x:=l;
            IF f=2 THEN
                y:=l;
            END IF;
        END IF;
        w(RPAD(x,14)||RPAD(y,10));    
        FOR j IN 0..4 LOOP
            IF t(i)(j).b=1 THEN
                w('■');
            ELSE
                w('□');
            END IF;
        END LOOP;
        w(l,1);
    END LOOP;
    w(l,1);
END;
FUNCTION gk(p PS_) RETURN v IS
    r v;t sys.owa_util.num_arr;s M_;
BEGIN
    FOR i IN 0..4 LOOP
        t(i):=a(p(i).r)(p(i).c).pv;
    END LOOP;
    y:=t.FIRST;
    WHILE y IS NOT NULL LOOP
      s(t(y)):=t(y);
      y:=t.NEXT(y);
    END LOOP;
    y:=s.FIRST;
    WHILE y IS NOT NULL LOOP
      r:=r||l||s(y);
      y:=s.NEXT(y);
    END LOOP;
    RETURN r;
END;
FUNCTION ic(h S_) RETURN BOOLEAN IS
    o PS_;s v;b v;
BEGIN
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            q:=h.x(j);
            s := a(q.r)(q.c).pv;
            IF NOT o.EXISTS(s) THEN
                b:=0;
                IF o.COUNT=0 THEN
                    b:=1;
                END IF;
                y:=o.FIRST;
                WHILE y IS NOT NULL LOOP
                    IF q.c=o(y).c AND ABS(q.r-o(y).r)=1 OR q.r=o(y).r AND ABS(q.c-o(y).c)=1 THEN
                       b:=1;
                    END IF;
                    y := o.NEXT(y);
                END LOOP;
                IF b=1 THEN
                    o(s):=q;
                    EXIT;
                END IF;
            END IF;
        END LOOP;
    END LOOP;
    RETURN o.COUNT=5;
END;
FUNCTION ro(h S_,f v) RETURN S_ IS
    r v;c v;m v;n v;s S_;t v:=0;
BEGIN
    s.r:=h.c;
    s.c:=h.r;
    IF f=5 THEN
        s.r:=h.r;
        s.c:=h.c;
    END IF;
    m := h.mp.r;
    n := h.mp.c;
    FOR i IN 0..4 LOOP
        r:=-h.x(i).c+n+s.r-1;
        c:=h.x(i).r-m;
        IF f=5 THEN
            r:=h.x(i).r;
            c:=s.c-h.x(i).c-1;
        END IF;
        s.x(i).r:=r;
        s.x(i).c:=c;
        t:=t+a(r)(c).pv;
    END LOOP;
    s.mp.r:=0;
    s.mp.c:=0;
    s.sv:=t;
    s.k:=gk(s.x);
    RETURN s;
END;

PROCEDURE se(f v) IS
    s S_;m M_;u v:=0;h v:=0;k v;rn v;b v;sn v;p P_;t S_;
BEGIN
    z.DELETE;
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            p.r:=i;
            p.c:=j;
            p.pv:=i*5+j+1;
            p.b:=0;
            a(i)(j):=p;
        END LOOP;
    END LOOP;
    OPEN c1;
    LOOP
       s:=su;
       FETCH c1 INTO s.x(0).r,s.x(0).c,s.x(1).r,s.x(1).c,s.x(2).r,s.x(2).c,s.x(3).r,s.x(3).c,s.x(4).r,s.x(4).c,s.r,s.c,s.mp.r,s.mp.c;
       EXIT WHEN c1%NOTFOUND;
       IF ic(s) THEN
           h:=0;
           u:=0;
           b:=0;
           sn:=0;
           FOR i IN 1..8 LOOP
               s:=ro(s,i);
               IF NOT m.EXISTS(s.k) THEN
                   rn:=z.COUNT;
                   z(rn):=s;
                   m(s.k):=s.k;
                   sn:=sn+1;
                   IF u=0 OR s.sv<u OR s.sv=u AND s.k<k THEN
                       u:=s.sv;
                       h:=rn;
                       k:=s.k;
                   END IF;
                   b:=1;
               END IF;
           END LOOP;
           IF b=1 THEN
               z(h).b:=1;
               z(h).sn:=sn;
           END IF;
       END IF;
    END LOOP;
    FOR i IN REVERSE 0..z.COUNT-1 LOOP
      FOR j IN 1..i LOOP
         g:=z(j-1);
         IF g.sv<z(j).sv OR g.sv=z(j).sv AND g.k<z(j).k THEN
            t:=g;
            z(j-1):=z(j);
            z(j):=t;
         END IF;
      END LOOP;
      IF f=1 OR z(i).b=1 THEN
          ws(z(i),f);
      END IF;
    END LOOP;
    CLOSE c1;
END;
PROCEDURE output_allshapes IS
BEGIN
    w('SHAPE_VAL     SHAPE',1);se(1);
END;
PROCEDURE output_allbaseshapes IS
BEGIN
    w('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);se(2);
END;
END;

CREATE OR REPLACE PACKAGE BODY FIVESQUARESHAPE IS
SUBTYPE v IS VARCHAR(999);
TYPE P_ IS RECORD (
    r v,c v,pv v,b BOOLEAN
);
TYPE PS_ IS TABLE OF P_ INDEX BY v;
TYPE S_ IS RECORD (
    r v,c v,k v,sv v,ps PS_,mp P_,sn v,b v
);
su S_;
TYPE SS_ IS TABLE OF S_ INDEX BY v;
ss SS_;
TYPE M_ IS TABLE OF v INDEX BY v;
TYPE R_ IS TABLE OF PS_ INDEX BY v;
a R_;
CURSOR c1 IS
WITH t AS (SELECT LEVEL-1 x,LEVEL v FROM DUAL CONNECT BY LEVEL<=5),tb AS (SELECT t1.x r,t2.x c,t1.x*5+t2.v v FROM t t1,t t2)
SELECT a.r r1,a.c c1,b.r r2,b.c c2,c.r r3,c.c c3,d.r r4,d.c c4,e.r r5,e.c c5,GREATEST(a.r,b.r,c.r,d.r,e.r) - LEAST(a.r,b.r,c.r,d.r,e.r)+1 rw,GREATEST(a.c,b.c,c.c,d.c,e.c) - LEAST(a.c,b.c,c.c,d.c,e.c)+1 cw,LEAST(a.r,b.r,c.r,d.r,e.r) mr,LEAST(a.c,b.c,c.c,d.c,e.c) mc
  FROM tb a,tb b,tb c,tb d,tb e
 WHERE a.v<b.v AND b.v<c.v AND c.v<d.v AND d.v<e.v;
PROCEDURE w(s v,f v DEFAULT '')AS BEGIN IF f=1 THEN DBMS_OUTPUT.PUT_LINE(s);ELSE DBMS_OUTPUT.PUT(s);END IF;END;
PROCEDURE ws(s S_,f v) IS
    t R_;
    k v:=' ';
BEGIN
    t := a;
    FOR i IN 0..4 LOOP
        t(s.ps(i).r)(s.ps(i).c).b:=TRUE;
    END LOOP;
    FOR i IN 0..4 LOOP
        IF i=2 THEN
            IF f=1 THEN
                w(RPAD(s.sv,10,k));
            ELSE
                w(RPAD(s.sv,14,k) || RPAD(s.sn,10,k));
            END IF;
        ELSE
            IF f=1 THEN
                w(RPAD(k,10,k));
            ELSE
                w(RPAD(k,24,k));
            END IF;
        END IF;
        FOR j IN 0..4 LOOP
            IF t(i)(j).b THEN
                w('■');
            ELSE
                w('□');
            END IF;
        END LOOP;
        w(k,1);
    END LOOP;
    w(k,1);
END;
FUNCTION gk(ps PS_) RETURN v IS
    r v;
    t sys.owa_util.num_arr;
    s M_;
    d v;
    e v;
BEGIN
    FOR i IN 0..4 LOOP
        t(i):=a(ps(i).r)(ps(i).c).pv;
    END LOOP;
    d:=t.FIRST;
    WHILE d IS NOT NULL LOOP
      s(t(d)):=t(d);
      d:=t.NEXT(d);
    END LOOP;
    e:=s.FIRST;
    WHILE e IS NOT NULL LOOP
      r:=r||'_'||s(e);
      e:=s.NEXT(e);
    END LOOP;
    RETURN r;
END;
FUNCTION ia(m IN OUT PS_,p P_) RETURN BOOLEAN IS
    i v;
BEGIN
    IF m.COUNT = 0 THEN
        RETURN TRUE;
    END IF;
    i := m.FIRST;
    WHILE i IS NOT NULL LOOP
        IF (p.c=m(i).c AND ABS(p.r-m(i).r)=1) OR
           (p.r=m(i).r AND ABS(p.c-m(i).c)=1) THEN
           RETURN TRUE;
        END IF;
        i := m.NEXT(i);
    END LOOP;
    RETURN FALSE;
END;
FUNCTION ic(h S_) RETURN BOOLEAN IS
    pm PS_;
    ps PS_:=h.ps;
    pv v;
BEGIN
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            pv := a(ps(j).r)(ps(j).c).pv;
            IF (NOT pm.EXISTS(pv)) AND ia(pm,ps(j)) THEN
                pm(pv) := ps(j);
                EXIT;
            END IF;
        END LOOP;
    END LOOP;
    RETURN pm.COUNT=5;
END;
FUNCTION ro(h S_,f v) RETURN S_ IS
    r v;
    c v;
    mr v;
    mc v;
    s S_;
    sv v:=0;
BEGIN
    s.r:=h.c;
    s.c:=h.r;
    IF f=5 THEN
        s.r:=h.r;
        s.c:=h.c;
    END IF;
    mr := h.mp.r;
    mc := h.mp.c;
    FOR i IN 0..4 LOOP
        r:=-h.ps(i).c+mc+s.r-1;
        c:=h.ps(i).r-mr;
        IF f=5 THEN
            r:=h.ps(i).r;
            c:=s.c-h.ps(i).c-1;
        END IF;
        s.ps(i).r:=r;
        s.ps(i).c:=c;
        sv:=sv+a(r)(c).pv;
    END LOOP;
    s.mp.r:=0;
    s.mp.c:=0;
    s.sv:=sv;
    s.k:=gk(s.ps);
    RETURN s;
END;
PROCEDURE so(f v) IS
    t S_;
BEGIN
    FOR i IN REVERSE 0..ss.COUNT-1
    LOOP
      FOR j IN 1..i LOOP
         IF ss(j-1).sv<ss(j).sv OR (ss(j-1).sv=ss(j).sv AND ss(j-1).k<ss(j).k) THEN
            t:=ss(j-1);
            ss(j-1):=ss(j);
            ss(j):=t;
         END IF;
      END LOOP;
      IF f=1 OR (f=2 AND ss(i).b=1) THEN
          ws(ss(i),f);
      END IF;
    END LOOP;
END;
PROCEDURE se(f v) IS
    s S_;
    m M_;
    mv v:=0;
    mi v:=0;
    mk v;
    rn v;
    b BOOLEAN;
    sn v;
    p P_;
BEGIN
    ss.DELETE;
    FOR i IN 0..4 LOOP
      FOR j IN 0..4 LOOP
        p.r:=i;
        p.c:=j;
        p.pv:=i*5+j+1;
        p.b:=FALSE;
        a(i)(j):=p;
      END LOOP;
    END LOOP;
    OPEN c1;
    LOOP
       s:=su;
       FETCH c1 INTO s.ps(0).r,s.ps(0).c,s.ps(1).r,s.ps(1).c,s.ps(2).r,s.ps(2).c,s.ps(3).r,s.ps(3).c,s.ps(4).r,s.ps(4).c,s.r,s.c,s.mp.r,s.mp.c;
       EXIT WHEN c1%NOTFOUND;
       IF ic(s) THEN
           mi:=0;
           mv:=0;
           b:=FALSE;
           sn:=0;
           FOR i IN 1..8 LOOP
               s:=ro(s,i);
               IF NOT m.EXISTS(s.k) THEN
                   rn:=ss.COUNT;
                   ss(rn):=s;
                   m(s.k):=s.k;
                   sn:=sn+1;
                   IF mv=0 OR s.sv<mv OR (s.sv=mv AND s.k<mk) THEN
                       mv:=s.sv;
                       mi:=rn;
                       mk:=s.k;
                   END IF;
                   b:=TRUE;
               END IF;
           END LOOP;
           IF b THEN
               ss(mi).b:=1;
               ss(mi).sn:=sn;
           END IF;
       END IF;
    END LOOP;
    so(f);
    CLOSE c1;
END;
PROCEDURE output_allshapes IS
BEGIN
    w('SHAPE_VAL SHAPE',1);
    se(1);
END;
PROCEDURE output_allbaseshapes IS
BEGIN
    w('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);
    se(2);
END;
END;

import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

public class CalcShape {
    private int[][] values = new int[5][5];
    private static int[] a = new int[25];
    private List<Shape> shapeList = new ArrayList<Shape>();
    private Map<String,String> shapeMap = new HashMap<String,String>();
    int loop = 0 ;
    int correctShapeCnt = 0;
    public void main() {
        for (int i = 0;i < values.length;i++) {
            for (int j = 0;j < values.length;j++) {
                int v = i * 5 + j + 1;
                values[i][j] = v;
                a[v - 1] = v;
            }
        }
        selectShape(0, 1, new int[5], 5);
        System.out.println(loop);
        System.out.println(correctShapeCnt);
//        Collections.sort(shapeList);
//        for (Shape shape : shapeList) {
//            printShape(shape);
//        }

    }

    private void printShape(Shape shape) {
        System.out.println("==value:" + shape.getValue() + "==id:" + shape.getId());
        boolean[][] shapes = shape.getShapes();
        for (int i = 0; i < shapes.length; i++) {
            for (int j = 0; j < shapes.length; j++) {
                String str = "";
                if (shapes[i][j]) {
                    str = "■";
                } else {
                    str = "□";
                }
                System.out.print(str + "    ");
            }
            System.out.println("\n");
        }
    }

    private boolean isCorrectShape(Shape shape) {
        List<Point> points = shape.getPoints();
        Map<Integer,Point> map = new HashMap<Integer,Point>();
        for (int i = 0;i < 5;i++) {
            for (Point point : points) {
                int oneRow = point.getRowIndex();
                int oneCol = point.getColIndex();
                if (map.containsKey(values[oneRow][oneCol])) {
                    continue;
                }
                if (isAdjacent(map,point)) {
                    map.put(values[oneRow][oneCol], point);
                    break;
                }
            }
        }

        if (map.size() == 5) {
            return true;
        }
        return false;
    }
    
    private boolean isAdjacent(Map<Integer,Point> map,Point point) {
        int oneRow = point.getRowIndex();
        int oneCol = point.getColIndex();
        if (map.isEmpty()) {
            return true;
        }
        Set<Map.Entry<Integer, Point>> set = map.entrySet();
        for (Iterator<Map.Entry<Integer, Point>> it = set.iterator(); it.hasNext();) {
            Map.Entry<Integer, Point> entry = (Map.Entry<Integer, Point>) it.next();
            int twoRow = entry.getValue().getRowIndex();
            int twoCol = entry.getValue().getColIndex();
            if ((oneCol == twoCol && Math.abs(oneRow - twoRow) == 1)
                    || (oneRow == twoRow && Math.abs(oneCol - twoCol) == 1)) {
                map.put(values[oneRow][oneCol], point);
                return true;
            }
        }
        return false;
    }

    private Shape transformToShape(int[] arrs) {
        Shape newShape = new Shape();
        List<Point> points = new ArrayList<Point>();
        int minRow = 0;
        int minCol = 0;
        int maxRow = 0;
        int maxCol = 0;

        boolean[][] x_shapes = new boolean[5][5];
        boolean isFirstElement = true;
        for (int i = 0; i < values.length; i++) {
            for (int j = 0; j < values.length; j++) {
                x_shapes[i][j] = false;
                for (int k = 0; k < arrs.length; k++) {
                    if (values[i][j] == arrs[k]) {
                        if (isFirstElement) {
                            isFirstElement = false;
                            minRow = i;
                            maxRow = i;
                            minCol = j;
                            maxCol = j;
                        }
                        x_shapes[i][j] = true;
                        points.add(new Point(i, j));
                        if (i < minRow) {
                            minRow = i;
                        }
                        if (i > maxRow) {
                            maxRow = i;
                        }
                        if (j < minCol) {
                            minCol = j;
                        }
                        if (j > maxCol) {
                            maxCol = j;
                        }
                    }
                }
            }
        }
        newShape.setMinPoint(new Point(minRow, minCol));
        newShape.setShapes(x_shapes);
        newShape.setPoints(points);
        newShape.setRowWidth(maxRow - minRow + 1);
        newShape.setColWidth(maxCol - minCol + 1);
        newShape.setId(getShapeId(newShape));
        return newShape;
    }

    private Shape rotateMirrorShape(Shape shape,int flag) {
        Shape newShape = new Shape();
        boolean[][] newShapes = newShape.getShapes();
        boolean[][] shapes = shape.getShapes();
        if (flag == 0) {
            newShape.setRowWidth(shape.getColWidth());
            newShape.setColWidth(shape.getRowWidth());
        } else {
            newShape.setRowWidth(shape.getRowWidth());
            newShape.setColWidth(shape.getColWidth());
        }

        newShape.setGroupId(shape.getGroupId());
        int value = 0;
        int minRow = shape.getMinPoint().getRowIndex();
        int minCol = shape.getMinPoint().getColIndex();
        for (int i = 0; i < shapes.length; i++) {
            for (int j = 0; j < shapes.length; j++) {
                if (shapes[i][j]) {
                    int rowIndex;
                    int colIndex;
                    if (flag == 0) {
                        rowIndex = -j + minCol+ newShape.getRowWidth() - 1;
                        colIndex = i - minRow;
                    } else {
                        rowIndex = i;
                        colIndex = newShape.getColWidth() - j - 1;
                    }
                    newShapes[rowIndex][colIndex] = true;
                    value += values[rowIndex][colIndex];
                }
            }
        }
        newShape.setMinPoint(new Point(0,0));
        newShape.setValue(value);
        newShape.setId(getShapeId(newShape));
        return newShape;
    }
    
    private void selectShape(int head, int index, int[] r, int k) {
        for (int i = head; i < a.length + index - k; i++) {
            if (index < k) {
                r[index - 1] = a[i];
                selectShape(i + 1, index + 1, r, k);
            } else if (index == k) {
                r[index - 1] = a[i];
                processShape(r);
                loop++;
                selectShape(i + 1, index + 1, r, k);
            } else {
                return;
            }
        }
    }
    
    private void print(Shape shape) {
        boolean[][] shapes = shape.getShapes();
        for (int i = 0; i < shapes.length; i++) {
            for (int j = 0; j < shapes.length; j++) {
                if (shapes[i][j]) {
                    System.out.print(values[i][j] + ",");
                }
            }
        }
        System.out.println();
    }
    
    private void processShape(int[] r) {
        Shape shape = transformToShape(r);
        if (isCorrectShape(shape)) {
            correctShapeCnt++;
//            for (int i = 0;i < 4;i++) {
//                shape = rotateMirrorShape(shape,0);
//                if (!shapeMap.containsKey(shape.getId())) {
//                    shapeList.add(shape);
//                    shapeMap.put(shape.getId(), shape.getId());
//                }
//                Shape mirrorShape = rotateMirrorShape(shape,1);
//                if (!shapeMap.containsKey(mirrorShape.getId())) {
//                    shapeList.add(mirrorShape);
//                    shapeMap.put(mirrorShape.getId(), mirrorShape.getId());
//                }
//            }
        }
    }
    
    private String getShapeId(Shape shape) {
        boolean[][] shapes = shape.getShapes();
        String id = "";
        for (int i = 0; i < shapes.length; i++) {
            for (int j = 0; j < shapes.length; j++) {
                if (shapes[i][j]) {
                    id = id + "_" + values[i][j];
                }
            }
        }
        return id;
    }
}

CREATE OR REPLACE PACKAGE BODY FIVESQUARESHAPE IS

SUBTYPE v IS VARCHAR(99);



TYPE POINT IS RECORD (
    row_idx v,
    col_idx v,
    point_value v,
    status BOOLEAN
);

TYPE POINT_ARRAYS IS TABLE OF POINT INDEX BY BINARY_INTEGER;

TYPE SHAPE_TYPE IS RECORD (
    row_width v,
    col_width v,
    shape_id  v,
    shape_value v,
    points POINT_ARRAYS,
    min_point POINT,
    shape_cnt v,
    isBaseShape v
);

shape_null SHAPE_TYPE;

TYPE SHAPE_LIST_TYPE IS TABLE OF SHAPE_TYPE INDEX BY BINARY_INTEGER;
shape_list SHAPE_LIST_TYPE;
TYPE Hash_Map IS TABLE OF v INDEX BY v;

TYPE row_type IS TABLE OF POINT_ARRAYS INDEX BY BINARY_INTEGER;

cols POINT_ARRAYS;

arrays row_type;

CURSOR c1 IS
WITH t AS (
    SELECT LEVEL - 1 idx,LEVEL v FROM DUAL CONNECT BY LEVEL <= 5
)
,tb AS (
    SELECT t1.idx row_idx,t2.idx col_idx,t1.idx * 5 + t2.v v FROM t t1,t t2
)
SELECT a.row_idx row_idx1,
       a.col_idx col_idx1,
       b.row_idx row_idx2,
       b.col_idx col_idx2,
       c.row_idx row_idx3,
       c.col_idx col_idx3,
       d.row_idx row_idx4,
       d.col_idx col_idx4,
       e.row_idx row_idx5,
       e.col_idx col_idx5,
       GREATEST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) - LEAST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) + 1 row_width,
       GREATEST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) - LEAST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) + 1 col_width,
       LEAST(a.row_idx,b.row_idx,c.row_idx,d.row_idx,e.row_idx) min_row,
       LEAST(a.col_idx,b.col_idx,c.col_idx,d.col_idx,e.col_idx) min_col
  FROM tb a,
       tb b,
       tb c,
       tb d,
       tb e
 WHERE a.v < b.v
   AND b.v < c.v
   AND c.v < d.v
   AND d.v < e.v;

PROCEDURE p(s v,f v DEFAULT '')
AS
BEGIN
    IF f=1 THEN
        DBMS_OUTPUT.PUT_LINE(s);
    ELSE
        DBMS_OUTPUT.PUT(s);
    END IF;
    
END;

PROCEDURE printShape(shape SHAPE_TYPE,flag v) IS
    tmp_arrays row_type;
BEGIN
    tmp_arrays := arrays;
    FOR i IN shape.points.FIRST .. shape.points.LAST LOOP
        tmp_arrays(shape.points(i).row_idx)(shape.points(i).col_idx).status := TRUE;
    END LOOP;

    FOR i IN 0..4 LOOP
        IF i=2 THEN
            IF flag = 1 THEN
                p(RPAD(shape.shape_value,10,' '));
            ELSE
                p(RPAD(shape.shape_value,14,' ') || RPAD(shape.shape_cnt,10,' '));
            END IF;
        ELSE
            IF flag = 1 THEN
                p(RPAD(' ',10,' '));
            ELSE
                p(RPAD(' ',24,' '));
            END IF;
        END IF;
        FOR j IN 0..4 LOOP
            IF tmp_arrays(i)(j).status THEN
                p('■');
            ELSE
                p('□');
            END IF;
        END LOOP;
        p('',1);
    END LOOP;
    p(' ',1);
END;

FUNCTION getShapeId(points POINT_ARRAYS) RETURN v IS
    str v;
    tab sys.owa_util.num_arr;
    type sorted_tab is table of v index by BINARY_INTEGER;
    sorted sorted_tab;
    id1 pls_integer;
    id2 v;
BEGIN
    FOR i IN points.FIRST .. points.LAST LOOP
        tab(i) := arrays(points(i).row_idx)(points(i).col_idx).point_value;
    END LOOP;
    id1 := tab.FIRST;
    WHILE id1 IS NOT NULL LOOP
            sorted(tab(id1)) := tab(id1);
            id1 := tab.NEXT(id1);
    END LOOP;
    id2  := sorted.FIRST;
    WHILE id2 IS NOT NULL LOOP
            str := str || '_' || sorted(id2);
            id2 := sorted.NEXT(id2);
    END LOOP;
    RETURN str;
END;



PROCEDURE initData IS
    newPoint Point;
BEGIN
    FOR i IN 0..4 LOOP
        FOR j IN 0..4 LOOP
            newPoint.row_idx := i;
            newPoint.col_idx := j;
            newPoint.point_value := i * 5 + j + 1;
            newPoint.status := FALSE;
            arrays(i)(j) := newPoint;
        END LOOP;
    END LOOP;
END;

FUNCTION isAdjacent(p_map IN OUT POINT_ARRAYS,p Point) RETURN BOOLEAN IS
    i v;
BEGIN
    IF p_map.COUNT = 0 THEN
        RETURN TRUE;
    END IF;
    i := p_map.FIRST;
    WHILE i IS NOT NULL LOOP
        IF (p.col_idx = p_map(i).col_idx AND ABS(p.row_idx - p_map(i).row_idx) = 1) OR
           (p.row_idx = p_map(i).row_idx AND ABS(p.col_idx - p_map(i).col_idx) = 1) THEN
           RETURN TRUE;
        END IF;
        i := p_map.NEXT(i);
    END LOOP;
    RETURN FALSE;
END;

FUNCTION isCorrectShape(shape SHAPE_TYPE) RETURN BOOLEAN IS
    p_map POINT_ARRAYS;
    points POINT_ARRAYS := shape.points;
    point_value v;
BEGIN
    p_map := cols;
    FOR i IN 0 .. 4 LOOP
        FOR j IN 0 .. 4 LOOP
            point_value := arrays(points(j).row_idx)(points(j).col_idx).point_value;
            IF NOT p_map.EXISTS(point_value) THEN
                IF isAdjacent(p_map,points(j)) THEN
                    p_map(point_value) := points(j);
                    EXIT;
                END IF;
            END IF;
        END LOOP;
    END LOOP;
    IF p_map.COUNT = 5 THEN
        RETURN TRUE;
    END IF;
    RETURN FALSE;
END;

FUNCTION rotateMirrorShape(shape SHAPE_TYPE,flag v) RETURN SHAPE_TYPE IS
    row_idx v;
    col_idx v;
    min_row v;
    min_col v;
    newShape SHAPE_TYPE;
    sum_val v := 0;
BEGIN
    IF flag = 5 THEN
        newShape.row_width := shape.row_width;
        newShape.col_width := shape.col_width;
    ELSE
        newShape.row_width := shape.col_width;
        newShape.col_width := shape.row_width;
    END IF;
    min_row := shape.min_point.row_idx;
    min_col := shape.min_point.col_idx;
    FOR i IN shape.points.FIRST .. shape.points.LAST LOOP
        IF flag = 5 THEN
            row_idx := shape.points(i).row_idx;
            col_idx := newShape.col_width - shape.points(i).col_idx - 1;
        ELSE
            row_idx := -shape.points(i).col_idx + min_col+ newShape.row_width - 1;
            col_idx := shape.points(i).row_idx - min_row;
        END IF;
        newShape.points(i).row_idx := row_idx;
        newShape.points(i).col_idx := col_idx;
        sum_val := sum_val + arrays(row_idx)(col_idx).point_value;
    END LOOP;
    newShape.min_point.row_idx := 0;
    newShape.min_point.col_idx := 0;
    newShape.shape_value := sum_val;
    newShape.shape_id := getShapeId(newShape.points);
    RETURN newShape;
END;

PROCEDURE sortedList(flag v) IS
    n_temp   SHAPE_TYPE;
BEGIN
    FOR i IN REVERSE 0 .. shape_list.COUNT - 1
    LOOP
      FOR j  IN 1 .. i
      LOOP
         IF shape_list(j-1).shape_value < shape_list(j).shape_value OR (shape_list(j-1).shape_value = shape_list(j).shape_value AND shape_list(j-1).shape_id < shape_list(j).shape_id) THEN
            n_temp := shape_list (j-1);
            shape_list (j-1) := shape_list (j);
            shape_list (j) := n_temp;
         END IF;
      END LOOP;
      IF flag=1 OR (flag=2 AND shape_list(i).isBaseShape = 1) THEN
          printShape(shape_list(i),flag);
      END IF;
    END LOOP;
END;

PROCEDURE selectShape(flag v) IS
    newShape SHAPE_TYPE;
    shape_map Hash_Map;
    min_shape_value v := 0;
    min_shape_value_index v := 0;
    min_shape_id v;
    rn v;
    not_exists_flag BOOLEAN;
    shape_cnt v;
BEGIN
    shape_list.DELETE;
    initData;
    OPEN c1;
    LOOP
       newShape := shape_null;
       FETCH c1 INTO newShape.points(0).row_idx,newShape.points(0).col_idx,
                     newShape.points(1).row_idx,newShape.points(1).col_idx,
                     newShape.points(2).row_idx,newShape.points(2).col_idx,
                     newShape.points(3).row_idx,newShape.points(3).col_idx,
                     newShape.points(4).row_idx,newShape.points(4).col_idx,
                     newShape.row_width,
                     newShape.col_width,
                     newShape.min_point.row_idx,
                     newShape.min_point.col_idx;
       EXIT WHEN c1%NOTFOUND;
       IF isCorrectShape(newShape) THEN
           min_shape_value_index := 0;
           min_shape_value := 0;
           not_exists_flag := FALSE;
           shape_cnt := 0;
           FOR i IN 1 .. 8 LOOP
               newShape := rotateMirrorShape(newShape,i);
               IF NOT shape_map.EXISTS(newShape.shape_id) THEN
                   rn := shape_list.COUNT;
                   shape_list(rn) :=  newShape;
                   shape_map(newShape.shape_id) := newShape.shape_id;
                   shape_cnt := shape_cnt + 1;
                   IF min_shape_value = 0 OR newShape.shape_value < min_shape_value OR (newShape.shape_value = min_shape_value AND newShape.shape_id < min_shape_id) THEN
                       min_shape_value := newShape.shape_value;
                       min_shape_value_index := rn;
                       min_shape_id := newShape.shape_id;
                   END IF;
                   not_exists_flag := TRUE;
               END IF;
           END LOOP;
           IF not_exists_flag THEN
               shape_list(min_shape_value_index).isBaseShape := 1;
               shape_list(min_shape_value_index).shape_cnt := shape_cnt;
           END IF;
       END IF;
    END LOOP;
    sortedList(flag);
    CLOSE c1;
END;

PROCEDURE output_allshapes IS
BEGIN
    p('SHAPE_VAL SHAPE',1);
    selectShape(1);
END;

PROCEDURE output_allbaseshapes IS
BEGIN
    p('BASESHAPE_VAL SHAPE_CNT BASESHAPE',1);
    selectShape(2);
END;
END FIVESQUARESHAPE;

地板 德尔 140/平米
瓷砖 冠珠 125/平米 80/平米
卫浴（手盆+马桶+花洒） 金牌 4400
橱柜 美尔 1800/延米

菲林格尔 90/平
金桥地板  128/平

http://dalian.citytogo.com.cn/ 团购

762011985813

http://www.meilele.com/dalian/

http://docs.oracle.com/javase/7/docs/technotes/tools/windows/javadoc.html#comments

http://item.taobao.com/item.htm?id=14645834355

我有三张表 
表A：充值表（记录客户充值记录，包括客户普通充值记录和活动充值记录） 
表B：普通消费表（记录客户消费记录） 
表C: 活动消费表（记录客户活动时消费记录） 

需要我查询这三张表获得用户充值消费记录（出现下面附件中图的显示）。 

你有见过银行存折的数据吗？ 就是把每一步操作都显示出来。 


日期 A.充值金额 赠送金额 B.扣费额 A.活动充值金额 活动赠送金额 C.活动扣费金额 A.充值方式 A.备注

日期 A.充值金额 B.扣费额 A.活动充值金额 C.活动扣费金额 A.充值方式 A.备注

210402198104054127
210202198304102233

http://www.juliandyke.com/Internals/Internals.html

WITH TB AS (
   SELECT  T1.UAI_BUTEN_CODE,
           T1.UAI_ACCOUNT_NUMBER,
           T1.UAI_FAMILY_NAME_KANJI,
           T1.UAI_NAME_KANJI,
           T1.UAI_FAMILY_NAME_KANA,
           T1.UAI_NAME_KANA,
           T1.UAI_PHONE_LONG_DIST,
           T1.UAI_PHONE_CITY_CODE,
           T1.UAI_PHONE_NUMBER,
           T1.UAI_CELLULAR_NUMBER1,
           T1.UAI_CELLULAR_NUMBER2,
           T1.UAI_CELLULAR_NUMBER3,
           T1.UAI_UPDATE
      FROM (SELECT T.UAI_BUTEN_CODE,
                   T.UAI_ACCOUNT_NUMBER,
                   T.UAI_FAMILY_NAME_KANJI,
                   T.UAI_NAME_KANJI,
                   T.UAI_FAMILY_NAME_KANA,
                   T.UAI_NAME_KANA,
                   T.UAI_PHONE_LONG_DIST,
                   T.UAI_PHONE_CITY_CODE,
                   T.UAI_PHONE_NUMBER,
                   T.UAI_CELLULAR_NUMBER1,
                   T.UAI_CELLULAR_NUMBER2,
                   T.UAI_CELLULAR_NUMBER3,
                   T.UAI_UPDATE,
                   SUM(CASE
                         WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                          1
                         ELSE
                          0
                       END) OVER(PARTITION BY TRIM(T.UAI_PHONE_LONG_DIST) || TRIM(T.UAI_PHONE_CITY_CODE) || TRIM(T.UAI_PHONE_NUMBER)) PHONE_CNT1,
                   SUM(CASE
                         WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                          0
                         ELSE
                          1
                       END) OVER(PARTITION BY TRIM(T.UAI_PHONE_LONG_DIST) || TRIM(T.UAI_PHONE_CITY_CODE) || TRIM(T.UAI_PHONE_NUMBER)) PHONE_CNT2,
                   SUM(CASE
                         WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                          1
                         ELSE
                          0
                       END) OVER(PARTITION BY TRIM(T.UAI_CELLULAR_NUMBER1) || TRIM(T.UAI_CELLULAR_NUMBER2) || TRIM(T.UAI_CELLULAR_NUMBER3)) MOBILE_CNT1,
                   SUM(CASE
                         WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                          0
                         ELSE
                          1
                       END) OVER(PARTITION BY TRIM(T.UAI_CELLULAR_NUMBER1) || TRIM(T.UAI_CELLULAR_NUMBER2) || TRIM(T.UAI_CELLULAR_NUMBER3)) MOBILE_CNT2
              FROM USER_ATTRBUTE_INFO_2 T
              WHERE
                    (LTRIM(T.UAI_CELLULAR_NUMBER1 || T.UAI_CELLULAR_NUMBER2 || T.UAI_CELLULAR_NUMBER3,'0 ') IS NOT NULL
                OR   LTRIM(T.UAI_PHONE_LONG_DIST  || T.UAI_PHONE_CITY_CODE  || T.UAI_PHONE_NUMBER,'0 ') IS NOT NULL)
              ) T1
     WHERE (T1.PHONE_CNT1 > 0 AND T1.PHONE_CNT2 > 0)
        OR (T1.MOBILE_CNT1 > 0 AND T1.MOBILE_CNT2 > 0)
),CURRENT_TB AS (
    SELECT TB.UAI_BUTEN_CODE,
           TB.UAI_ACCOUNT_NUMBER,
           TB.UAI_FAMILY_NAME_KANJI,
           TB.UAI_NAME_KANJI,        
           TB.UAI_FAMILY_NAME_KANA,        
           TB.UAI_NAME_KANA,        
           TB.UAI_PHONE_LONG_DIST,        
           TB.UAI_PHONE_CITY_CODE,        
           TB.UAI_PHONE_NUMBER,        
           TB.UAI_CELLULAR_NUMBER1,        
           TB.UAI_CELLULAR_NUMBER2,        
           TB.UAI_CELLULAR_NUMBER3,        
           TB.UAI_UPDATE,        
           '1' DATA_FLAG
      FROM TB
     WHERE TB.UAI_UPDATE >=
           TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS')
),BEFORE_TB AS (
    SELECT TB.UAI_BUTEN_CODE,
           TB.UAI_ACCOUNT_NUMBER,
           TB.UAI_FAMILY_NAME_KANJI,
           TB.UAI_NAME_KANJI,        
           TB.UAI_FAMILY_NAME_KANA,        
           TB.UAI_NAME_KANA,        
           TB.UAI_PHONE_LONG_DIST,        
           TB.UAI_PHONE_CITY_CODE,        
           TB.UAI_PHONE_NUMBER,        
           TB.UAI_CELLULAR_NUMBER1,        
           TB.UAI_CELLULAR_NUMBER2,        
           TB.UAI_CELLULAR_NUMBER3,        
           TB.UAI_UPDATE,
           '0' DATA_FLAG
      FROM TB
     WHERE TB.UAI_UPDATE IS NULL
        OR TB.UAI_UPDATE <
           TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS')
),SPLIT_TB AS (
    SELECT CURRENT_TB.UAI_BUTEN_CODE || CURRENT_TB.UAI_ACCOUNT_NUMBER GROUPID,
           CURRENT_TB.UAI_BUTEN_CODE        CURRENT_UAI_BUTEN_CODE,
           CURRENT_TB.UAI_ACCOUNT_NUMBER    CURRENT_UAI_ACCOUNT_NUMBER,
           CURRENT_TB.UAI_FAMILY_NAME_KANJI CURRENT_UAI_FAMILY_NAME_KANJI,
           CURRENT_TB.UAI_NAME_KANJI        CURRENT_UAI_NAME_KANJI,        
           CURRENT_TB.UAI_FAMILY_NAME_KANA  CURRENT_UAI_FAMILY_NAME_KANA,        
           CURRENT_TB.UAI_NAME_KANA         CURRENT_UAI_NAME_KANA,        
           CURRENT_TB.UAI_PHONE_LONG_DIST   CURRENT_UAI_PHONE_LONG_DIST,        
           CURRENT_TB.UAI_PHONE_CITY_CODE   CURRENT_UAI_PHONE_CITY_CODE,        
           CURRENT_TB.UAI_PHONE_NUMBER      CURRENT_UAI_PHONE_NUMBER,        
           CURRENT_TB.UAI_CELLULAR_NUMBER1  CURRENT_UAI_CELLULAR_NUMBER1,        
           CURRENT_TB.UAI_CELLULAR_NUMBER2  CURRENT_UAI_CELLULAR_NUMBER2,        
           CURRENT_TB.UAI_CELLULAR_NUMBER3  CURRENT_UAI_CELLULAR_NUMBER3,        
           CURRENT_TB.UAI_UPDATE            CURRENT_UAI_UPDATE,        
           CURRENT_TB.DATA_FLAG             CURRENT_DATA_FLAG,
           BEFORE_TB.UAI_BUTEN_CODE         BEFORE_UAI_BUTEN_CODE,
           BEFORE_TB.UAI_ACCOUNT_NUMBER     BEFORE_UAI_ACCOUNT_NUMBER,
           BEFORE_TB.UAI_FAMILY_NAME_KANJI  BEFORE_UAI_FAMILY_NAME_KANJI,
           BEFORE_TB.UAI_NAME_KANJI         BEFORE_UAI_NAME_KANJI,        
           BEFORE_TB.UAI_FAMILY_NAME_KANA   BEFORE_UAI_FAMILY_NAME_KANA,        
           BEFORE_TB.UAI_NAME_KANA          BEFORE_UAI_NAME_KANA,        
           BEFORE_TB.UAI_PHONE_LONG_DIST    BEFORE_UAI_PHONE_LONG_DIST,        
           BEFORE_TB.UAI_PHONE_CITY_CODE    BEFORE_UAI_PHONE_CITY_CODE,        
           BEFORE_TB.UAI_PHONE_NUMBER       BEFORE_UAI_PHONE_NUMBER,        
           BEFORE_TB.UAI_CELLULAR_NUMBER1   BEFORE_UAI_CELLULAR_NUMBER1,        
           BEFORE_TB.UAI_CELLULAR_NUMBER2   BEFORE_UAI_CELLULAR_NUMBER2,        
           BEFORE_TB.UAI_CELLULAR_NUMBER3   BEFORE_UAI_CELLULAR_NUMBER3,        
           BEFORE_TB.UAI_UPDATE             BEFORE_UAI_UPDATE,
           BEFORE_TB.DATA_FLAG              BEFORE_DATA_FLAG,
         CASE WHEN
                ((TRIM(CURRENT_TB.UAI_PHONE_LONG_DIST) || TRIM(CURRENT_TB.UAI_PHONE_CITY_CODE) || TRIM(CURRENT_TB.UAI_PHONE_NUMBER)) =
                 (TRIM(BEFORE_TB.UAI_PHONE_LONG_DIST)  || TRIM(BEFORE_TB.UAI_PHONE_CITY_CODE)  || TRIM(BEFORE_TB.UAI_PHONE_NUMBER))) AND
                ((TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER1) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER2) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER3)) = 
                 (TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER1)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER2)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER3)))
              THEN '1'
              WHEN
                ((TRIM(CURRENT_TB.UAI_PHONE_LONG_DIST) || TRIM(CURRENT_TB.UAI_PHONE_CITY_CODE) || TRIM(CURRENT_TB.UAI_PHONE_NUMBER)) =
                 (TRIM(BEFORE_TB.UAI_PHONE_LONG_DIST)  || TRIM(BEFORE_TB.UAI_PHONE_CITY_CODE)  || TRIM(BEFORE_TB.UAI_PHONE_NUMBER)))
              THEN '2'
              WHEN
                ((TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER1) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER2) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER3)) = 
                 (TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER1)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER2)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER3)))
              THEN '3'
         END BEFORE_DATA_DIFF
      FROM CURRENT_TB,
           BEFORE_TB
     WHERE ((TRIM(CURRENT_TB.UAI_PHONE_LONG_DIST) || TRIM(CURRENT_TB.UAI_PHONE_CITY_CODE) || TRIM(CURRENT_TB.UAI_PHONE_NUMBER)) =
            (TRIM(BEFORE_TB.UAI_PHONE_LONG_DIST)  || TRIM(BEFORE_TB.UAI_PHONE_CITY_CODE)  || TRIM(BEFORE_TB.UAI_PHONE_NUMBER)))
        OR ((TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER1) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER2) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER3)) = 
            (TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER1)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER2)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER3)))
)
SELECT M.UAI_BUTEN_CODE,
       M.UAI_ACCOUNT_NUMBER,
       TRIM(M.UAI_FAMILY_NAME_KANJI) || ' ' || TRIM(M.UAI_NAME_KANJI),
       TRIM(M.UAI_FAMILY_NAME_KANA) || ' ' || TRIM(M.UAI_NAME_KANA),
       TRIM(M.UAI_PHONE_LONG_DIST)  || TRIM(M.UAI_PHONE_CITY_CODE)  || TRIM(M.UAI_PHONE_NUMBER),
       TRIM(M.UAI_CELLULAR_NUMBER1) || TRIM(M.UAI_CELLULAR_NUMBER2) || TRIM(M.UAI_CELLULAR_NUMBER3),
       M.DATA_DIFF,
       DATA_FLAG,UAI_UPDATE,GROUPID
  FROM (
       SELECT SPLIT_TB.GROUPID,
               SPLIT_TB.CURRENT_UAI_BUTEN_CODE        UAI_BUTEN_CODE,
               SPLIT_TB.CURRENT_UAI_ACCOUNT_NUMBER    UAI_ACCOUNT_NUMBER,
               SPLIT_TB.CURRENT_UAI_FAMILY_NAME_KANJI UAI_FAMILY_NAME_KANJI,
               SPLIT_TB.CURRENT_UAI_NAME_KANJI        UAI_NAME_KANJI,
               SPLIT_TB.CURRENT_UAI_FAMILY_NAME_KANA  UAI_FAMILY_NAME_KANA,
               SPLIT_TB.CURRENT_UAI_NAME_KANA 	      UAI_NAME_KANA,
               SPLIT_TB.CURRENT_UAI_PHONE_LONG_DIST   UAI_PHONE_LONG_DIST,
               SPLIT_TB.CURRENT_UAI_PHONE_CITY_CODE   UAI_PHONE_CITY_CODE,
               SPLIT_TB.CURRENT_UAI_PHONE_NUMBER      UAI_PHONE_NUMBER,
               SPLIT_TB.CURRENT_UAI_CELLULAR_NUMBER1  UAI_CELLULAR_NUMBER1,
               SPLIT_TB.CURRENT_UAI_CELLULAR_NUMBER2  UAI_CELLULAR_NUMBER2,
               SPLIT_TB.CURRENT_UAI_CELLULAR_NUMBER3  UAI_CELLULAR_NUMBER3,
               SPLIT_TB.CURRENT_UAI_UPDATE            UAI_UPDATE,
               SPLIT_TB.CURRENT_DATA_FLAG             DATA_FLAG,
               '0'                                    DATA_DIFF
          FROM SPLIT_TB
         WHERE CURRENT_DATA_FLAG = '1'
        UNION ALL
        SELECT SPLIT_TB.GROUPID,
               SPLIT_TB.BEFORE_UAI_BUTEN_CODE        UAI_BUTEN_CODE,
               SPLIT_TB.BEFORE_UAI_ACCOUNT_NUMBER    UAI_ACCOUNT_NUMBER,
               SPLIT_TB.BEFORE_UAI_FAMILY_NAME_KANJI UAI_FAMILY_NAME_KANJI,
               SPLIT_TB.BEFORE_UAI_NAME_KANJI        UAI_NAME_KANJI,
               SPLIT_TB.BEFORE_UAI_FAMILY_NAME_KANA  UAI_FAMILY_NAME_KANA,
               SPLIT_TB.BEFORE_UAI_NAME_KANA 	       UAI_NAME_KANA,
               SPLIT_TB.BEFORE_UAI_PHONE_LONG_DIST   UAI_PHONE_LONG_DIST,
               SPLIT_TB.BEFORE_UAI_PHONE_CITY_CODE   UAI_PHONE_CITY_CODE,
               SPLIT_TB.BEFORE_UAI_PHONE_NUMBER      UAI_PHONE_NUMBER,
               SPLIT_TB.BEFORE_UAI_CELLULAR_NUMBER1  UAI_CELLULAR_NUMBER1,
               SPLIT_TB.BEFORE_UAI_CELLULAR_NUMBER2  UAI_CELLULAR_NUMBER2,
               SPLIT_TB.BEFORE_UAI_CELLULAR_NUMBER3  UAI_CELLULAR_NUMBER3,
               SPLIT_TB.BEFORE_UAI_UPDATE            UAI_UPDATE,
               SPLIT_TB.BEFORE_DATA_FLAG             DATA_FLAG,
               SPLIT_TB.BEFORE_DATA_DIFF             DATA_DIFF
          FROM SPLIT_TB
        ) M
 ORDER BY M.GROUPID,
          M.DATA_FLAG DESC,
          M.DATA_DIFF

    WITH TB AS (
       SELECT T1.UAI_BUTEN_CODE,
               T1.UAI_ACCOUNT_NUMBER,
               T1.UAI_FAMILY_NAME_KANJI,
               T1.UAI_NAME_KANJI,
               T1.UAI_FAMILY_NAME_KANA,
               T1.UAI_NAME_KANA,
               T1.UAI_PHONE_LONG_DIST,
               T1.UAI_PHONE_CITY_CODE,
               T1.UAI_PHONE_NUMBER,
               T1.UAI_CELLULAR_NUMBER1,
               T1.UAI_CELLULAR_NUMBER2,
               T1.UAI_CELLULAR_NUMBER3,
               T1.UAI_UPDATE
          FROM (SELECT T.UAI_BUTEN_CODE,
                       T.UAI_ACCOUNT_NUMBER,
                       T.UAI_FAMILY_NAME_KANJI,
                       T.UAI_NAME_KANJI,
                       T.UAI_FAMILY_NAME_KANA,
                       T.UAI_NAME_KANA,
                       T.UAI_PHONE_LONG_DIST,
                       T.UAI_PHONE_CITY_CODE,
                       T.UAI_PHONE_NUMBER,
                       T.UAI_CELLULAR_NUMBER1,
                       T.UAI_CELLULAR_NUMBER2,
                       T.UAI_CELLULAR_NUMBER3,
                       T.UAI_UPDATE,
                       SUM(CASE
                             WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                              1
                             ELSE
                              0
                           END) OVER(PARTITION BY TRIM(T.UAI_PHONE_LONG_DIST) || TRIM(T.UAI_PHONE_CITY_CODE) || TRIM(T.UAI_PHONE_NUMBER)) PHONE_CNT1,
                       SUM(CASE
                             WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                              0
                             ELSE
                              1
                           END) OVER(PARTITION BY TRIM(T.UAI_PHONE_LONG_DIST) || TRIM(T.UAI_PHONE_CITY_CODE) || TRIM(T.UAI_PHONE_NUMBER)) PHONE_CNT2,
                       SUM(CASE
                             WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                              1
                             ELSE
                              0
                           END) OVER(PARTITION BY TRIM(T.UAI_CELLULAR_NUMBER1) || TRIM(T.UAI_CELLULAR_NUMBER2) || TRIM(T.UAI_CELLULAR_NUMBER3)) MOBILE_CNT1,
                       SUM(CASE
                             WHEN T.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS') THEN
                              0
                             ELSE
                              1
                           END) OVER(PARTITION BY TRIM(T.UAI_CELLULAR_NUMBER1) || TRIM(T.UAI_CELLULAR_NUMBER2) || TRIM(T.UAI_CELLULAR_NUMBER3)) MOBILE_CNT2
                  FROM USER_ATTRBUTE_INFO_2 T
                  WHERE
                        (LTRIM(T.UAI_CELLULAR_NUMBER1 || T.UAI_CELLULAR_NUMBER2 || T.UAI_CELLULAR_NUMBER3,'0 ') IS NOT NULL
                    OR   LTRIM(T.UAI_PHONE_LONG_DIST  || T.UAI_PHONE_CITY_CODE  || T.UAI_PHONE_NUMBER,'0 ') IS NOT NULL)
                  ) T1
         WHERE (T1.PHONE_CNT1 > 0 AND T1.PHONE_CNT2 > 0)
            OR (T1.MOBILE_CNT1 > 0 AND T1.MOBILE_CNT2 > 0)
    ),CURRENT_TB AS (
        SELECT TB.*,'1' DATA_FLAG FROM TB WHERE TB.UAI_UPDATE >= TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS')
    ),BEFORE_TB AS (
        SELECT TB.*,'0' DATA_FLAG FROM TB WHERE TB.UAI_UPDATE IS NULL OR TB.UAI_UPDATE < TO_DATE('2011/12/05 7:00:00', 'YYYY/MM/DD HH24:MI:SS')
    )
    SELECT
        M.UAI_BUTEN_CODE,
        M.UAI_ACCOUNT_NUMBER,
        TRIM(M.UAI_FAMILY_NAME_KANJI) || ' ' || TRIM(M.UAI_NAME_KANJI),
        TRIM(M.UAI_FAMILY_NAME_KANA) || ' ' || TRIM(M.UAI_NAME_KANA),
        TRIM(M.UAI_PHONE_LONG_DIST)  || TRIM(M.UAI_PHONE_CITY_CODE)  || TRIM(M.UAI_PHONE_NUMBER),
        TRIM(M.UAI_CELLULAR_NUMBER1) || TRIM(M.UAI_CELLULAR_NUMBER2) || TRIM(M.UAI_CELLULAR_NUMBER3),
        M.DATA_DIFF
      FROM (SELECT CURRENT_TB.UAI_BUTEN_CODE || UAI_ACCOUNT_NUMBER GROUPID,
                   CURRENT_TB.*,'0' DATA_DIFF
              FROM CURRENT_TB
            UNION ALL
            SELECT CURRENT_TB.UAI_BUTEN_CODE || CURRENT_TB.UAI_ACCOUNT_NUMBER GROUPID,
                   BEFORE_TB.*,
                 CASE WHEN
                        ((TRIM(CURRENT_TB.UAI_PHONE_LONG_DIST) || TRIM(CURRENT_TB.UAI_PHONE_CITY_CODE) || TRIM(CURRENT_TB.UAI_PHONE_NUMBER)) =
                         (TRIM(BEFORE_TB.UAI_PHONE_LONG_DIST)  || TRIM(BEFORE_TB.UAI_PHONE_CITY_CODE)  || TRIM(BEFORE_TB.UAI_PHONE_NUMBER))) AND
                        ((TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER1) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER2) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER3)) = 
                         (TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER1)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER2)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER3)))
                      THEN '1'
                      WHEN
                        ((TRIM(CURRENT_TB.UAI_PHONE_LONG_DIST) || TRIM(CURRENT_TB.UAI_PHONE_CITY_CODE) || TRIM(CURRENT_TB.UAI_PHONE_NUMBER)) =
                         (TRIM(BEFORE_TB.UAI_PHONE_LONG_DIST)  || TRIM(BEFORE_TB.UAI_PHONE_CITY_CODE)  || TRIM(BEFORE_TB.UAI_PHONE_NUMBER)))
                      THEN '2'
                      WHEN
                        ((TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER1) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER2) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER3)) = 
                         (TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER1)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER2)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER3)))
                      THEN '3'
                 END DATA_DIFF
              FROM CURRENT_TB,
                   BEFORE_TB
             WHERE ((TRIM(CURRENT_TB.UAI_PHONE_LONG_DIST) || TRIM(CURRENT_TB.UAI_PHONE_CITY_CODE) || TRIM(CURRENT_TB.UAI_PHONE_NUMBER)) =
                    (TRIM(BEFORE_TB.UAI_PHONE_LONG_DIST)  || TRIM(BEFORE_TB.UAI_PHONE_CITY_CODE)  || TRIM(BEFORE_TB.UAI_PHONE_NUMBER)))
                OR ((TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER1) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER2) || TRIM(CURRENT_TB.UAI_CELLULAR_NUMBER3)) = 
                    (TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER1)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER2)  || TRIM(BEFORE_TB.UAI_CELLULAR_NUMBER3)))
            ) M
     ORDER BY M.GROUPID,
              M.DATA_FLAG DESC,
              M.DATA_DIFF
    

SELECT t1.*,
       t2.phone_cnt1,
       t2.phone_cnt2,
       t2.mobile_cnt1,
       t2.mobile_cnt2
  FROM tel_info2 t1,
       (SELECT rid,
               phone_cnt1,
               phone_cnt2,
               mobile_cnt1,
               mobile_cnt2
          FROM (SELECT ROWID rid,
                       tel_id,
                       SUM(CASE
                             WHEN t.datetime < to_date('2011-12-7', 'yyyy-mm-dd') THEN
                              0
                             ELSE
                              1
                           END) OVER(PARTITION BY tel_number) phone_cnt1,
                       SUM(CASE
                             WHEN t.datetime >= to_date('2011-12-7', 'yyyy-mm-dd') THEN
                              0
                             ELSE
                              1
                           END) OVER(PARTITION BY tel_number) phone_cnt2,
                       SUM(CASE
                             WHEN t.datetime < to_date('2011-12-7', 'yyyy-mm-dd') THEN
                              0
                             ELSE
                              1
                           END) OVER(PARTITION BY MOBILE_NUMBER) mobile_cnt1,
                       SUM(CASE
                             WHEN t.datetime >= to_date('2011-12-7', 'yyyy-mm-dd') THEN
                              0
                             ELSE
                              1
                           END) OVER(PARTITION BY MOBILE_NUMBER) mobile_cnt2
                  FROM tel_info2 t)
         WHERE (phone_cnt1 > 0 AND phone_cnt2 > 0)
            OR (mobile_cnt1 > 0 AND mobile_cnt2 > 0)) t2
 WHERE t1.ROWID = t2.rid

insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100003, null, null, null, null, null, null, '名前_氏3', '名前_名3', 'ナマエ_シ3', 'ナマエ_メイ3', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0003', null, '080    ', '0001', '0003', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('05-12-2011 07:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100001, null, null, null, null, null, null, '名前_氏1', '名前_名1', 'ナマエ_シ1', 'ナマエ_メイ1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0001', null, '080    ', '0001', '0001', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('05-12-2011 07:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100002, null, null, null, null, null, null, '名前_氏2', '名前_名2', 'ナマエ_シ2', 'ナマエ_メイ2', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0002', null, '080    ', '0001', '0002', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('05-12-2011 07:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100004, null, null, null, null, null, null, '名前_氏4', '名前_名4', 'ナマエ_シ4', 'ナマエ_メイ4', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0004', null, '080    ', '0001', '0004', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('05-12-2011 07:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100005, null, null, null, null, null, null, '名前_氏5', '名前_名5', 'ナマエ_シ5', 'ナマエ_メイ5', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0005', null, '080    ', '0001', '0005', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('03-12-2011 09:20:10', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100006, null, null, null, null, null, null, '名前_氏6', '名前_名6', 'ナマエ_シ6', 'ナマエ_メイ6', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0006', null, '080    ', '0001', '0006', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('03-12-2011 09:20:10', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100007, null, null, null, null, null, null, '名前_氏7', '名前_名7', 'ナマエ_シ7', 'ナマエ_メイ7', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0007', null, '080    ', '0001', '0007', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('03-12-2011 09:20:10', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100008, null, null, null, null, null, null, '名前_氏8', '名前_名8', 'ナマエ_シ8', 'ナマエ_メイ8', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0008', null, '080    ', '0001', '0007', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('03-12-2011 09:20:10', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100009, null, null, null, null, null, null, '名前_氏9', '名前_名9', 'ナマエ_シ9', 'ナマエ_メイ9', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0009', null, '080    ', '0001', '0009', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('03-12-2011 09:20:10', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_NAME_KANJI, UAI_DAIHYO_NAME_KANA, UAI_DAIRI_NAME_KANJI, UAI_DAIRI_NAME_KANA, UAI_ZIP_CODE_FIRST, UAI_ZIP_CODE_LAST, UAI_ADDRESS_CODE, UAI_ADDRESS_KANJI1, UAI_SUBADDRESS_KANJI1, UAI_SUBADDRESS_KANJI2, UAI_ADDRESS_KANA1, UAI_SUBADDRESS_KANA1, UAI_SUBADDRESS_KANA2, UAI_ADDRESS_STATUS, UAI_ADDRESS_UPDATE, UAI_OCCUPATION, UAI_PHONE_LONG_DIST, UAI_PHONE_CITY_CODE, UAI_PHONE_NUMBER, UAI_PHONE_FLG, UAI_CELLULAR_NUMBER1, UAI_CELLULAR_NUMBER2, UAI_CELLULAR_NUMBER3, UAI_FAX_LONG_DIST, UAI_FAX_CITY_CODE, UAI_FAX_NUMBER, UAI_E_MAIL1, UAI_E_MAIL_KBN1, UAI_E_MAIL2, UAI_E_MAIL_KBN2, UAI_E_MAIL3, UAI_E_MAIL_KBN3, UAI_SEX_KBN, UAI_BIRTH_ERA, UAI_BIRTH_DATE, UAI_BIRTH_DAY, UAI_ALL_ACCT_CLOSE, UAI_F_RELATIONSHIP, UAI_F_RELATIONSHIP_OTHERS, UAI_F_RELATIONSHIP_FIRST_KANJI, UAI_F_RELATIONSHIP_LAST_KANJI, UAI_F_RELATIONSHIP_OCCPATION, UAI_F_RELATIONSHIP_OFFICE, UAI_F_RELATIONSHIP_EXECUTIVE, UAI_F_RELATIONSHIP_POSITION_NA, UAI_OFFICE_AFTER_KBN, UAI_OFFICE_OCCPATION, UAI_OFFICE_PRESENTATION, UAI_OFFICE_NAME, UAI_OFFICE_EXECUTIVE, UAI_OFFICE_POSITION_NAME, UAI_OFFICE_ZIP_CODE_FIRST, UAI_OFFICE_ZIP_CODE_LAST, UAI_OFFICE_ADDRESS_CODE, UAI_OFFICE_ADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI1, UAI_OFFICE_SUBADDRESS_KANJI2, UAI_OFFICE_PHONE_LONG_DIST, UAI_OFFICE_PHONE_CITY_CODE, UAI_OFFICE_PHONE_NUMBER, UAI_OFFICE_DAIHYO_KBN, UAI_OFFICE_DAIRI_KBN, UAI_INSIDER_KBN, UAI_BANK_CODE, UAI_BANK_BRANCH_CODE, UAI_BANK_KANJI, UAI_BANK_BRANCH_KANJI, UAI_BANK_DEPOSIT_CLASS, UAI_BANK_ACCOUNT, UAI_BANK_ACCOUNT_NAME, UAI_BANK_TYPE_KBN, UAI_BANK_POST_KBN, UAI_BANK_DATE, UAI_CURRENCY_CODE, UAI_QA_INVESTMENT_PLAN, UAI_QA_INVESTMENT_PLAN_OTHER, UAI_QA_FUND_CHARACTER, UAI_QA_FUND_CHARACTER_OTHER, UAI_QA_INCOME_FORM, UAI_QA_INCOME_FORM_OTHER, UAI_QA_TRADING_MOTIVE, UAI_QA_TRADING_MOTIVE_OTHER, UAI_QA_EMPLOYMENT_PERIOD, UAI_QA_EMPLOYMENT_PERIOD_OTHER, UAI_QA_ANNUAL_INCOME, UAI_QA_FINANCIAL_ASSETS, UAI_QA_INTERESTED_TRADING, UAI_QA_INTERESTED_TRADING_OTHE, UAI_EXP_STOCK_KBN, UAI_EXP_STOCK, UAI_EXP_STOCK_STATUS, UAI_EXP_DEBENTURE_KBN, UAI_EXP_DEBENTURE, UAI_EXP_DEBENTURE_STATUS, UAI_EXP_CB_KBN, UAI_EXP_CB, UAI_EXP_CB_STATUS, UAI_EXP_MARGIN_KBN, UAI_EXP_MARGIN, UAI_EXP_MARGIN_STATUS, UAI_EXP_WARRANT_KBN, UAI_EXP_WARRANT, UAI_EXP_WARRANT_STATUS, UAI_EXP_FUTUREOP_KBN, UAI_EXP_FUTUREOP, UAI_EXP_FUTUREOP_STATUS, UAI_EXP_SAVEDTYPEFUND_KBN, UAI_EXP_SAVEDTYPEFUND, UAI_EXP_SAVEDTYPEFUND_STATUS, UAI_EXP_OTHERFUND_KBN, UAI_EXP_OTHERFUND, UAI_EXP_OTHERFUND_STATUS, UAI_EXP_FOREIGN_KBN, UAI_EXP_FOREIGN, UAI_EXP_FOREIGN_STATUS, UAI_EXP_OTHER_NAME, UAI_EXP_OTHER_KBN, UAI_EXP_OTHER, UAI_EXP_OTHER_STATUS, UAI_CORP_CAPITAL, UAI_CORP_ORGANIZATION_KBN1, UAI_CORP_ORGANIZATION_KBN2, UAI_CORP_SETTLEMENT_TERM1, UAI_CORP_SETTLEMENT_TERM2, UAI_CORP_PROCEDURE_KBN, UAI_CORP_BANK_KBN, UAI_CORP_ADDRESS_KANJI1, UAI_CORP_ADDRESS_KANJI2, UAI_CORP_ADDRESS_KANJI3, UAI_CORP_ADDRESS_KANJI4, UAI_CORP_ADDRESS_KANA1, UAI_CORP_ADDRESS_KANA2, UAI_CORP_ADDRESS_KANA3, UAI_CORP_ADDRESS_KANA4, UAI_ACCT_STATUS, UAI_ACCT_CLASS_FLG1, UAI_ACCT_CLASS_FLG2, UAI_OPEN_ACCT_DATE, UAI_SPECIFIC_KBN, UAI_SPECIFIC_START_DATE, UAI_SPECIFIC_STOP_DATE, UAI_SPECIFIC_M_KBN, UAI_UPDATE, UAI_NATIONALITY, UAI_GREENCARD_HOLD, UAI_US_RESIDENT, UAI_RESIDENT_CODE, UAI_NON_RESIDENT, UAI_NAIGAI_CORP_KBN, UAI_QI_CTGRY_BUNRUI1, UAI_QI_CTGRY_BUNRUI2, UAI_FD_BANK_CODE, UAI_FD_BANK_BRANCH_CODE, UAI_FD_BANK_KANJI, UAI_FD_BANK_BRANCH_KANJI, UAI_FD_BANK_DEPOSIT_CLASS, UAI_FD_BANK_ACCOUNT, UAI_FD_BANK_ACCOUNT_NAME, UAI_DM_TRANSFER_FORM, UAI_DM_BANK_CODE, UAI_DM_BANK_BRANCH_CODE, UAI_DM_BANK_KANJI, UAI_DM_BANK_BRANCH_KANJI, UAI_DM_BANK_DEPOSIT_CLASS, UAI_DM_BANK_ACCOUNT, UAI_DM_BANK_ACCOUNT_NAME, UAI_MEMBER_ACCOUNT_NO, UAI_MEMBER_ACCOUNT_CODE, UAI_OFFICE_CODE, UAI_F_RELATION_BIRTH_ERA, UAI_F_RELATION_BIRTH_DATE, UAI_F_RELATION_BIRTH_DAY, UAI_F_RELATION_OFFICE_CODE, UAI_F_RELATION_OFFICE_PRESENT, UAI_PREFECTURE_CODE, UAI_SPECIFIC_DIVIDEND_START_DT, UAI_SPECIFIC_DIVIDEND_END_DT, UAI_INTEREST_GET_KBN, UAI_INTEREST_COUNTRY_KBN, UAI_INTEREST_GOODS_KBN, UAI_INTEREST_GOODS_STS1, UAI_INTEREST_GOODS_STS2, UAI_INTEREST_COMPANY_CODE, UAI_INTEREST_RIGHT_KBN, UAI_INTEREST_OAN_KBN, UAI_INTEREST_FREQUENCY, UAI_INTEREST_GOU1, UAI_INTEREST_GOU2, UAI_INTEREST_COUNTRY_CODE, UAI_DISTRIBUTION_GET_KBN, UAI_DISTRIBUTION_COUNTRY_KBN, UAI_DISTRIBUTION_GOODS_KBN, UAI_DISTRIBUTION_GOODS_STS1, UAI_DISTRIBUTION_GOODS_STS2, UAI_DISTRIBUTION_COMPANY_CODE, UAI_DISTRIBUTION_RIGHT_KBN, UAI_DISTRIBUTION_OAN_KBN, UAI_DISTRIBUTION_FREQUENCY, UAI_DISTRIBUTION_GOU1, UAI_DISTRIBUTION_GOU2, UAI_DISTRIBUTION_COUNTRY_CODE, UAI_ZEI_KBN_KOKUNAI, UAI_ZEI_KBN_GAIKABU, UAI_ZEI_KBN_GAISAI, UAI_RISK_KBN_KABU, UAI_RISK_KBN_SAI, UAI_RISK_KBN_TENSHA, UAI_RISK_KBN_GAISHO, UAI_MARUYU_TEKIKAKUSHA_KBN, UAI_TOKUYU_TEKIKAKUSHA_KBN)
values ('001', 100010, null, null, null, null, null, null, '名前_氏10', '名前_名10', 'ナマエ_シ10', 'ナマエ_メイ10', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '03     ', '0001', '0010', null, '080    ', '0001', '0010', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_date('03-12-2011 09:20:10', 'dd-mm-yyyy hh24:mi:ss'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, ' ', ' ');
insert into USER_ATTRBUTE_INFO_2 (UAI_BUTEN_CODE, UAI_ACCOUNT_NUMBER, UAI_ACCT_DEL_FLG, UAI_DEALER_NUMBER, UAI_STAR_USER_CODE, UAI_STAR_ACCOUNT, UAI_INTERNET_KBN, UAI_CORPORATION_KBN, UAI_FAMILY_NAME_KANJI, UAI_NAME_KANJI, UAI_FAMILY_NAME_KANA, UAI_NAME_KANA, UAI_CORPORATION_NAME_KANJI, UAI_CORPORATION_NAME_KANA, UAI_DAIHYO_N

-- Create table
create table USER_ATTRBUTE_INFO_2
(
  UAI_BUTEN_CODE                 CHAR(3) not null,
  UAI_ACCOUNT_NUMBER             NUMBER(6) not null,
  UAI_ACCT_DEL_FLG               CHAR(1),
  UAI_DEALER_NUMBER              VARCHAR2(6),
  UAI_STAR_USER_CODE             NUMBER(4),
  UAI_STAR_ACCOUNT               NUMBER(11),
  UAI_INTERNET_KBN               CHAR(1),
  UAI_CORPORATION_KBN            CHAR(1),
  UAI_FAMILY_NAME_KANJI          VARCHAR2(36),
  UAI_NAME_KANJI                 VARCHAR2(36),
  UAI_FAMILY_NAME_KANA           VARCHAR2(36),
  UAI_NAME_KANA                  VARCHAR2(36),
  UAI_CORPORATION_NAME_KANJI     VARCHAR2(72),
  UAI_CORPORATION_NAME_KANA      VARCHAR2(60),
  UAI_DAIHYO_NAME_KANJI          VARCHAR2(36),
  UAI_DAIHYO_NAME_KANA           VARCHAR2(54),
  UAI_DAIRI_NAME_KANJI           VARCHAR2(36),
  UAI_DAIRI_NAME_KANA            VARCHAR2(54),
  UAI_ZIP_CODE_FIRST             CHAR(3),
  UAI_ZIP_CODE_LAST              CHAR(4),
  UAI_ADDRESS_CODE               CHAR(10),
  UAI_ADDRESS_KANJI1             VARCHAR2(92),
  UAI_SUBADDRESS_KANJI1          VARCHAR2(40),
  UAI_SUBADDRESS_KANJI2          VARCHAR2(40),
  UAI_ADDRESS_KANA1              VARCHAR2(152),
  UAI_SUBADDRESS_KANA1           VARCHAR2(40),
  UAI_SUBADDRESS_KANA2           VARCHAR2(40),
  UAI_ADDRESS_STATUS             CHAR(1),
  UAI_ADDRESS_UPDATE             CHAR(8),
  UAI_OCCUPATION                 CHAR(2),
  UAI_PHONE_LONG_DIST            CHAR(7),
  UAI_PHONE_CITY_CODE            CHAR(4),
  UAI_PHONE_NUMBER               CHAR(4),
  UAI_PHONE_FLG                  CHAR(1),
  UAI_CELLULAR_NUMBER1           CHAR(7),
  UAI_CELLULAR_NUMBER2           CHAR(4),
  UAI_CELLULAR_NUMBER3           CHAR(4),
  UAI_FAX_LONG_DIST              CHAR(7),
  UAI_FAX_CITY_CODE              CHAR(4),
  UAI_FAX_NUMBER                 CHAR(4),
  UAI_E_MAIL1                    VARCHAR2(40),
  UAI_E_MAIL_KBN1                CHAR(1),
  UAI_E_MAIL2                    VARCHAR2(40),
  UAI_E_MAIL_KBN2                CHAR(1),
  UAI_E_MAIL3                    VARCHAR2(40),
  UAI_E_MAIL_KBN3                CHAR(1),
  UAI_SEX_KBN                    CHAR(1),
  UAI_BIRTH_ERA                  CHAR(1),
  UAI_BIRTH_DATE                 CHAR(6),
  UAI_BIRTH_DAY                  CHAR(8),
  UAI_ALL_ACCT_CLOSE             CHAR(1),
  UAI_F_RELATIONSHIP             CHAR(1),
  UAI_F_RELATIONSHIP_OTHERS      VARCHAR2(20),
  UAI_F_RELATIONSHIP_FIRST_KANJI VARCHAR2(36),
  UAI_F_RELATIONSHIP_LAST_KANJI  VARCHAR2(36),
  UAI_F_RELATIONSHIP_OCCPATION   CHAR(2),
  UAI_F_RELATIONSHIP_OFFICE      VARCHAR2(40),
  UAI_F_RELATIONSHIP_EXECUTIVE   VARCHAR2(40),
  UAI_F_RELATIONSHIP_POSITION_NA VARCHAR2(40),
  UAI_OFFICE_AFTER_KBN           CHAR(2),
  UAI_OFFICE_OCCPATION           VARCHAR2(20),
  UAI_OFFICE_PRESENTATION        CHAR(1),
  UAI_OFFICE_NAME                VARCHAR2(40),
  UAI_OFFICE_EXECUTIVE           VARCHAR2(40),
  UAI_OFFICE_POSITION_NAME       VARCHAR2(40),
  UAI_OFFICE_ZIP_CODE_FIRST      CHAR(3),
  UAI_OFFICE_ZIP_CODE_LAST       CHAR(4),
  UAI_OFFICE_ADDRESS_CODE        CHAR(10),
  UAI_OFFICE_ADDRESS_KANJI1      VARCHAR2(92),
  UAI_OFFICE_SUBADDRESS_KANJI1   VARCHAR2(40),
  UAI_OFFICE_SUBADDRESS_KANJI2   VARCHAR2(40),
  UAI_OFFICE_PHONE_LONG_DIST     CHAR(7),
  UAI_OFFICE_PHONE_CITY_CODE     CHAR(4),
  UAI_OFFICE_PHONE_NUMBER        CHAR(4),
  UAI_OFFICE_DAIHYO_KBN          CHAR(2),
  UAI_OFFICE_DAIRI_KBN           CHAR(2),
  UAI_INSIDER_KBN                CHAR(1),
  UAI_BANK_CODE                  CHAR(4),
  UAI_BANK_BRANCH_CODE           CHAR(3),
  UAI_BANK_KANJI                 VARCHAR2(256),
  UAI_BANK_BRANCH_KANJI          VARCHAR2(256),
  UAI_BANK_DEPOSIT_CLASS         CHAR(1),
  UAI_BANK_ACCOUNT               CHAR(7),
  UAI_BANK_ACCOUNT_NAME          VARCHAR2(60),
  UAI_BANK_TYPE_KBN              CHAR(1),
  UAI_BANK_POST_KBN              CHAR(1),
  UAI_BANK_DATE                  CHAR(8),
  UAI_CURRENCY_CODE              CHAR(3),
  UAI_QA_INVESTMENT_PLAN         CHAR(2),
  UAI_QA_INVESTMENT_PLAN_OTHER   VARCHAR2(20),
  UAI_QA_FUND_CHARACTER          CHAR(2),
  UAI_QA_FUND_CHARACTER_OTHER    VARCHAR2(20),
  UAI_QA_INCOME_FORM             CHAR(2),
  UAI_QA_INCOME_FORM_OTHER       VARCHAR2(20),
  UAI_QA_TRADING_MOTIVE          CHAR(2),
  UAI_QA_TRADING_MOTIVE_OTHER    VARCHAR2(20),
  UAI_QA_EMPLOYMENT_PERIOD       CHAR(2),
  UAI_QA_EMPLOYMENT_PERIOD_OTHER VARCHAR2(20),
  UAI_QA_ANNUAL_INCOME           CHAR(2),
  UAI_QA_FINANCIAL_ASSETS        CHAR(2),
  UAI_QA_INTERESTED_TRADING      CHAR(2),
  UAI_QA_INTERESTED_TRADING_OTHE VARCHAR2(40),
  UAI_EXP_STOCK_KBN              CHAR(1),
  UAI_EXP_STOCK                  CHAR(2),
  UAI_EXP_STOCK_STATUS           CHAR(1),
  UAI_EXP_DEBENTURE_KBN          CHAR(1),
  UAI_EXP_DEBENTURE              CHAR(2),
  UAI_EXP_DEBENTURE_STATUS       CHAR(1),
  UAI_EXP_CB_KBN                 CHAR(1),
  UAI_EXP_CB                     CHAR(2),
  UAI_EXP_CB_STATUS              CHAR(1),
  UAI_EXP_MARGIN_KBN             CHAR(1),
  UAI_EXP_MARGIN                 CHAR(2),
  UAI_EXP_MARGIN_STATUS          CHAR(1),
  UAI_EXP_WARRANT_KBN            CHAR(1),
  UAI_EXP_WARRANT                CHAR(2),
  UAI_EXP_WARRANT_STATUS         CHAR(1),
  UAI_EXP_FUTUREOP_KBN           CHAR(1),
  UAI_EXP_FUTUREOP               CHAR(2),
  UAI_EXP_FUTUREOP_STATUS        CHAR(1),
  UAI_EXP_SAVEDTYPEFUND_KBN      CHAR(1),
  UAI_EXP_SAVEDTYPEFUND          CHAR(2),
  UAI_EXP_SAVEDTYPEFUND_STATUS   CHAR(1),
  UAI_EXP_OTHERFUND_KBN          CHAR(1),
  UAI_EXP_OTHERFUND              CHAR(2),
  UAI_EXP_OTHERFUND_STATUS       CHAR(1),
  UAI_EXP_FOREIGN_KBN            CHAR(1),
  UAI_EXP_FOREIGN                CHAR(2),
  UAI_EXP_FOREIGN_STATUS         CHAR(1),
  UAI_EXP_OTHER_NAME             VARCHAR2(20),
  UAI_EXP_OTHER_KBN              CHAR(1),
  UAI_EXP_OTHER                  CHAR(2),
  UAI_EXP_OTHER_STATUS           CHAR(1),
  UAI_CORP_CAPITAL               NUMBER(11),
  UAI_CORP_ORGANIZATION_KBN1     VARCHAR2(1),
  UAI_CORP_ORGANIZATION_KBN2     VARCHAR2(1),
  UAI_CORP_SETTLEMENT_TERM1      VARCHAR2(4),
  UAI_CORP_SETTLEMENT_TERM2      VARCHAR2(4),
  UAI_CORP_PROCEDURE_KBN         VARCHAR2(1),
  UAI_CORP_BANK_KBN              VARCHAR2(1),
  UAI_CORP_ADDRESS_KANJI1        VARCHAR2(40),
  UAI_CORP_ADDRESS_KANJI2        VARCHAR2(60),
  UAI_CORP_ADDRESS_KANJI3        VARCHAR2(40),
  UAI_CORP_ADDRESS_KANJI4        VARCHAR2(40),
  UAI_CORP_ADDRESS_KANA1         VARCHAR2(50),
  UAI_CORP_ADDRESS_KANA2         VARCHAR2(100),
  UAI_CORP_ADDRESS_KANA3         VARCHAR2(48),
  UAI_CORP_ADDRESS_KANA4         VARCHAR2(48),
  UAI_ACCT_STATUS                CHAR(1),
  UAI_ACCT_CLASS_FLG1            VARCHAR2(1),
  UAI_ACCT_CLASS_FLG2            VARCHAR2(1),
  UAI_OPEN_ACCT_DATE             VARCHAR2(8),
  UAI_SPECIFIC_KBN               CHAR(1),
  UAI_SPECIFIC_START_DATE        VARCHAR2(8),
  UAI_SPECIFIC_STOP_DATE         VARCHAR2(8),
  UAI_SPECIFIC_M_KBN             VARCHAR2(1),
  UAI_UPDATE                     DATE,
  UAI_NATIONALITY                CHAR(3),
  UAI_GREENCARD_HOLD             CHAR(1),
  UAI_US_RESIDENT                CHAR(1),
  UAI_RESIDENT_CODE              CHAR(3),
  UAI_NON_RESIDENT               CHAR(1),
  UAI_NAIGAI_CORP_KBN            CHAR(2),
  UAI_QI_CTGRY_BUNRUI1           CHAR(1),
  UAI_QI_CTGRY_BUNRUI2           CHAR(1),
  UAI_FD_BANK_CODE               CHAR(4),
  UAI_FD_BANK_BRANCH_CODE        CHAR(3),
  UAI_FD_BANK_KANJI              VARCHAR2(256),
  UAI_FD_BANK_BRANCH_KANJI       VARCHAR2(256),
  UAI_FD_BANK_DEPOSIT_CLASS      CHAR(1),
  UAI_FD_BANK_ACCOUNT            CHAR(7),
  UAI_FD_BANK_ACCOUNT_NAME       VARCHAR2(60),
  UAI_DM_TRANSFER_FORM           CHAR(1),
  UAI_DM_BANK_CODE               CHAR(4),
  UAI_DM_BANK_BRANCH_CODE        CHAR(3),
  UAI_DM_BANK_KANJI              VARCHAR2(256),
  UAI_DM_BANK_BRANCH_KANJI       VARCHAR2(256),
  UAI_DM_BANK_DEPOSIT_CLASS      CHAR(1),
  UAI_DM_BANK_ACCOUNT            CHAR(7),
  UAI_DM_BANK_ACCOUNT_NAME       VARCHAR2(76),
  UAI_MEMBER_ACCOUNT_NO          VARCHAR2(14),
  UAI_MEMBER_ACCOUNT_CODE        VARCHAR2(21),
  UAI_OFFICE_CODE                VARCHAR2(5),
  UAI_F_RELATION_BIRTH_ERA       CHAR(1),
  UAI_F_RELATION_BIRTH_DATE      CHAR(6),
  UAI_F_RELATION_BIRTH_DAY       CHAR(8),
  UAI_F_RELATION_OFFICE_CODE     VARCHAR2(5),
  UAI_F_RELATION_OFFICE_PRESENT  CHAR(1),
  UAI_PREFECTURE_CODE            CHAR(2),
  UAI_SPECIFIC_DIVIDEND_START_DT VARCHAR2(8),
  UAI_SPECIFIC_DIVIDEND_END_DT   VARCHAR2(8),
  UAI_INTEREST_GET_KBN           CHAR(1),
  UAI_INTEREST_COUNTRY_KBN       CHAR(1),
  UAI_INTEREST_GOODS_KBN         VARCHAR2(2),
  UAI_INTEREST_GOODS_STS1        CHAR(1),
  UAI_INTEREST_GOODS_STS2        CHAR(1),
  UAI_INTEREST_COMPANY_CODE      CHAR(5),
  UAI_INTEREST_RIGHT_KBN         CHAR(1),
  UAI_INTEREST_OAN_KBN           CHAR(1),
  UAI_INTEREST_FREQUENCY         CHAR(4),
  UAI_INTEREST_GOU1              CHAR(1),
  UAI_INTEREST_GOU2              CHAR(2),
  UAI_INTEREST_COUNTRY_CODE      CHAR(3),
  UAI_DISTRIBUTION_GET_KBN       CHAR(1),
  UAI_DISTRIBUTION_COUNTRY_KBN   CHAR(1),
  UAI_DISTRIBUTION_GOODS_KBN     VARCHAR2(2),
  UAI_DISTRIBUTION_GOODS_STS1    CHAR(1),
  UAI_DISTRIBUTION_GOODS_STS2    CHAR(1),
  UAI_DISTRIBUTION_COMPANY_CODE  CHAR(5),
  UAI_DISTRIBUTION_RIGHT_KBN     CHAR(1),
  UAI_DISTRIBUTION_OAN_KBN       CHAR(1),
  UAI_DISTRIBUTION_FREQUENCY     CHAR(4),
  UAI_DISTRIBUTION_GOU1          CHAR(1),
  UAI_DISTRIBUTION_GOU2          CHAR(2),
  UAI_DISTRIBUTION_COUNTRY_CODE  CHAR(3),
  UAI_ZEI_KBN_KOKUNAI            CHAR(1),
  UAI_ZEI_KBN_GAIKABU            CHAR(1),
  UAI_ZEI_KBN_GAISAI             CHAR(1),
  UAI_RISK_KBN_KABU              CHAR(1),
  UAI_RISK_KBN_SAI               CHAR(1),
  UAI_RISK_KBN_TENSHA            CHAR(1),
  UAI_RISK_KBN_GAISHO            CHAR(1),
  UAI_MARUYU_TEKIKAKUSHA_KBN     CHAR(1) default ' ',
  UAI_TOKUYU_TEKIKAKUSHA_KBN     CHAR(1) default ' '
)
tablespace ETRADE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table USER_ATTRBUTE_INFO_2
  add constraint USER_ATTBUTE_INFO_2 primary key (UAI_ACCOUNT_NUMBER, UAI_BUTEN_CODE)
  using index 
  tablespace ETRADE
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

select distinct 
UAI_BUTEN_CODE,
UAI_ACCOUNT_NUMBER,
UAI_FAMILY_NAME_KANJI,
UAI_NAME_KANJI,
UAI_FAMILY_NAME_KANA,
UAI_NAME_KANA,
UAI_PHONE_LONG_DIST,
UAI_PHONE_CITY_CODE,
UAI_PHONE_NUMBER,
UAI_CELLULAR_NUMBER1,
UAI_CELLULAR_NUMBER2,
UAI_CELLULAR_NUMBER3
from ETRADE.USER_ATTRBUTE_INFO_2 X
where 
exists 
(
select * from (
  select distinct 
    UAI_PHONE_LONG_DIST,
    UAI_PHONE_CITY_CODE,
    UAI_PHONE_NUMBER,
    UAI_CELLULAR_NUMBER1,
    UAI_CELLULAR_NUMBER2,
    UAI_CELLULAR_NUMBER3
  from ETRADE.USER_ATTRBUTE_INFO_2 A
  where 
    UAI_UPDATE > to_date('2011/12/05 06:00:00','yyyy/mm/dd hh:mi:ss')
  and (
    exists 
   (
      select  B.UAI_PHONE_LONG_DIST, B.UAI_PHONE_CITY_CODE, B.UAI_PHONE_NUMBER, count(*) from ETRADE.USER_ATTRBUTE_INFO_2 B 
      group by B.UAI_PHONE_LONG_DIST, B.UAI_PHONE_CITY_CODE, B.UAI_PHONE_NUMBER 
      having count(*) > 1 and A.UAI_PHONE_LONG_DIST = B.UAI_PHONE_LONG_DIST and A.UAI_PHONE_CITY_CODE = B.UAI_PHONE_CITY_CODE and A.UAI_PHONE_NUMBER = B.UAI_PHONE_NUMBER
   )
   or
    exists 
   (
      select  C.UAI_CELLULAR_NUMBER1, C.UAI_CELLULAR_NUMBER2, C.UAI_CELLULAR_NUMBER3, count(*) from ETRADE.USER_ATTRBUTE_INFO_2 C 
      group by C.UAI_CELLULAR_NUMBER1, C.UAI_CELLULAR_NUMBER2, C.UAI_CELLULAR_NUMBER3 
      having count(*) > 1 and A.UAI_CELLULAR_NUMBER1 = C.UAI_CELLULAR_NUMBER1 and A.UAI_CELLULAR_NUMBER2 = C.UAI_CELLULAR_NUMBER2 and A.UAI_CELLULAR_NUMBER3 = C.UAI_CELLULAR_NUMBER3
   )
  )
) Y
where 
(X.UAI_PHONE_LONG_DIST = Y.UAI_PHONE_LONG_DIST and X.UAI_PHONE_CITY_CODE = Y.UAI_PHONE_CITY_CODE and X.UAI_PHONE_NUMBER = Y.UAI_PHONE_NUMBER)
OR
(X.UAI_CELLULAR_NUMBER1 = Y.UAI_CELLULAR_NUMBER1 and X.UAI_CELLULAR_NUMBER2 = Y.UAI_CELLULAR_NUMBER2 and X.UAI_CELLULAR_NUMBER3 = Y.UAI_CELLULAR_NUMBER3)
)

SELECT t1.*
  FROM tel_info t1
 WHERE ROWID IN (SELECT rid
                   FROM (SELECT ROWID rid,
                                row_number() over(PARTITION BY tel_number ORDER BY ROWID) rnum
                           FROM tel_info t)
                  WHERE rnum > 1)