SQL & PL/SQL

Good day all ,
I am designing a dynamic cursor , which will calculate the fiscal year , when a date parameter (SYYYY) is passed .
Any suggestions are highly appreciated .
Thanks


begin

v_crt_tbl := 'Create table TMP_FY'||trim(v_fiscal_year) ||
' as select * from tmp_FY2010 where 1=2 ' ;


Execute immediate v_crt_tbl ;

This creates the dynamic table , i want to pass the date field for v_fiscal_year , once this is done it will automaically calculate the fedral fiscal year .

Thanks

Edited by: 903537 on Dec 28, 2011 8:34 AM