Ready to get started with anonymous questions today? It's easy! Learn more.
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)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.