Objective:

Creating or regenerating the SQL script using SQL Developer Tool:

The "Views" in oracle suffices a virtual table or a derived table from another table using SQL (DDL) create statements.

Script:

CREATE OR REPLACE FORCE VIEW
"SCOTT"."E_VIEW1" ("EMPNO", "ENAME", "JOB", "DNAME", "DEPTNO") AS
select e.empno, e.ename,e.job,d.dname , d.deptno
from emp e,dept d where e.deptno = d.deptno
AND e.deptno in (10,20);

Creates a view,

DDL : SQL developer can generate SQL script from the existing table or views.