Oracle: Create a simple database view

logo-oracle-256x256

To create a very simple view of the name and firstName of our customerstable in your database, use the following statement:

-- replace the names within the <>
CREATE VIEW  
AS SELECT name, firstName FROM ;

Maybe the customers table has many columns, but for your view, which you want to use in the reporting software, you only need the name and firstName, you can create such a simple view.