How to declare and display a variable in Oracle

Question

I would like to declare and display a variable in Oracle   In T-SQL I would do something like this  DECLARE  A VARCHAR 10  --Declares  A SELECT  A    12  --Assigns  A SELECT  A --Displays  A   How can I do this in Oracle

User · Answer

If using sqlplus you can define a variable thus:

define <varname>=<varvalue>

And you can display the value by:

define <varname>

And then use it in a query as, for example:

select *
from tab1
where col1 = '&varname';

User · Answer

If you re talking about PL SQL  you should put it in an anonymous block   DECLARE     v text VARCHAR2 10   -- declare BEGIN     v text     Hello    --assign     dbms output Put line v text   --display END

User · Answer

If you are using pl sql then the following code should work    set server output on -- to retrieve and display a buffer  DECLARE      v text VARCHAR2 10   -- declare BEGIN      v text     Hello    --assign     dbms output Put line v text   --display END        -- this must be use to execute pl sql script

User · Answer

Make sure that  server output is on otherwise output will not be display  sql gt  set serveroutput on  declare   n number 10   1  begin   while n lt  10  loop    dbms output put line n      n  n 1   end loop  end     Outout  1 2 3 4 5 6 7 8 9 10

User · Answer

Did you recently switch from MySQL and are now longing for the logical equivalents of its more simple commands in Oracle  Because that is the case for me and I had the very same question  This code will give you a quick and dirty print which I think is what you re looking for   Variable n number begin      n    1  end  print n   The middle section is a PL SQL bit that binds the variable   The output from print n is in column form  and will not just give the value of n  I m afraid   When I ran it in Toad 11 it returned like this          n ---------         1   I hope that helps

[oracle] How to declare and display a variable in Oracle

Examples related to oracle

Examples related to plsql

Examples related to oracle11g