Home » RDBMS Server » Server Administration » PL/SQL code
PL/SQL code [message #371142] Wed, 06 September 2000 08:01 Go to next message
stufi
Messages: 1
Registered: September 2000
Junior Member
I will ask for simple PL/SQL code:
i.e.
select name from emp where id=6;
can you say me for pl/sql code who is work it.
Thanks in advance

Report message to a moderator

Re: PL/SQL code [message #371173 is a reply to message #371142] Wed, 13 September 2000 01:03 Go to previous message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
Try this :-

SET SERVEROUTPUT ON
declare
l_name emp.name%type;
begin
select name into l_name from emp where id=6;
dbms_output.put_line('The name of id 6 is '||l_name);
end;

Report message to a moderator

Previous Topic: Need Query Help
Next Topic: Which is the best Microsoft SQLServer or Oracle ??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 23 10:15:05 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.