CREATE VIEW my_table_view (column1,column2, column3_less_than_30) AS SELECT column1,column2,column3_is_much_much_much _much_much_longer_than_30_characters FROM my_table;In Oracle, you query the view, which pulls data from the table.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.