在Oracle Developer中使用参数直接查询

with param AS(

SELECT 1234 empid
FROM dual)
SELECT *
FROM Employees, param
WHERE EmployeeID = param.empid;

https://stackoverflow.com/questions/5653423/how-do-i-use-variables-in-oracle-sql-developer