如何在 Oracle SQL Developer 中使用变量?

2021-12-05 00:00:00 sql variables oracle declare

以下是在 SQL Server 2000 中使用变量的示例.

Below is an example of using variables in SQL Server 2000.

DECLARE @EmpIDVar INT

SET @EmpIDVar = 1234

SELECT *
FROM Employees
WHERE EmployeeID = @EmpIDVar

我想使用 SQL Developer 在 Oracle 中做完全相同的事情，而不会增加额外的复杂性.这似乎是一件非常简单的事情，但我找不到简单的解决方案.我该怎么做?

I want to do the exact same thing in Oracle using SQL Developer without additional complexity. It seems like a very simple thing to do, but I can't find a simple solution. How can I do it?

推荐答案

我使用的是 3.2 版的 SQL-Developer.其他东西对我不起作用，但这对我有用:

I am using the SQL-Developer in Version 3.2. The other stuff didn't work for me, but this did:

define value1 = 'sysdate'

SELECT &&value1 from dual;

这也是这里介绍的最巧妙的方式.

Also it's the slickest way presented here, yet.

(如果您省略define"部分，您将被提示输入该值)

(If you omit the "define"-part you'll be prompted for that value)

相关文章