Salim berbagi…. tempat belajar dan berinteraksi….


UAS Susulan – S1/TI/5/K – Basis Data Oracle
November 25, 2011, 12:50 PM
Filed under: Teknik Informatika

UAS – Oracle – S1 TI 5 K Susulan

Advertisements


Nilai UAS – S1/TI/3/K – Perancangan Basis Data
November 21, 2011, 12:25 AM
Filed under: Teknik Informatika



Kisi-Kisi UAS Basis Data Oracle
November 15, 2011, 1:34 AM
Filed under: Teknik Informatika

Kisi-Kisi UAS Basis Data Oracle
Teknik Informatika S1/TI/5/K 2011

– View
– Database Trigger
– PL/SQL Stored Function
– PL/SQL Stored Procedure



Kisi-Kisi UAS Perancangan Basis Data (MySQL)
November 15, 2011, 1:34 AM
Filed under: Teknik Informatika

Kisi-Kisi UAS Perancangan Basis Data (MySQL)
Teknik Informatika S1/TI/5/K 2011

– Create Table
– DML (Insert, Update, Delete)
– SQL(Query) for MySQL



Module Praktek MySQL – Query & Contoh Data
November 11, 2011, 7:48 AM
Filed under: Teknik Informatika

Download Materi MySQL – Query (SQL) 1

Download Contoh Data Item Master

Download Contoh Data Item Price

 

 



Module Praktek Perancangan Basis Data – MySQL Part 2
November 10, 2011, 11:05 AM
Filed under: Teknik Informatika

Download Module Praktek MySQL DML



Function – Get Current Unit Cost
November 8, 2011, 6:26 AM
Filed under: ORACLE

Purpose: Custom Stored Function for getting current unit cost of certain item on each organization

Module: Inventory. Oracle EBS

 

CREATE OR REPLACE FUNCTION Get_current_unit_cost_func (
   v_period    VARCHAR2,
   v_item_id   NUMBER,
   v_org       NUMBER
)
   RETURN NUMBER
IS
   v_trx_id   NUMBER;
   v_cost     NUMBER;
BEGIN
   SELECT MAX (transaction_id)
     INTO v_trx_id
     FROM mtl_material_transactions
    WHERE TO_CHAR (transaction_date, ‘rrrrmm’) = v_period
      AND inventory_item_id = v_item_id
      AND organization_id = v_org;

   SELECT new_cost
     INTO v_cost
     FROM mtl_cst_actual_cost_details
    WHERE transaction_id = v_trx_id;

   RETURN v_cost;
EXCEPTION
   WHEN OTHERS
   THEN
      RETURN 0;
END;