[ORACLE] Create and Drop Tables or Views

 

In Oracle, We hope to join different tables called EMPLOYEES and EMP_DETAILS_VIEW and create a table or view.

 

 

 

 

Then, now We join tables as below:

 

[1] Join

SELECT A.FIRST_NAME,B.LAST_NAME,A.EMAIL,A.JOB_ID,B.DEPARTMENT_NAME,B.MANAGER_ID
FROM EMPLOYEES A JOIN EMP_DETAILS_VIEW B ON A.EMPLOYEE_ID=B.EMPLOYEE_ID;

 

[2] Create Table

CREATE TABLE TEMP_TABLE AS

SELECT A.COLUME1, B.COLUME2, A.COLUME3, A.COLUME4, B.COLUME5, B.COLUME6

FROM TABLE_1 A JOIN TABLE_2 B ON A.COLUME = B.COLUME;

CREATE VIEW TEMP_TABLE AS
SELECT A.FIRST_NAME,B.LAST_NAME,A.EMAIL,A.JOB_ID,B.DEPARTMENT_NAME,B.MANAGER_ID
FROM EMPLOYEES A JOIN EMP_DETAILS_VIEW B ON A.EMPLOYEE_ID=B.EMPLOYEE_ID;

 

[3] Create View

CREATE VIEW TEMP_VIEW AS

SELECT A.COLUME1, B.COLUME2, A.COLUME3, A.COLUME4, B.COLUME5, B.COLUME6

FROM TABLE_1 A JOIN TABLE_2 B ON A.COLUME = B.COLUME;

CREATE VIEW TEMP_TABLE AS
SELECT A.FIRST_NAME,B.LAST_NAME,A.EMAIL,A.JOB_ID,B.DEPARTMENT_NAME,B.MANAGER_ID
FROM EMPLOYEES A JOIN EMP_DETAILS_VIEW B ON A.EMPLOYEE_ID=B.EMPLOYEE_ID;

 

[4] Delete Table

DROP TABLE TEMP_TABLE;

 

[5] Delete View

DROP VIEW TEMP_VIEW;