Skip to content

View

IT Notes → Database → SQL @ December 22, 2020

View is nothing but parsed SQL statement which fetches record at the time of execution.

There are mainly two types of views:

  1. Simple View.
  2. Complex View.

Also

  1. Updatable Views.
  2. Read only Views.

 

Finally, we have Materialized Views.

View is used for the purposes as stated below:

  1. Security.
  2. Faster response.
  3. Solve complex query.

 

Syntax is:

CREATE or REPLACE view ([olumn1] [column2]...)
AS
SELECT column1 column2...
FROM tablename
[WHERE condition]
[WITH read only] [WITH check option]

Related Posts

  1. SQL ( IT Notes → Database → SQL )
  2. Create Table ( IT Notes → Database → SQL )
  3. Import Data ( IT Notes → Database → SQL )
  4. Select ( IT Notes → Database → SQL )
  5. Update ( IT Notes → Database → SQL )
  6. Delete ( IT Notes → Database → SQL )
  7. Join ( IT Notes → Database → SQL )
  8. Create ( IT Notes → Database → SQL )
  9. General ( IT Notes → Database )
  10. RDBMS ( IT Notes → Database )
  11. Data Model ( IT Notes → Database )
  12. Logical Data Model ( IT Notes → Database )
  13. Physical and Relational Data Model ( IT Notes → Database )
  14. Data Normalization ( IT Notes → Database )
  15. Managing the RDBMS ( IT Notes → Database )
  16. Security ( IT Notes → Database )
  17. Performance Issue ( IT Notes → Database )
  18. Insert ( IT Notes → SQL )
  19. Programming ( IT Notes → Database )
  20. MS SQL ( IT Notes → Database )
  21. Introduction ( IT Notes → Database → Oracle )
  22. Data Definition Language ( IT Notes → Database → Oracle )
  23. Data Manipulation Language ( IT Notes → Database → Oracle )
  24. Data Control Language ( IT Notes → Database → Oracle )
  25. Transaction Control Language ( IT Notes → Database → Oracle )
  26. Miscellaneous ( IT Notes → Database → Oracle )
  27. Abbreviations ( IT Notes → Abbreviations )
  28. OOP Concepts or Object Oriented Programming Concepts ( IT Notes → Object Oriented Programming )
  29. Basics ( IT Notes → Javascript )
  30. Regex ( IT Notes → Javascript )
  31. Functions ( IT Notes → Javascript )
  32. General ( IT Notes → Javascript )
  33. Debugging ( IT Notes → Javascript )
  34. Data Types ( IT Notes → PHP )
  35. Operators ( IT Notes → PHP )
  36. Design Pattern ( IT Notes → PHP )
  37. Security ( IT Notes → PHP )
  38. Streams and Network Programming ( IT Notes → PHP )
  39. Arrays ( IT Notes → C# )
  40. Namespace ( IT Notes → C# )
  41. Indexers ( IT Notes → C# )
  42. Generics ( IT Notes → C# )
  43. Attributes ( IT Notes → C# )
  44. Anonymous Types ( IT Notes → C# )
  45. Performance Thumb Rules ( IT Notes → C# )
  46. Different Types of Testing ( IT Notes → Testing )
  47. SAS 70 Type II Audit – Data Security ( IT Notes → Testing )
  48. Tracking Defects ( IT Notes → Testing )
  49. General ( IT Notes → SEO )
  50. IT Notes ( IT Notes )
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x