How to view variable and constant value
715920Aug 25 2009 — edited Aug 25 2009Hi there,
I try to view a variable in sql plus command line and oracle xe object browser. The following is a small code to assign a value to a variable from an existing column name id that has value 4567 from table airplane. I'm a newbie, so pardon my ignorance:
declare new_num number;
begin
select id into new_num from airplane where id=4567;
end;
/
Questions:
1. Anything wrong with the code?
2. How can I view it via sql plus command line?
3. Can I view it from Oracle XE object browser gui?
Regards,
Valerie