Please find the video that summarizes all the steps executed in the previous articles starting from Article 01 to Article 07.

Before you run this video, ensure that
1. You have downloaded latest version of JDeveloper from Oracle website. Simply google on Download JDeveloper
2. Downloaded and installed Oracle XE Database, again google to download this, and install the database.
3. Ensure following tables have been created in the hr schema of your database

desc xxa2f_emp_table
EMPLOYEE_NAME                           VARCHAR2(20)                                                                                                                                                                                  
EMPLOYEE_ID                                 NUMBER(6)                                                                                                                                                                                     
HIRE_DATE                                      DATE                                                                                                                                                                                          
EMAIL_ADDRESS                            VARCHAR2(20)                                                                                                                                                                                  
MANAGER_ID                                   NUMBER(6)                                                                                                                                                                                     
DEPT_ID                                          NUMBER(6)                                                                                                                                                                                     
ACTIVE_FLAG                                 VARCHAR2(1)                                                                                                                                                                                   
GENDER                                          VARCHAR2(1)                                                                                                                                                                                   
SALARY_AMOUNT                           NUMBER(6)                                                                                                                                                                                     

desc xxa2f_dept
DEPT_ID                                     NUMBER(6)                                                                                                                                                                                     
DEPT_NAME                               VARCHAR2(20)                                                                                                                                                                                  
LOCATION_ID                             NUMBER(6)                                                                                                                                                                                     

desc xxa2f_location
LOCATION_ID                             NUMBER(6)                                                                                                                                                                                     
LOCATION_NAME                           VARCHAR2(20)                                                                                                                                                                                  

Watch this video in HD for best results.

Now, follow this video in HD
http://youtu.be/YRY2UXmQIm4

Anil Passi

Add comment