Hi,
Anyone who knows the definition of database view?
and what is database view used for?
I'll appreciate it if someone answer my question.
thanks a lot.
Discussion posts and replies are publicly visible
The view is virtual table created from the base table and they don't have physical existence in the database. it contains rows and columns like a real table.
views are used for security purpose, for ex. u have a data of US employee like emp_id, emp_name, emp_department and their emp_SSNNo.....now u dont want to show the SSN number to the user u can hide it using views means u are keeping it secure and hiding confidential info.