sql - What's the difference between With and View in Oracle?

Question

programmers. I have a question. I know that Oracle's WITH is used when using subquery a lot, what is the difference from View?

question from:https://stackoverflow.com/questions/65947677/whats-the-difference-between-with-and-view-in-oracle

Answer 1

With: The WITH clause is a kind of inline view or a temporary table. The advantage of using is that if there is multiple reference to a subquery it can be replaced temporary table, rather being written multiple times.

View: It is a virtual table based on the result of an SQL statement.