insert into fnf_css_score

select b.itemabbrnm, a.gicode,
rank() over ( ORDER BY sales1) sales1_rank, sales1,
rank() over ( ORDER BY oper_profit1 ) oper_profit1_rank, oper_profit1,
rank() over ( ORDER BY oper_profit1_chg ) oper_profit3_rank, oper_profit1_chg,
rank() over ( ORDER BY oper_profit5 ) oper_profit5_rank, oper_profit5,
rank() over ( ORDER BY oper_profit6 ) oper_profit6_rank, oper_profit6,
rank() over ( ORDER BY net_profit1 ) net_profit1_rank, net_profit1,
rank() over ( ORDER BY net_profit1_chg ) net_profit3_rank, net_profit1_chg,
rank() over ( ORDER BY net_profit5 ) net_profit5_rank, net_profit5,
rank() over ( ORDER BY net_profit6 ) net_profit6_rank, net_profit6,
rank() over ( ORDER BY eps1 ) eps1_rank, eps1,
rank() over ( ORDER BY eps1_chg ) eps3_rank, eps1_chg,
rank() over ( ORDER BY divid_yield_rt ) divid_yield_rt_rank, divid_yield_rt,
rank() over ( ORDER BY pbr_roe ) pbr_roe_rank, pbr_roe
from fnf_npc_css_scoring_mast a, fns_j_mast b
where a.gicode = b.gicode

PL/SQL로 SP를 만들려고 하는데 오라클 버전이 낮아서 rank() over함수가 안돼네요...

이것을 어찌해야 하나요.. --;

sql문을 string 형태로 바꿔서 실행을 하면 된다는데..

대충은 알것 같은데 정확히 모르겠네요..

sql := ' sql구문?'

exec sql;

이렇게 하면 되나요?

좀 자세히 설명좀 해주셨으면....

감사하겠습니다.

and a.std_dt = '20041104')