# data[].attributes.body
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj29840.html

http://www.techonthenet.com/oracle/joins.php

# data[].attributes.body
http://justcr4zy.blogspot.com/2010/05/test-final-exam-semester-2-part-i-1-10.html

http://quizoracle.blogspot.com/2010/11/final-exam-semester-1.html

http://oacexam.blogspot.com/2012/10/mid-term-exam-semester-1.html

http://oacexam.blogspot.com/2012/10/mid-term-exam-semester-1.html

http://www.academia.edu/8918093/Mid_Term_Exam_Semester_1.html

# data[].attributes.body
http://ilearning.oracle.com/ilearn/en/learner/jsp/login.jsp?site=OracleAcad

# data[].attributes.headline
Developing Rich Web Applications With Oracle ADF

# data[].attributes.subject
Developing Rich Web Applications With Oracle ADF

# data[].attributes.body
http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_55/jdtut_11r2_55_1.html

http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_55/jdtut_11r2_55_2.html

http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_55/jdtut_11r2_55_3.html

# data[].attributes.body
Creating a Function: Examples The following statement creates the function get_bal on the sample table oe.orders:

CREATE FUNCTION get_bal(acc_no IN NUMBER)
   RETURN NUMBER
   IS acc_bal NUMBER(11,2);
   BEGIN
      SELECT order_total
      INTO acc_bal
      FROM orders
      WHERE cust_id = acc_no;
      RETURN(acc_bal);
    END;
/

The get_bal function returns the balance of a specified account.

When you call the function, you must specify the argument acc_no, the number of the account whose balance is sought. The data type of acc_no isNUMBER.

The function returns the account balance. The RETURN clause of the CREATE FUNCTION statement specifies the data type of the return value to beNUMBER.

The function uses a SELECT statement to select the balance column from the row identified by the argument acc_no in the orders table. The function uses a RETURN statement to return this value to the environment in which the function is called.

The function created in the preceding example can be used in a SQL statement. For example:

SELECT get_bal(165) FROM DUAL;

GET_BAL(165)
------------
        2519

# data[].attributes.body
Creating a Function: Examples The following statement creates the function get_bal on the sample table oe.orders:

CREATE FUNCTION get_bal(acc_no IN NUMBER)
   RETURN NUMBER
   IS acc_bal NUMBER(11,2);
   BEGIN
      SELECT order_total
      INTO acc_bal
      FROM orders
      WHERE customer_id = acc_no;
      RETURN(acc_bal);
    END;
/

The get_bal function returns the balance of a specified account.

# data[].attributes.body
select * from user_tables;

select *from employees;

# data[].attributes.body
US_A001APAC1716_SQL01_S48

Oracle_2014 --> sudah ditukar dengan my default password

URL: https://iacademy.oracle.com

# data[].attributes.body
download: Oracle SQL Developver

# data[].attributes.body
subtype is a supertype.

A CAR is a VEHICLE.

A CAT is an ANIMAL.

# data[].attributes.body
\\10.7.11.17\training\oracle database design and sql

# data[].attributes.body
to get the material, click Sign In under Oracle iLearning.

# data[].attributes.body
Go to this URL and Sign in as: I am a faculty member