Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

writable views

 
Joseph Sweet
Ranch Hand
Posts: 327
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.

Anyone knows what writable views are? It's something about SQL. I know what views are, I am not sure what writable views can be.

I have encounter the term in some book, but of course they did not bother to explain what it means. We have all been taught in kindergarten what writable views are. Or haven't we?

I also tried google, but didn't find there anything substantial either.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
writable views? I've not heard that term, but it could be another name for updatable views. Views are used as read only things normally, however if you write them to meet certain contitions you can update the data via the view. Such conditions could include:
  • No set operators
  • No aggregate functions
  • No sub-queries
  • No pseudo-columns

  • and so on.
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic