oracle with as

"WITH" is a SQL keyword that is used to define a temporary table within a query. This is also known as a Common Table Expression (CTE).

In Oracle, the syntax for using "WITH" is:

WITH temp_table_name AS (
    SELECT ...
    FROM ...
    WHERE ...
)
SELECT ...
FROM temp_table_name
WHERE ...

Here, `temp_table_name` is the name of the temporary table that is being defined within the query. The `SELECT` statement within the parentheses defines the contents of the temporary table.

After the temporary table has been defined, it can be referenced in the main query using the name `temp_table_name`.

The purpose of using "WITH" is to simplify complex queries by breaking them down into smaller, more manageable parts. It also makes queries more readable and easier to understand.