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 SQL view with APEX item as the join condition||4||47|
|Need help with Oracle sql and I am using Aqua studio.||8||71|
|Pfile and SPfile - Oracle||2||52|
|File generation using utl_file||4||45|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
6 Experts available now in Live!