Default Value using a PL/SQL expression
474531Mar 7 2006 — edited Mar 28 2006Hi! I have a select list and I want to set the default value. I tried a lot of examples, searched on forum, but still didn't solve nothing. Here are some examples that I tried:
BEGIN
select id_employee into :P10_ID_EMPLYEE
from employees
where LOWER(username) = LOWER(:APP_USER);
END;
OR
DECLARE
this_id NUMBER;
BEGIN
select id_employee into this_id
from employees
where LOWER(username) = LOWER(:APP_USER);
END;
There are more examples that didn't work.
Can someone give me a valid example, please?
P.S. Is it possible to have a display and a return value for this default value?
Thanks!
Vitaly