query oracle data block with two tables

one data block named Employees  ( which is a Table )

one canvas on which you are showing its data

in menu there are options like:

  Employees

  Employees History

 

when user select Employees then first data block appear and show the data

when user select Employees History then this will show data from table Employees History ( both tables have same number of columns and column names )

create table EMPLOYEES  
(  
  employee_id    NUMBER(6) not null,  
  first_name     VARCHAR2(20),  
  last_name      VARCHAR2(25) not null,  
  email          VARCHAR2(25) not null,  
  phone_number   VARCHAR2(20),  
  hire_date      DATE not null,  
  job_id         VARCHAR2(10) not null,  
  salary         NUMBER(8,2),  
  commission_pct NUMBER(2,2),  
  manager_id     NUMBER(6),  
  department_id  NUMBER(4)  
);  
  
  
  
  
  
  
create table EMPLOYEE_HISTORY  
(  
  employee_id    NUMBER(6) not null,  
  first_name     VARCHAR2(20),  
  last_name      VARCHAR2(25) not null,  
  email          VARCHAR2(25) not null,  
  phone_number   VARCHAR2(20),  
  hire_date      DATE not null,  
  job_id         VARCHAR2(10) not null,  
  salary         NUMBER(8,2),  
  commission_pct NUMBER(2,2),  
  manager_id     NUMBER(6),  
  department_id  NUMBER(4)  
); 

Select allOpen in new window