OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » select , into (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select , into [message #358039]

Fri, 07 November 2008 20:47

modhiyakomal
Messages: 49
Registered: November 2008
Location: US

Member

Hi All,
when i write code as shown below, it says pl/sql procedure successfully completed, but how i get output?

SQL> declare emp_name emp.ename%type;
2 begin
3 select ename into emp_name
4 from emp
5 where empno=7369;
6 dbms_output.put_line(emp_name);
7 end;
8 /

PL/SQL procedure successfully completed.

thanks

Report message to a moderator