且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2023-01-22 09:14:18

我使用的是 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)