[轉]How do I use variables in Oracle SQL Developer?

標籤：

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

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

DECLARE @EmpIDVar INTSET @EmpIDVar = 1234SELECT *FROM EmployeesWHERE EmployeeID = @EmpIDVar

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?

 

 

You can read up elsewhere on substitution variables; they‘re quite handy in SQL Developer.  But I have fits trying to use bind variables in SQL Developer.  This is what I do:

SET SERVEROUTPUT ONdeclare  v_testnum number;  v_teststring varchar2(1000);begin   v_testnum := 2;   DBMS_OUTPUT.put_line(‘v_testnum is now ‘ || v_testnum);   select 36,‘hello world‘   INTO v_testnum, v_teststring   from dual;   DBMS_OUTPUT.put_line(‘v_testnum is now ‘ || v_testnum);   DBMS_OUTPUT.put_line(‘v_teststring is ‘ || v_teststring);end;

SET SERVEROUTPUT ON makes it so text can be printed to the script output console.

 

[轉]How do I use variables in Oracle SQL Developer?