Notes

--Oracle 11g Express Edition
-- Put your Oracle SQL statement here and execute it


BEGIN
show_name('Daniel Boy', '1410720010');
END

BEGIN
add_number(10,11);
END

BEGIN
print_bintang;
END

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

CREATE OR REPLACE PROCEDURE add_number(bil_1 IN NUMBER, bil_2 IN NUMBER)
IS
vTambah VARCHAR(10);
BEGIN
SELECT bil_1 + bil_2 INTO vTambah
FROM dual;

DBMS_OUTPUT.PUT_LINE('Hasil Penambahan ' || vTambah);
END add_number;

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

CREATE OR REPLACE PROCEDURE print_bintang
IS
vBintang VARCHAR(10);
BEGIN
SELECT '*******' INTO vBintang
FROM dual;

DBMS_OUTPUT.PUT_LINE(vBintang);
END print_bintang

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

CREATE OR REPLACE PROCEDURE show_name(nama IN VARCHAR2, nim IN VARCHAR2)
IS
vName VARCHAR(50);
vNim VARCHAR(10);
BEGIN
SELECT nama, nim INTO vName, vNim FROM dual;

DBMS_OUTPUT.PUT_LINE('Nama : ' || vName);
DBMS_OUTPUT.PUT_LINE('NIM : ' || vNim);

END show_name;

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

select cetak_bintang from dual;

select func_add_number(10,11) from dual;



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

CREATE OR REPLACE FUNCTION cetak_bintang
RETURN VARCHAR2
IS
vBintang VARCHAR(10);
BEGIN
SELECT '*******' INTO vBintang
FROM dual;

RETURN vBintang;
END cetak_bintang;

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

CREATE OR REPLACE FUNCTION func_add_number(bil_1 IN NUMBER, bil_2 IN NUMBER)
RETURN VARCHAR2
IS
vTambah VARCHAR(10);
BEGIN
SELECT bil_1 + bil_2 INTO vTambah
FROM dual;

RETURN vTambah;
END func_add_number;

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

CREATE OR REPLACE FUNCTION func_show_name(nama IN VARCHAR2, nim IN VARCHAR2)
RETURN
IS
type array_data is varray(3) of varchar2(10);
new_array_data array_data := array_data();

BEGIN
SELECT nama, nim INTO new_array_data(0), new_array_data(1) FROM dual;

RETURN new_array_data;

END show_name;