Oracle: Create a simple database view


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 <>
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.