Thursday, August 18, 2011

Connecting to Oracle 10G, when you have Oracle 11G Installed in your PC





When you want to connect to Oracle 10G, 
when you have Oracle 11G already Installed in your PC... 


you will get something like whut the hell i cannot connect to 10G now?


the trick is...


the Environment Path in windows will set the pirority to 11G so your 10G will be left out and get rotten suck.


to solve it... just alter the environment 


and set the path again so 10G is the first pirority :


C:\oracle\product\10.2.0\client_1\bin;c:\app\product\11.2.0\dbhome_1\bin;


how about that? now u can logon and do import export your DMP files again...



Wednesday, August 10, 2011

oracle timestamp tak sama dengan sysdate








jika anda select CURRENT_TIMESTAMP  dan tak sama dengan SYSDATE, maknanya setting time zone tak betul.


untuk betulkan sila run berikut ( kl adalah minus 8, bukan plus 8 la ok dalam oracle nie ):
    
    ALTER SESSION SET TIME_ZONE = '-8:0';


dah select semula disini :
    

    SELECT CURRENT_TIMESTAMP, SYSTIMESTAMP, sysdate FROM DUAL;    


haaa... kan dah sama... terbaekk kata tok aba

Wednesday, August 3, 2011

Oracle Wrapping / Obfuscating






The advantages of obfuscating, or hiding, the source code of PL/SQL units with the wrap utility or wrap subprograms of the DBMS_DDL package are:
  • It is difficult for other developers to misuse your application, or business competitors to see your algorithms.
  • Your source code is not visible through the USER_SOURCEALL_SOURCE, or DBA_SOURCE data dictionary views.
  • SQL*Plus can process the obfuscated source files.
  • The Import and Export utilities accept wrapped files. You can back up or move wrapped procedures.
Untuk Hide Script Dari Orang Lain @ Kedekut Sikit @ Kasi Secure Sikit, Anda Hanya Perlu Wrappingkan Coding Anda.


sila ikut sebijik contoh dibawah :


coding asal :
=============================================
CREATE OR REPLACE PACKAGE HAIRE.PKG_1
AS
   FUNCTION encrypt (p_plainText VARCHAR2) RETURN RAW DETERMINISTIC;
END;
/


CREATE OR REPLACE PACKAGE BODY HAIRE.PKG_1
AS
     encryption_key    PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_DES; 
     encryption_type     RAW (32) := UTL_RAW.cast_to_raw('KeySulitTakBolehShare10012');
     


     FUNCTION encrypt (p_plainText VARCHAR2) RETURN RAW DETERMINISTIC
     IS
        encrypted_raw      RAW (2000);
     BEGIN
        encrypted_raw := DBMS_CRYPTO.ENCRYPT
        (
           src => UTL_RAW.CAST_TO_RAW (p_plainText),
           typ => encryption_key,
           key => encryption_type
        );
       RETURN encrypted_raw;
     END encrypt;
END;
/


script untuk encrypt :
=============================================
 DECLARE
  v_procedure VARCHAR2(32767);
  BEGIN
   v_procedure :=  'CREATE OR REPLACE PACKAGE BODY HAIRE.PKG_1 AS      
     encryption_key    PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_DES; 
     encryption_type     RAW (32) := UTL_RAW.cast_to_raw(''KeySulitTakBolehShare10012''); 
     FUNCTION encrypt (p_plainText VARCHAR2) RETURN RAW DETERMINISTIC     IS        encrypted_raw      RAW (2000);     BEGIN
        encrypted_raw := DBMS_CRYPTO.ENCRYPT  ( src => UTL_RAW.CAST_TO_RAW (p_plainText),  typ => encryption_key,  key => encryption_type  );  RETURN encrypted_raw;
     END encrypt;'
    || 'END;';


    SYS.DBMS_DDL.CREATE_WRAPPED(v_procedure);

  END;
  /


coding yang di encrypt encrypt :
=============================================
CREATE OR REPLACE PACKAGE BODY HAIRE.PKG_1 wrapped 
a000000
1f
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
220 17d
wzuxYssdavttxYHqXzhV1MDQgswEF8wg3nMr9zbyi+BNA9as/xHmM3ux5NLTYvQIt8Z8+NyaDtluG
1861gIhWSOVDZ0DGpRkTB5TALwDmeCZEIrwZNTBaHsifISVip9KRFa odmiUbGpP+1R
4B+4DSPlHnsnm/xLsYtLtXAkAKnhNLe4P2gTMoZTasaNB3jqFIeM09m/50NlaoGkQ8eMP14eUoP
ATTwMhJOsl3qGAo=
/

Friday, July 22, 2011

Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item





Kalau korang dpt error yang fening dan hampeh macam ni...

"Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item."





Senang aje... follow solution ini...


On the Windows 2003 server, go to add/remove windows components, then uninstall the Internet Explorer Enhanced Security component.

Thursday, June 23, 2011

Bagaimana nak panggil Satu Query Dari Coldfusion ke Oracle

contoh nak panggil package procedure dari oracle


contoh ini akan tarik query... so processing adalah dari database server bukan web server... jimattttttt


create or replace 
package test_sel_query
as
    type cursorType 
     is ref cursor;

    function test_func 
     return cursorType;

end;
/

create or replace 
package body test_sel_query
as

   function test_func 
    return cursorType
   as
      cursor_v   cursorType;
   begin
        /* 
        Put whatever SQL and/or processing here.
        I use the Oracle dictionary table 
        all_objects as an example.
        */
       open cursor_v 
         for 
         select object_id, 
                object_type, 
                  object_name 
         from all_objects 
         where rownum <= 15;

       return cursor_v;

   end test_func;

end test_sel_query;
/


Terbaekk... kata tok aba...


<cfstoredproc 
 procedure="test_pkg.test_sel_query" 
 datasource="yourDSN">
    <cfprocresult name="q">
</cfstoredproc> 
<cfdump var="#q#">

Monday, May 23, 2011

Dell Precision T3500 Suck!




Dell Precision T3500 Suck Big Time...


Baru pakai kejap aje dan kong hardisk... bodoh punya dell, lain kali jangan pakai westerndigital@kaput punya harddisk la...


dalam 3 bulan nie... dah 2 workstation jenis ni kong hardisk... nak salahkan siapa? 


nasib baik aku ada buat backup sikit sikit... kalau tak... menangis tak berlaku la nasibnya...


moralnya... jangan beli pc dell laa... bodoh punya pc yang menyusahkan orang... stick with HP... terbaekkkkkk kata tok aba....

Friday, May 6, 2011

ORACLE - DATE WHERE FILTER





Dalam oracle ni, senang aje kalau nak filter by date secara manual... 


contoh filter secara manual dengan tarikh dan masa dimasukkan ikut suka hati sendiri aje.




SELECT  COUNT(DISTINCT AUD_LOGINID) AS TOTAL
FROM   AUDIT_LOGIN
WHERE     DATE_LOGIN > TO_TIMESTAMP('24/03/2011 01:01:01', 'DD/MM/YYYY HH24:MI:SS')



contoh filter  kalau nak ambik data yang semalam punya

SELECT  COUNT(DISTINCT AUD_LOGINID) AS TOTAL
FROM   AUDIT_LOGIN
WHERE     DATE_LOGIN > sysdate - 1






haaa... kan senang aje....

Friday, April 1, 2011

Coldfusion 9 Free Version - Percuma aje tak kena bayar pun....



Gambar ni takde kena mengena pun laa....



Buat mereka mereka yang sukakan benda benda free... 

Coldfusion sekarang boleh dipakai secara percuma... untuk pelajar pelajar , staf dan yang terlibat dalam Universiti dan sewaktu dengannya...

Kalau nak dapat percuma, kena la buat kerja sikit... scan kad matrix atau kad staf... dan kemudian hantar...
tunggu aje la untuk dptkan licence coldfusion...


I don't hate PHP, but I love COLDFUSION more.... Coldfusion, Retreat! Hell!!!

----------------------------------------------------------------------------------


Adobe ColdFusion 9 for Education is available for free to educational customers to use for learning purposes only and not for production purposes. This includes all qualified students, faculty and staff of eligible education institutions. 
Language (CFML) full scripting language which syntx resembles HTML closely, but comparable to the scripting components of ASP, JSP, and PHP in purpose and features.

Adobe ColdFusion has been commonly used to create data-drive web sites or intranets, and can also be used to generate remove services such as SOAP web servers or Flash remoting. Adobe ColdFusion 9 is the latest version of Adobe ColdFusion, which introduces lots of new features. The top features of Adobe ColdFusion 9 include:
  • Office file interoperability.
  • Broader set of Ajax controls that leverage the new Ext JS 3.0 library via CFML tags and attributes, including mapping, multimedia player, multifile upload, accordion navigation, progress indicator, confirmations, alerts, buttons, and sliders.
  • Adobe AIR local/remote database synchronization.
  • Faster Flash Remoting to increase application performance.
  • Leverage the power of ColdFusion enterprise services via AMF or SOAP without writing a single line of CFML.
  • Instance-based licensing.
  • Object-relational mapping.
  • Adding images to PDF files directly within the CFPDF tag.
  • Brand and protect files by easily adding watermarks, headers, and footers to PDF files.
  • Simultaneously performing administrative tasks across multiple servers from one central console – Server Manager.
  • User-based Administrator and RDS access.
  • Server Monitor.
Adobe ColdFusion is an expensive piece of software, where Enterprise edition costs US$7,499 for new license or US$3,750 for upgrade license, and Standard edition costs US$1,299 for new purchase or US$649 for upgrading from previous version of Adobe ColdFusion.
To promote Adobe ColdFusion, Adobe is giving away free license of Adobe ColdFusion 9 for Education (and also future versions) to eligible people at academic or educational institutions, where students, faculty and staff of eligible education institutions are qualified. Adobe ColdFusion 9 for Education is meant to use for learning purposes only and not for production purposes.
Proof of eligibility is required to receive the free copy of Adobe ColdFusion 9 Enterprise Edition for Education, which can be one of the any following:
  1. student ID showing current enrollment, or
  2. faculty ID showing current employment, or
  3. non-faculty employee ID showing current employment, or
  4. a letter on an educational institution letterhead stating that you are either a current student, a current faculty member or a current non-faculty employee of the institution.
If you satisfy the requirement, just head to the registration site athttps://freeriatools.adobe.com/coldfusion/ to register and receive the free serial number to activate the product. Customers can download trial version of Adobe ColdFusion 9 and use the serial key code to unlock and activate the full version ColdFusion.

Monday, March 21, 2011

Battle: Los Angeles --- Da Bomb!








Aku dah pi tgk crita nie... memang power la crita... action aje la memanjang... dari sepuluh bintang, aku kasik semua bintang laa... sebab suka hati aku la nak kasik berapa kan....

yang best...
1. Tembak sana dan sini... dan kaboom...
2.  Tembak sana dan sini... dan mati plak marines... ( ingatkan US marines ni tak leh mati.. rupanya mati gak )

3.  Tembak sana dan sini... dan mati la ko alien...
4. Alien pulak tembak kat heroes... tak kena langsung ( alien tak pergi belajar menembak lagi.. baru habis sekolah memandu )

overall... memang best la crita ni... bagi peminat sains fiksyen dengan banyak aksi die! die! alien die!...
Now let us kill some ET's... hooo rahhh!!!





Friday, February 25, 2011

SAMAN EKOR - aku dah bayar


Hari ini aku berjaya bayar saman aku pakai myeg... saman tahun 2007. ada laa dapat diskaun 50%.  so bayar ajela ok... jangan menyusahkan diri masa nak buat road tax nanti sudah laa.... banyak gak tu rm 150... boleh beli lampin anak aku dalam 5 beg laa...

tapi secara amnya... aku tak halal kan dunia akhirat laa... korang nak kata apa lantak la...  duit aku yang kopak... binawe betul laaa...







Monday, February 14, 2011

Wednesday, February 2, 2011

ColdFusion 8 Tips - Supported Image Formats


The following article is a compilation of Ben Forta's blog entries from his ColdFusion 8 usergroup tour.
ColdFusion 8-Supported Image Formats
Lots of you have been asking about ColdFusion 8's planned <CFIMAGE> tag, wanting to know what image formats will be supported (many of you are asking about GIF and PNG specifically). As long as you keep in mind that ColdFusion 8 is a work-in-progress and that features and specs can change...
ColdFusion 8 has two new functions: GetReadableImageFormats() returns a list of the supported readable image formats, and GetWriteableImageFormats() returns a list of supported writable formats. The following code snippet shows all supported formats:
<cfset r=GetReadableImageFormats()>
<cfset w=GetWriteableImageFormats()>

<cfoutput>
Readable (#ListLen(r)#): #r#<br>
Writeable (#ListLen(w)#): #w#<br>
</cfoutput>
Running this code (in Beta 2, remember, this can/may still change) displays the following:
Readable (15): BMP,GIF,JFIF,JPEG,JPEG 2000,JPEG-LOSSLESS,JPEG-LS,JPEG2000,JPG,PNG,PNM,RAW,TIF,TIFF,WBMP
Writeable (15): BMP,GIF,JFIF,JPEG,JPEG 2000,JPEG-LOSSLESS,JPEG-LS,JPEG2000,JPG,PNG,PNM,RAW,TIF,TIFF,WBMP
And, yes, GIF and PNG are both supported (both read and write).
Getting Started with the ColdFusion Debugger
After a seven-year hiatus, ColdFusion once again has an interactive debugger, and this time it's built on top of Eclipse (and uses the same debugging interface as Flex Builder and other Eclipse plug-ins). If you are interested in taking the debugger for a spin, here's what you need to know to get started:

Why developers should check out ColdFusion 8



Why developers should check out ColdFusion 8

By Brian Kotek
Source From TechRepublic
October 26, 2007, 9:11 AM PDT
Takeaway: Brian Kotek says existing ColdFusion users will find a lot to be happy about in version 8. He urges developers to try the application server and give it an honest look.
Adobe ColdFusion 8 (CF 8) is a force to be reckoned with in the application server space. I’ve been using ColdFusion for 10 years, and I haven’t seen the community this excited about a new release in a long time. The recent release is by far the most compelling version since they moved to the Java platform — and possibly even the most compelling version ever.
There is a long list of new features and enhancements in CF 8, but in this article, I’m just going to focus on five of my favorites.

Server Monitor

The Developer and Enterprise Editions of CF 8 offer the highly anticipated Server Monitor feature. This might be the single biggest addition to ColdFusion, since it blows away anything I’ve seen on any other server platform.
Using the beautiful Flex-based Server Monitor interface, you can now watch requests move through a live server. You can see exactly how much memory a session or an application is using, what the template cache is doing, and which threads are taking too long to run.
You can also drill down into live requests and see which individual tags or method calls are slowing things down. It’s immensely powerful to watch the monitor and immediately tune your code in response. Is a query getting executed a lot? Cache it! Is a tag or function causing a bottleneck? Now you know exactly what line of code to optimize. Want to write your own code that runs in response to a hung thread, low JVM memory, or anything else? The monitor API will let you.

Exchange integration

It’s incredibly easy to integrate CF 8 with Microsoft Exchange. With a few lines of code, you can add events to Exchange calendars; add and remove attendees; manipulate tasks, contacts, lists, and more.
Love it or hate it, Exchange is such a staple for many IT departments that the ability to interact with it — or even build your own full-blown interface to your Exchange data — is a big boon to a lot of businesses that use ColdFusion.

AJAX capabilities

Another hugely popular addition in CF 8 is a large set of built-in AJAX functionality. By using simple tags or JavaScript functions, ColdFusion will handle all the chores for creating great AJAX-based applications. CF 8 makes these things a snap: autosuggest, related select boxes, dynamic content updates, and EXT-based datagrids.
One of the coolest features is the ability to create JavaScript proxies for server-side ColdFusion Components (CFCs). You can call a method on the proxy, and under the hood it will make a call to the corresponding method on the CFC. All the work of translating data to and from JavaScript Object Notation, converting ColdFusion datatypes into JavaScript types, and protecting against hack attempts is all handled for you by the ColdFusion server.
There’s even an excellent AJAX debugging window that shows everything that is going on. This probably has the biggest “wow” factor for the new release, since developers of any skill level can whip up a jaw-dropping AJAX application in minutes.

Image manipulation

CF 8 takes image manipulation to a new level. Adobe added more than 50 new tags and functions for dealing with images. The capabilities include simple things like resizing, getting image sizes, and converting images, as well as virtually any image-based task you can imagine. This includes drawing, adding text, and adding effects such as blurring, antialiasing, and rotating.

Performance

The best improvement in CF 8 is that it’s really fast. The development team really outdid themselves in this area. Depending on the application, it can be up to 10 times faster than CF 6 or CF 7. Some processes, like CFC instantiation, are an eye-popping 23 times faster than CF 7. So even if you upgrade to CF 8 and don’t use any new features, your application could easily triple or quadruple its performance on the same hardware. This is quite a compelling reason to upgrade.

Great extras

I’m only scratching the surface of all the amazing new capabilities in CF 8. The list goes on and on to include: generating ATOM and RSS feeds with one line of code; zip file manipulation; built-in Flex Data Services; ColdFusion administrator enhancements; and PDF and PDF form generation. There are three additional benefits to using CF 8 that I will briefly cover.
CF 8 lets you integrate with .NET objects as easily as you can currently integrate with Java objects. The .NET assets can be remote, which means you can use them even if your ColdFusion server is running a UNIX-based OS.
Adobe supplies a series of nice plug-ins for the Eclipse IDE that work with CF 8. This includes simple things like built-in ColdFusion docs, automatic generation of CFCs (including ActiveRecord, Data Access Objects, Beans, etc.), and wizards that will generate a full-blown AJAX application. It also includes a full debugging perspective. In conjunction with the free CFEclipse plug-in, this makes Eclipse the standard IDE for most advanced ColdFusion developers.
CF 8 gives you the ability to do your own thread-based programming. If you have a long running task, you can fire off another processing thread and forget about it; or you can trigger multiple threads to speed up a process and then join them back together and continue.

Download a free edition of CF 8

CF 8 Developer Edition is free, so I urge you to give it an honest look. I believe existing ColdFusion users will find a lot to like in version 8, and new users should try out this application server.

What do you think of CF 8?

Now that I’ve shared my thoughts about my favorite features and enhancements in CF 8, I want to hear what you think of this release. What features do you like the most in CF 8? If you aren’t using CF 8, what features pique your interest enough to give it a look?


Click here to view