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 |
Creates a view,
|
DDL : SQL developer can generate SQL script from the existing table
or views.
|