We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
|ORA-06502: PL/SQL: numeric or value error: character to number conversion error||4||127|
|populate value based on what is selected in lov||2||66|
|PL SQL Create ddl for all user objects, cant use dbms_metadata.get_ddla||19||69|
|Force XMLSEQUENCE to return empty tags for null values.||10||46|
Join the community of 500,000 technology professionals and ask your questions.