を読んだ。
import java.util.ArrayList;
import java.util.List;
public class ListSerch {
private List<Integer> numbers;
private int probe;
public ListSerch(int size){
numbers = new ArrayList<Integer>();
for (int i = 0; i < size; i++) {
numbers.add(i);
probe = size / 2;
}
}
//ArrayListの真ん中を取得させる。
public void search(){
numbers.contains(probe);
}
}
public class TestDriver {
public static void main(String[] args) throws Exception{
MethodsTimer tester = new MethodsTimer(ListSerch.class.getDeclaredMethods());
tester.report();
}
}
import java.lang.reflect.Method;
public class MethodsTimer {
public final Method[] methods;
private static final int MAXIMUM_SIZE = 100;
public static final int ONE_SECOND = 1000000000;
public MethodsTimer(Method[] methods){
this.methods = methods;
}
public void report() throws Exception{
for(Method each : methods){
System.out.print(String.format("%.2f\t", r.getMethodTime()));
for (int size = 1; size <= MAXIMUM_SIZE; size *=10)
{
MethodTimer r = new MethodTimer(size, each);
r.run();
System.out.print(r.getMethodTime() + "\t");
}
System.out.println();
}
}
}
import java.lang.reflect.Constructor;
import java.lang.reflect.Method;
public class MethodTimer {
private final int size;
private final Method method;
private Object instance;
private long totalTime;
private int iterations;
private long overhead;
public MethodTimer(int size, Method method) throws Exception{
this.size=size;
this.method=method;
instance = createInstance();
}
public MethodTimer(int iterations) throws Exception{
this(0,MethodTimer.Overhead.class.getMethod("nothing", new Class[0]));
this.iterations = iterations;
}
private static MethodTimer overheadTimer(int iterations) throws Exception{
return new MethodTimer(iterations);
}
private Object createInstance() throws Exception {
Constructor<?> constructor = method.getDeclaringClass().getConstructor(
new Class[] { int.class });
return constructor.newInstance(new Object[] { size });
}
double getMethodTime(){
return (double)(totalTime - overhead) / (double)iterations;
}
void run() throws Exception {
iterations = 1;
while (true) {
totalTime = computeTotalTime();
if (totalTime > MethodsTimer.ONE_SECOND)
break;
iterations *= 2;
}
overhead = overheadTimer(iterations).computeTotalTime();
}
private long computeTotalTime() throws Exception {
long start = System.nanoTime();
for (int i = 0; i < iterations; i++) {
method.invoke(instance, new Object[0]);
}
return System.nanoTime() - start;
}
public static class Overhead {
public Overhead(int size) { }
public void nothing() { }
}
}
#あ
n=1
print("hoge")
if not IS_PY3K:
execfile(file, globals, locals) #execute the script
else:
stream = open(file)
try:
encoding = None
#Get encoding!
for i in range(2):
line = stream.readline() #Should not raise an exception even if there are no more contents
#Must be a comment line
if line.strip().startswith('#'):
#Don't import re if there's no chance that there's an encoding in the line
if 'coding' in line:
import re
p = re.search(r"coding[:=]\s*([-\w.]+)", line)
if p:
encoding = p.group(1)
break
finally:
stream.close()
if not IS_PY3K:
execfile(file, globals, locals) #execute the script
else:
#stream = open(file) #2010.10.6 cahnge
stream = open(file, encoding='utf-8')
try:
#encoding = None #2010.10.6 cahnge
encoding='utf-8'
#Get encoding!
for i in range(2):
line = stream.readline() #Should not raise an exception even if there are no more contents
#Must be a comment line
if line.strip().startswith('#'):
#Don't import re if there's no chance that there's an encoding in the line
if 'coding' in line:
import re
p = re.search(r"coding[:=]\s*([-\w.]+)", line)
if p:
encoding = p.group(1)
break
finally:
stream.close()
if encoding:
stream = open(file, encoding=encoding)
else:
stream = open(file)
try:
contents = stream.read()
finally:
stream.close()
良
内容:"create or replace function get_key (p_col in lookup_table.col1%type) return lookup_table.col2%type as v_result lookup_table.col2%type; begin select col2 into v_result from lookup_table where col1 = p_col; return v_result; end get_key; / Then you can use that function in your SQL*Loader control file, like so: Code: [Select all] [Show/ hide]load data infile 'data.txt' into table dwh_table fields terminated by ',' trailing nullcols (col1, col2 "get_key (:col1)")"
- OraFAQ Forum: Server Utilities » SQL Loader & lookup tables issue （Google サイドウィキで表示）
