[转]How do I use variables in Oracle SQL Developer

本文转自：http://stackoverflow.com/questions/5653423/how-do-i-use-variables-in-oracle-sql-developer

WITH
    emplVar AS
    (SELECT 1234 AS id FROM dual)
SELECT
    *
FROM
    employees,
    emplVar
WHERE
    EmployId=emplVar.id;