LaGiPusHinGWitH ---- IT

Navigation

Home |

Categories

• Computer Hacking
• Computer Diary
• Computer DataBase
• Computer Propaganda
• Computer Prophile
• Computer Security
• Computer Unix

Monthly Archives

• September 2010
• October 2009
• December 2008
• November 2008
• October 2008
• September 2008
• July 2008
• May 2008
• March 2008
• December 2007
• October 2007
• September 2007
• August 2007

Most recent entries

• Create Oracle Tablespace on SAP with BRTools
• Audit on Oracle Database
• Membuat Oracle Data Guard
• Cerita Tentang Kamu
• Membuat ulang/re-create controlfile di oracle
• Membuat RMAN dengan crontab
• Saat kau hadir kembali
• Memindahkan controlfile dan redologfile pada Oracle
• Oracle Dataguard on Standart Edition
• Adakah aku dihatimu
• Instalasi 10g di HP-UX Itanium
• Instalasi OpenOffice di Slackware 12
• Syncronize archive log
• Merubah ukuran archived Log
• Alter Block Size for tablespace

Syndicate

• RSS 2.0
• Atom

Site Credits

Powered by:
ExpressionEngine

Design by:
BlogMoxie

sintak umum -->

Code:
CREATE OR REPLACE FUNCTION nama_fungsi
(parameter_1, ....)
RETURN tipe_data AS
variabel_1 tipe_data;
........
BEGIN
statemen_1;
........
RETURN nilai_yang_dikembalikan;
END;

contoh :

Code:
CREATE OR REPLACE FUNCTION SEGMENT (SALES NUMBER)
RETURN CHAR AS
SEGM CHAR(2);
BEGIN
IF (SALES >= 1000000) THEN
SEGM := ‘AA’;
ELSE IF ((SALES >= 700000) AND (SALES < 1000000)) THEN
SEGM := ‘AB’;
ELSE IF ((SALES >= 500000) AND (SALES < 700000)) THEN
SEGM := ‘AC’;
ELSE
SEGM := ‘AD’;
END IF;
RETURN SEGM;
END;
/

contoh itu adalah untuk pembuatan fungsi segmentasi dari customer berdasarkan pembelian.

fungsi ada :
- Fungsi tanpa parameter
- Fungsi dengan paramater
- Fungsi didalam fungsi (nested function)