Skip to Content
0
Former Member
Jun 10, 2009 at 01:43 PM

Pl sql

30 Views

Hi Can I use a pl sql statement like this one to get a report out of CRXI?

I tried to use next code, but It failed.

Declare

v_name varchar2(8);

Begin

Select dhname into v_name

from table1

where dhname like 'ZFN0001';

dbms_output.put_line('Name: '||v_name);

end;

/

Thanks

Maria