ORACLE - CHECK DATABASE SIZE

TO CHECK DATABASE SIZE, USE THIS SQL IN TOAD OR SQLPLUS :



select ROUND( ( a.data_size + b.temp_size +
c.redo_size + d.cf_size +
e.bct_size)
/1024/1024/1024
) "total_GB_size"
from
( select SUM(bytes) data_size from v$datafile) a,
( select NVL(sum(bytes),0) temp_size from v$tempfile) b,
( select SUM(bytes) redo_size from v$log) c,
( select SUM(block_size*file_size_blks) cf_size from v$controlfile) d,
( select NVL(bytes,0) bct_size from v$block_change_tracking) e


 total_GB_size = 215


select a.data_size+b.temp_size+c.redo_size "total_size"
from ( select sum(bytes)/1024/1024 data_size
from dba_data_files )a,
( select nvl(sum(bytes),0)/1024/1024 temp_size
from dba_temp_files ) b,
( select sum(bytes)/1024/1024 redo_size
from sys.v_$log ) c

Oracle - DISPLAY LOCK ACCOUNT

This is how you select all the LOCKED account in your oracle database :


SELECT username, account_status
FROM dba_users
where account_status = 'LOCKED'

KURSUS COLDFUSION

Saya telah mengendalikan satu kursus Latihan Pembangunan Web Applikasi menggunakan Adobe Coldfusion For Beginners pada 14 dan 15 Disember 2011 dibantu oleh Puan Masita bertempat di Makmal Komputer, Pejabat Teknologi Maklumat, UiTM Shah Alam.

Pembelajaran ada dalam kaedah Virtual Box dengan OS Windows XP untuk memudahkan peserta.

Berminat untuk sebarang kursus Adobe Coldfusion? email saya di hairekahfi@gmail.com

Modul Pembelajaran :

1. UNIT 1: GETTING STARTED WITH COLDFUSION 8
1.1. INSTALLING SOFTWARE AND COURSE FILES
1.2. UNDERSTANDING DYNAMIC WEB PAGES

1.3. INTRODUCING COLDFUSION 8
1.4. EXPLORING DREAMWEAVER CS4

2. UNIT 2: BUILDING COLDFUSION APPLICATIONSLESSON 1: CREATING COLDFUSION VARIABLES
2.2. LESSON 2: DISPLAYING VARIABLE VALUES
2.3. LESSON 3: INCLUDING FILES
2.4. LESSON 4: COMMENTING CODE
2.5. BEST PRACTICES AND SUMMARY
2.6. ON YOUR OWN: VIEWING THE COURSE APPLICATION

3. UNIT 3: PUBLISHING DATABASE CONTENT
3.1. LESSON 1: CONNECTING TO A DATABASE
3.2. LESSON 2: QUERYING A DATABASE TABLE
3.3. LESSON 3: VIEWING DEBUG DATA
3.4. LESSON 4: DUMPING A RECORDSET TO A BROWSER
3.5. LESSON 5: DISPLAYING DATABASE DATA
3.6. LESSON 6: USING THE DYNAMIC TABLE TOOL
3.7. LESSON 7: USING THE RESULTSET STRUCTURE DATA
3.8. LESSON 8: USING COLDFUSION FUNCTIONS
3.9. BEST PRACTICES AND SUMMARY
3.10. ON YOUR OWN: CREATING THE HOME PAGE

4. UNIT 4: BUILDING FORMS WITH COLDFUSION
4.1. LESSON 1: UNDERSTANDING HTML FORMS
4.2. LESSON 2: ENABLING DEBUG OUTPUT
4.3. LESSON 3: SELF-POSTING FORMS
4.4. LESSON 4: DETERMINING FORM SUBMISSION
4.5. LESSON 5: EVALUATING FORM VARIABLES
4.6. LESSON 6: INTRODUCING COLDFUSION FORMS
4.7. BEST PRACTICES AND SUMMARY
4.8. ON YOUR OWN: CREATING A SEARCH FORM
5. UNIT 5: BUILDING SEARCH INTERFACES
5.1. LESSON 1: USING FORM DATA IN DYNAMIC QUERIES
5.2. LESSON 2: PRESERVING FORM DATA
5.3. LESSON 3: CREATING DYNAMIC SQL FOR MULTIPLE SEARCH CRITERIA
5.4. LESSON 4: USING TEXT SEARCHES
5.5. LESSON 5: USING LIST SEARCHES
5.6. BEST PRACTICES AND SUMMARY
5.7. ON YOUR OWN: BUILDING CHECK ORDER STATUS LOGIC

6. UNIT 6: BUILDING A DRILL-DOWN INTERFACE
6.1. LESSON 1: USING DYNAMIC URL PARAMETERS
6.2. LESSON 2: CREATING A DATA DRILL-DOWN
6.3. LESSON 3: CREATING ON-THE-FLY PDF DOCUMENTS
6.4. LESSON 4: DISPLAYING DATA IN A TABBED INTERFACE
6.5. BEST PRACTICES AND SUMMARY
6.6. ON YOUR OWN: DISPLAYING ORDER ITEM INFORMATION

7. UNIT 7: INSERTING NEW DATA
7.1. LESSON 1: BUILDING AN INSERT FORM PAGE
7.2. LESSON 2: VALIDATING COLDFUSION FORMS
7.3. LESSON 3: BUILDING INSERT ACTION LOGIC
7.4. LESSON 4: REDIRECTING PROCESS FLOW
7.5. BEST PRACTICES AND SUMMARY
7.6. ON YOUR OWN: ADDING AN ART PIECE
8. UNIT 8: UPDATING AND DELETING DATA
8.1. LESSON 1: BUILDING AN UPDATE FORM PAGE
8.2. LESSON 2: BUILDING UPDATE LOGIC
8.3. LESSON 3: DELETING RECORDS FROM THE DATABASE
8.4. LESSON 4: IMPROVING SQL SECURITY
8.5. BEST PRACTICES AND SUMMARY
8.6. ON YOUR OWN: UPDATING ART WORK DATA

9. UNIT 9: REUSING TEMPLATES
9.1. LESSON 1: REUSING CODE
9.2. LESSON 2: USING USER-DEFINED FUNCTIONS
9.3. LESSON 3: INTRODUCING COLDFUSION COMPONENTS
9.4. BEST PRACTICES AND SUMMARY
9.5. ON YOUR OWN: CREATE AND USE A CUSTOM TAG

10. UNIT 10: SECURING AN APPLICATION
10.1. LESSON 1: USING THE APPLICATION FRAMEWORK
10.2. LESSON 2: USING APPLICATION VARIABLES
10.3. LESSON 3: PERSISTENT STATE VARIABLES AND WORKING WITH SESSION
10.4. VARIABLES
10.5. BEST PRACTICES AND SUMMARY

Aku Maafkan Kamu - Malique Feat. Jamal Abdillah

Lagu ni baru dengar dekat ERA atau HOTFM... menarik, tertarik meme da bomb kata org alqaeda... jamal punya part tu memang power laa....


Tajuk: AKU MAAFKAN KAMU
Artis Malique featuring Jamal Abdillah
Lirik: Malique
Lagu : Tripdisz
Dikerluarkan oleh : Malique for Qarma Musiq

Lirik Lagu Malique Aku Maafkan Kamu Feat. Jamal Abdillah

Aku minta maaf di atas segala perbuatanku.
Ternyata kamu lebih suci dari apa yang kubayangkan

Ada teratak di hujung kampung
Bawah cermin kopak ada kotak
Tersembunyi dalamnya ada tempurung
Sembunyi bawahnya katak melalak

Aku maafkan kamu
Tak perlu kita bertemu
Cukup kau tahu
Yang aku
Maafkan kamu
Tolong teruskan hidup
Jangan sebut namaku

Atur sepuluh daktil batal yang batil
Detik dua usul ditutup satu lagi tampil
Dari halaman rusuk kiri satu susuk ganjil
Minta diisolasi dari dalil busuk jahil
Aspirasi tak serasi dengan suara bunyi
Inkarserasi dari penghuni dan keluarga bumi
Surat wasiatnya atas paksi dalam rumi
Minta dikebumikan hidup-hidup dalam guni
Mana cepat terbang atau warna gelang tangan
Buah fikiran aneh tergantung di persimpangan
Halusinasi susuli ketandusan ihsan
Ubat parut auditori kesan artileri insan
Gagal dikesan


Aku maafkan kamu
Tak perlu kita bertemu
Cukup kau tahu
Yang aku
Maafkan kamu
Tolong teruskan hidup
Jangan sebut namaku


Timbul tenggelam, timbul tenggelam
Acapkali terpendam, acapkali tersergam
Cermin muka kopak penuh bintik hitam silam
Ini bukan lagu rindu ini madah dendam
Kutimbang tanpa neraca di awal usia
Ku dihukum masuk neraka oleh manusia
Minta tunjuk lubang atau pintu tak dapat jawapan jitu
Jadi aku tak berganjak biarkan saja begitu
Maafkan mereka, mereka tidak tahu
Mereka tidak ramas buku, mereka segan ilmu
Mereka tidak fasih malah fasik guna kata
Kita kongsi nama bangsa tapi tidak kasta bahasa
Maafkan mereka, mereka tiada nilai
Ibu bapa lalai dari kecil dah diabai
Tanpa kasih sayang, mereka suka menyakiti
Kita kongsi warna mata tapi tidak warna hati


Atas kepala murai sekawan
Mari ku ramit kucup lehernya
Terlalu rahi dendam di angan
Sampai terkacip mulut mahirnya


Kenapa awak tak pukul mereka?
Saya tak suka pada keganasan


Jangan ahli sihir seru nama maharaja
Nanti segerombolan hantu bisu yang menjelma
Guna hak berfikir sebelum hak untuk bersuara
Kalau terpelajar sila guna hak miranda
Pura-pura dengar, telan tapi tidak hadam
Hafaz bila lafaz tapi mereka tidak faham
Mereka mula kiri, aku kanan bila baca
Sudah mahir rumi, mari tafsir alif ba ta


(Alif)
Ada teratak di hujung kampung
(Ba)
Bawah cermin kopak ada kotak
(Ta)
Tersembunyi dalamnya ada tempurung
Sembunyi bawahnya katak melalak


Ternyata kamu lebih suci dari apa yang kubayangkan




Download disini... kalau ada laa... aku pun takde laaa...
 

Photobook Easy to PDF

Assalamualaikum...


Buat rakan rakan yang rajin design photobook untuk diprint... setelah penat berphotoshoot lepas raya...

download aje ini program dari HP... terbaek dan mudah... output terus ke PDF... 
combine dan boleh hantar ke mana mana kedai... 


http://www.hp.com/global/us/en/consumer/digital_photography/free/software/photo-creations.html?jumpid=ex_r602_go/hppcstudio


Bila dah buat.. jangan lupa install PDF printer...


untuk jadikan PDF... print as PDF dan... violahhhhh.... terbaek... kata tok aba...

Photoscape itu bagus... tapi susah nak adjust frame kasi senget or macam macam...\

Selamat Hari Raya Dari Kami Seisi Keluarga....

Pantun Raya Banjar untuk Semua....

Memarut ninyor sagan mengga-ngan,

pemarut di-injam dirumah kulaan,

tuhok hudah kita begurauan,

wayahnya kini kita bemaapan

"Selamat Hari Raya untuk semua rakan rakan
dan
semua umat manusia seantero dunia...

Dari Kami Seisi Keluarga....

Jemput Datang Ke Rumah pada sepanjang Syawal tahun ini ke Syawal tahun depan...

Di Alamat :

No 3, Jalan Meranti 9C/KU 10,

Taman Desa Permai,

Meru Klang

Download Peta Rumah Disini

Peta Google Map Disini

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...

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

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_SOURCE, ALL_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=
/

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.

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#">

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....

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....

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.

Free Adobe Flex Builder 3 Pro for Education is also available.

Articel from http://www.mydigitallife.info