Home » SQL & PL/SQL » SQL & PL/SQL » select , into (oracle 9i)
select , into [message #358039] Fri, 07 November 2008 20:47 Go to next message
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
Re: select , into [message #358040 is a reply to message #358039] Fri, 07 November 2008 21:09 Go to previous messageGo to next message
fairgame
Messages: 29
Registered: October 2008
Junior Member
SET SERVEROUTPUT ON
Re: select , into [message #358041 is a reply to message #358040] Fri, 07 November 2008 21:12 Go to previous message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
thanks fairgame
its working....... Cool
Previous Topic: VIEW not showing all fields
Next Topic: can i add a new column in the middle of a table
Goto Forum:
  


Current Time: Fri Dec 09 19:50:54 CST 2016

Total time taken to generate the page: 0.12736 seconds