So i have to make a calculation in pl/sql and i dont think im that far off. The code im trying is:
declare
v_pnr varchar2(13);
v_fnamn varchar2(20);
v_enamn varchar2(20);
begin
select to_char(sysdate,'YYYY-MM-DD') - substr(pnr,1,8),fnamn,enamn
into v_pnr,v_fnamn,v_enamn
from bilägare;
dbms_output.put_line('Namn: '||v_fnamn||', '||'Efternamn: '||v_enamn||', '||'Ålder: '||v_pnr);
end;
The first 8 characters of pnr should be subtracted with sysdate. Maybe i need some form of for loop of cursor loop? Any help would be appreciated