|
Re: regarding Name-in and copy built-ins [message #22844 is a reply to message #22836] |
Fri, 01 November 2002 05:49 |
balu
Messages: 23 Registered: March 2001
|
Junior Member |
|
|
Hai,
I will explain those two things with a small
example
declare
lvname varchar2(21);
test number;
l number;
begin
:global.test:=10;
lvname:='global.test';
L:=to_number(name_in(lvname));
message('The value OF L IS'||L);
copy(20,lvname);
message('The value OF GLOBAL.TEST IS '||:GLOBAL.TEST);
end;
The output for the above pl-sql is
The value of L is 10
The value of global.test is 20
I think from the above example, u can clearly
understand the functions of name_in and copy
If u still have doubt, ask me I will explain in depth.
With luv,
Balamurugan.R
|
|
|