Jump to content

cade

Members
 View Profile  See their activity

  • Content Count

    845

  • Joined

  • Last visited

Posts posted by cade

  7. Posted · Report reply

    kepada korang yang ade blog...ni aku nk kasi biz skit...

    aku ada satu website and aku nk korang post mengenai website aku tuh...cam kasik review la...aku akan sediakan text ape sume tuh...and korang kena biarkan selama seminggu...

    website yg korang kena review adalah jobberies.com


    1. korang kena antar website korang and tulis gak nape korang berminat utk ini dan sumer detail diri korang cam bank akaun number ke muhaimincs [at] gmail [dot] com
    2. aku akan buat SWOT analysis kat website korang dulu
    3. aku akan reply dgn text review utk jobberies.com yg mana aku berkenan
    4. korang kena post review text tu kat blog korang...aku akan bg effective date bile utk korang post review text tuh
    5. selepas lima ari dr tarikh effektif, aku akan bank in duit ke akaun korang sebanyak RM5


    korang leh repeat step kat atas utk the next rm5

  12. Posted · Report reply

    www.tiarifa.com

    yela mmg tak meyakinkan....anda buat sekadar website tu live je adalah....tolong la jaga mutu website2 yang anda develop...dan jgn sekali2 guner template tp tk alter abis2an.....

    sila respek the real designer and developer out there...jgn amik mudah je biler buat website.....website anda umpama magazine tabloid yg murah2..

  13. Posted · Report reply

    ok ni mmg offer yg biasa...tp worth to try

    jobberies ada byk valuable space to put your ads. Kebanyakan page di jobberies comes from search engine. Jobberies is well crawled and ranked by google, yahoo and live

    so utk promotion sebelum 2009 nih,
    main page, dkt tempat slideshow tuh harganya rm150 /5hari
    category page mcm banking, health, education...harganya rm 100/5hari
    utk job-specific page...harganya rm50/5hari


    more info PM aku

    nih some query yg menunjukkan jobberies dilayan dengan baik oleh google...

    http://www.google.com.my/search?q=jurutekn...lient=firefox-a

    http://www.google.com.my/search?q=pegawai+...lient=firefox-a

  19. Posted · Report reply

    ok da tau da ape masalah nyer.....aku guner sql kat atas utk amik data dr oracle...so sql tu mesti compliance dgn oracle...datediff bkn function dari oracle..so kena tukar skit....

    CODE
    SELECT
    FD02CERT.BRNCD AS Branch,
    FD02CERT.CRLINE || '/' || FD02CERT.FCCD || '/' || FD02CERT.PRLINE || '/' || FD02CERT.PRTYP AS Product,
    FD02CERT.BRNCD || '/' || FD02CERT.MODCD || '/' || FD02CERT.ACNO || '/' || FD02CERT.CHKDGT AS Acct No,
    CF01CIF.LNAME,
    FD02CERT.CERTYR || '/' || FD02CERT.CERTNO AS CertNo,
    FD02CERT.PRCAMT AS PrincipalAmount,
    FD02CERT.ISSDT AS IssueDate,
    FD02CERT.EFFDT AS EffectiveDate,
    FD02CERT.DUEDT AS DueDate,
    to_date(FD02CERT.DUEDT, 'dd-mm-yyyy')-to_date(FD02CERT.ISSDT, 'dd-mm-yyyy') AS NODAYS,
    FD02CERT.PERIOD AS Tenor,
    FD02CERT.INTRT AS Rate,
    FD02CERT.TOTINT AS TotalInterest,
    FD02CERT.INTPAID AS IntPaid,
    FD02CERT.WHTAX AS WTax,
    FD02CERT.TOTACCR AS IntAccrued
    FROM MBSBPROD_FD02CERT
    INNER JOIN
    (CF01CIF INNER JOIN FD01MAST ON CF01CIF.CIFKEY = FD01MAST.CIFKEY)
    ON
    (FD02CERT.CHKDGT = FD01MAST.CHKDGT) AND (FD02CERT.ACNO = FD01MAST.ACNO) AND (FD02CERT.MODCD = FD01MAST.MODCD) AND (FD02CERT.BRNCD = FD01MAST.BRNCD)
    WHERE FD02CERT.EFFDT >= TO_DATE('01-01-2000', 'dd-mm-yyyy') AND FD02CERT.EFFDT <= SYSDATE
    ORDER BY FD02CERT.ISSDT, FD02CERT.EFFDT;


    ni sample sql yg aku ada...susah gak DTS nih...fuhh

  20. Posted · Report reply

    CODE
    SELECT
    BRNCD AS BRANCH, CRLINE || "/" || FCCD || "/" || PRLINE || "/" || PRTYP AS PRODUCT, BRNCD, MODCD, ACNO, CHKDGT,
    CERTYR || "/" || CERTNO AS CERTNO, PRCAMT AS PRIN_AMT, ISSDT AS ISSDT, EFFDT AS EFFDT, DUEDT AS DUEDT, CAST(DateDiff(dd, ISSDT,
    DUEDT)) AS NODAYS, PERIOD AS TENOR, INTRT AS RATE, TOTINT AS TOTINT, INTPAID AS INTPAID, WHTAX AS WTAX, TOTACCR AS INTACCR
    FROM   FD02CERT
    WHERE     (EFFDT >= TO_DATE('01/01/2000', 'DD/MM/YYYY')) OR
                          (EFFDT <= CAST(GETDATE()))
    ORDER BY ISSDT, EFFDT


    aku run ni guna DTS tp SQL ni akan amik data dari DB oracle 10g....tp aku still ada error ORA-00905: Missing keyword....

    ada sesapa yg experience camni tk?
×
×
  • Create New...