Saturday, June 6, 2009

sqlldr memo

call
export NLS_LANG=American_America.AL32UTF8
sqlldr.exe dolmen/dolmen control=lts_in_test.ctr data=lts_in_test.csv log=asd.log bad=asd.bad
control file example
LOAD INTO TABLE LOCAL_TELE_STATION_IN replace FIELDS TERMINATED ',' (
    ID_STATION_IN                      integer,
    DESCRIPTION                        CHAR(1024),
    ADDRESS_NUMBER                     CHAR(255),
    POSTAL_CODE                        CHAR(20),
    MUNICIPALITY                       CHAR(40),
    PROVINCE                           CHAR(4)
)

Tuesday, June 2, 2009

rotate a video

Happens to record a video with camere rotated, to rotate a video using mencoder:

mencoder -oac copy -ovc xvid -xvidencopts pass=2:bitrate=100 -vf rotate=2 -o