Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
select * from transaction where trans_date >= :p1 and trans_date <= :p2 and acc_no = :p3
it not accept it
select op_bal from acc_bal where acc_no=:p3 and year = (select to_char(:p1,'yyyy') from dual)
it also not accept it
and year = (select extract(year from :p1) from dual)
Join the community of 500,000 technology professionals and ask your questions.