Ask Maclean

Maclean’s Oracle Database Tech Blog Archives

  • 2018年的北海道之旅

                                                                                                                 …

  • Bug 29613690 : CHILD CURSOR LEAK DUE TO BIND MISMATCH

    Child cursors are increasing due to bind mismatch. The problematic query is following.(SQL_ID=8y78t7xj7h2fk)   SELECT …   FROM    WWUJT628 a628           …           LEFT JOIN                   (SELECT DISTINCT NR_ADV_SEQ FROM WWUJT632                   WHERE NO_ISSUE_ADMIN = :B1) a632           ON                   (a628.NR_ADV_SEQ = a632.NR_ADV_SEQ)           LEFT JOIN WWUJT080 a080b           ON                   (a080b.ID_ROLE_ADMIN_M = a630.ID_ROLE_ADMIN_M_REQ_DEST)  …

  • 日语学习中

    ただいま   おかえり   なに 什么 よし 好 好的   10分、20分、30分、40分、50分、60分读： じっぷん、にじっぷん、さんじっぷん、よんじっぷんごじっぷん、ろくじっぷん   11分、12分、13分、14分、15分、16分、17分、18分、19分读： じゅういっぷん、じゅうにふん、じゅうさんぷん、じゅうよんぷん、じゅうごふん、じゅうろっぷん、じゅうななふん、じゅうはっぷん、じゅうきゅうふん  

  • Oracle flashback query failed with ORA-01555?

    if you deleted/updated data by mistake in oracle. and try to recover data from flashback query.  Your query may fail with ora-01555 error:   SQL> l 1 declare 2 cursor c is select * from testt2 as of scn 5385449; 3 begin 4 for i in c loop 5 null; 6 end loop; 7* end;…

  • goldengate ogg troubleshooting guide

    goldengate ogg troubleshooting guide   OGG_les_03-Troubleshooting_revised

  • Oracle 11.2.0.4 LINUX WINDOWS 下载

    请注意，如果你有support.oracle.com账号，那么严格从官网下载介质。如果实在没有，那么从互联网上下载介质一定要验证SHA1,避免介质被修改。   ORACLE 11.2.0.4 Windows 64bit: 链接: https://pan.baidu.com/s/1eFN0HqgHRLIg12iKZu8B2Q?pwd=7r7d 提取码: 7r7d 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset) p13390677_112040_MSWIN-x86-64_1of7.zip 1.2 GB (1327046969 bytes) SHA-256 9C6E1235D1B0EE6C36E3F82FEBDC74160BB9766900579FC7EBBFACECD6E8F4B2 SHA-1 893475AFA9C6758FB14E8269EF05F6D485445F28 p13390677_112040_MSWIN-x86-64_2of7.zip 1.1 GB (1152431908 bytes) SHA-1 6EE067D16F80061B03CFD63603B3F5E454B6152D SHA-256 6343B2EA4F47C4E85FD4DC1B5C2EA0B86294E48FAD90DE1820C3F9DF906675F3 p13390677_112040_MSWIN-x86-64_3of7.zip 735.0 MB (770723774 bytes) SHA-256 EC47CFF4D500BD357982C57D9F84F893293A3DBB79A62FC7AE66E2144BEFFF6C SHA-1 AA69BD12E01BECBD249C71F8682D75BB2FA003DB p13390677_112040_MSWIN-x86-64_4of7.zip 600.7 MB (629885092 bytes) SHA-256 10D708F6C3FA12466486BDBB3B1FB235EEEAF1AAB39B67B86C42648F8F49FB33 SHA-1 821CD458D76672DD10A3C377196C6CE52CBB1BBF p13390677_112040_MSWIN-x86-64_5of7.zip…

  • 2018年的东京迪士尼之旅

                                                         

  • 2017年12月的海南三亚之旅

               

  • 2017年11月的新加坡之旅

                                                               

  • react native css style field

      ref: https://github.com/macleanliu/learnjs/blob/master/css.ts