WinTail 3.4

WinTail 3.4


윈도우용 Tail 입니다. unix 운영체제에서 사용하던 것 처럼 편리하게 이용할수 있습니다.

GOOD~~

wintail_3.4.zip

간단한 Stored Procedure 예제.

Oracle Store Procedure 를 사용하게 되어서, 처음으로 SP를 사용해 보았다.
아래는 아주 간단한 예제..
예제를 쉽게 만들어서 이해 하기 아주 쉬울꺼라고 생각한다..
좀더 응용적인건 계속 추가 예정..

create table MEMBER(
  id         varchar2(12)      primary key,
  name    varchar2(10)      not null
)

insert into MEMBER values('taesuz', '조태수');

create or replace
procedure hello_proc( in_id IN VARCHAR2, out_name OUT VARCHAR2 )
is
  begin
    select name INTO out_name from MEMBER
    where id=in_id;
    dbms_output.put_line( out_name );

EXCEPTION
  WHEN NO_DATA_FOUND THEN
    out_name:='NO_DATA_FOUND';
end hello_proc;

실행:

VARIABLE name varchar2(10);
execute hello_proc('taesuz', :name);
print name;

 

결과값:

name
---
조태수

Microsoft Office for Mac SP2 Serial

   from : http://paste2.org/p/359169



    Microsoft Office 2008 for Mac
    
    NEW Serials ~ Support SP2:
    
    PCVGG-GBCF3-72PW4-GRMFK-Q7DD3
    W339P-JRCPB-XX8XD-YK49M-7DYCW
    FWCQQ-3XX2G-3CD89-4VRJK-CR4YD
    WG667-BW4JP-M8KXV-CVPQD-6J49J
    QCDK8-9P4FC-8P6D4-QC22F-TT468
    JKQK8-KKDG8-2T729-TCKY8-3XJ8Q
    GHRHF-PMKVD-VWCGF-WQTCT-CGKJY
    GK46R-PT7KB-VCHGB-QDCQV-VYTGT
    Q8WDK-VD4YV-MXTT8-KYPPC-YPYMM
    TRHH8-F6P34-DBY2Q-BMQBT-RMMJ8
    RJCW4-K4388-GMYXY-YKQWX-2BVQJ
    FM9RP-GQ6XV-H8JCB-X9BMF-H2WF8
    GW7Y6-F977W-7Y6YD-82FJG-29C4Y
    DP87B-DXX8G-24TKP-PRTPF-VBTT3
    CC9CH-DT9DP-JD6R6-XWXBD-HQP8Y
        
        
    OLD Serials (blocked by SP2):
    
    MCX6K-J8YQP-CGMTM-X3XQ8-K6KDY
    RMG8D-KP8WT-DBCDV-QVRD2-V3WQY
    QYGR3-CJWQM-9HK4T-WX32G-F7XVM
    VTJG8-94R7P-RTQVT-8CK98-79THM
    J3JT3-8J2PM-VMYD8-8WT9X-BCM7M
    XH4P8-PQ2KW-JDM9P-YW2BV-PCF3Y
    TTTCG-JRGVX-R3J29-2XRG2-GP6BB
    DV4XH-WWB2F-9BGX2-WR82D-JGWBB
    PQRFY-VCW3V-8MBF4-2H8Y8-KDBBB
    FR7YV-P38TR-83V4C-G2RXD-VTF3Y
    
  Reactivate ~ Remove/Renew Serial:
    Delete these 2 .plist files:
    ./Users/username/Library/Preferences/Microsoft/Office 2008/Microsoft Office 2008 settings.plist
    ./Applications/Microsoft Office 2008/Office/OfficePID.plist

NodLogin 10b 32/64bit

 

NOD32 업데이트를 도와주는 NodLogin 입니다.

 

 

NodLogin10b_1.zip

log4sql Query 의 대한 모든것을 보여준다.

http://log4sql.sourceforge.net/index_kr.html

개발시 쿼리 부분에 대한 것을 적나라 하게 보여준다.

필수 라이브러리라고 생각이 듬..

 

JDBC TYPE	Origin Your Driver Class	->	log4sql Driver Class
[ORACLE DRIVER CLASS]	'oracle.jdbc.drirver.OracleDriver'	->	'core.log.jdbc.driver.OracleDriver'
[MYSQL DRIVER CLASS]	'com.mysql.jdbc.Driver' or'org.gjt.mm.mysql.Driver'	->	'core.log.jdbc.driver.MysqlDriver'
[SYBASE DRIVER CLASS]	'com.sybase.jdbc2.jdbc.SybDriver'	->	'core.log.jdbc.driver.SybaseDriver'
[DB2 DRIVER CLASS]	'com.ibm.db2.jcc.DB2Driver'	->	'core.log.jdbc.driver.DB2Driver'
[INFOMIX DRIVER CLASS]	'com.informix.jdbc.IfxDriver'	->	'core.log.jdbc.driver.InfomixDriver'
[POSTGRESQL DRIVER CLASS]	'org.postgresql.Driver'	->	'core.log.jdbc.driver.PostgresqlDriver'
[MAXDB DRIVER CLASS]	'com.sap.dbtech.jdbc.DriverSapDB'	->	'core.log.jdbc.driver.MaxDBDriver'
[FRONTBASE DRIVER CLASS]	'com.frontbase.jdbc.FBJDriver'	->	'core.log.jdbc.driver.FrontBaseDriver'
[HSQL DRIVER CLASS]	'org.hsqldb.jdbcDriver'	->	'core.log.jdbc.driver.HSQLDriver'
[POINTBASE DRIVER CLASS]	'com.pointbase.jdbc.jdbcUniversalDriver'	->	'core.log.jdbc.driver.PointBaseDriver'
[MIMER DRIVER CLASS]	'com.mimer.jdbc.Driver'	->	'core.log.jdbc.driver.MimerDriver'
[PERVASIVE DRIVER CLASS]	'com.pervasive.jdbc.v2.Driver'	->	'core.log.jdbc.driver.PervasiveDriver'
[DAFFODILDB DRIVER CLASS]	'in.co.daffodil.db.jdbc.DaffodilDBDriver'	->	'core.log.jdbc.driver.DaffodiLDBDriver'
[JDATASTORE DRIVER CLASS]	'com.borland.datastore.jdbc.DataStoreDriver'	->	'core.log.jdbc.driver.JdataStoreDriver'
[CACHE DRIVER CLASS]	'com.intersys.jdbc.CacheDriver'	->	'core.log.jdbc.driver.CacheDriver'
[DERBY DRIVER CLASS]	'org.apache.derby.jdbc.ClientDriver'	->	'core.log.jdbc.driver.DerbyDriver'
[ALTIBASE DRIVER CLASS]	'Altibase.jdbc.driver.AltibaseDriver'	->	'core.log.jdbc.driver.AltibaseDriver'
[MCKOI DRIVER CLASS]	'com.mckoi.JDBCDriver'	->	'core.log.jdbc.driver.MckoiDriver'
[JSQL DRIVER CLASS]	'com.jnetdirect.jsql.JSQLDriver'	->	'core.log.jdbc.driver.JsqlDriver'
[JTURBO DRIVER CLASS]	'com.newatlanta.jturbo.driver.Driver'	->	'core.log.jdbc.driver.JturboDriver'
[JTDS DRIVER CLASS]	'net.sourceforge.jtds.jdbc.Driver'	->	'core.log.jdbc.driver.JTdsDriver'
[INTERCLIENT DRIVER CLASS]	'interbase.interclient.Driver'	->	'core.log.jdbc.driver.InterClientDriver'
[PURE JAVA DRIVER CLASS]	'org.firebirdsql.jdbc.FBDriver'	->	'core.log.jdbc.driver.PureJavaDriver'
[JDBC-ODBC DRIVER CLASS]	'sun.jdbc.odbc.JdbcOdbcDriver'	->	'core.log.jdbc.driver.JdbcOdbcDriver'
[MSSQL 2000 DRIVER CLASS]	'com.microsoft.jdbc.sqlserver.SQLServerDriver'	->	'core.log.jdbc.driver.MssqlDriver'
[MSSQL 2005 DRIVER CLASS]	'com.microsoft.sqlserver.jdbc.SQLServerDriver'	->	'core.log.jdbc.driver.Mssql2005Driver'

Java Properties 사용.

 

Java 설정 파일로 많이 쓰이는 Properties 사용법

 

String openProp = request.getRealPath("/taesuz/") + "/taesuz.properties";
try{
 Properties props = new Properties();
 props.load( new FileInputStream( openProp ));
 props.setProperty("type", type );

 FileOutputStream fos = new FileOutputStream( openProp );
 
 props.save(fos, "open type change");
 
 out.println( "open type change: " + type );
 
} catch (IOException ioe){
 out.println( ioe );
 
} catch (Exception e){
 out.println( e );
}