Hi... I'm trying to retrieve the records whose check out dates match with the system date(A hotel room reservation software). But I'm getting the following error java.sql.SQLException: ORA-01722: invalid number
Please read both of these pages (and the complete JDBC tutorial, if you haven't done so yet) before you try to write another database code - it will help you avoid many database-related problems. Of course, if something is unclear to you in the tutorial, feel free to ask questions here - we'll happily answer questions from people that read tutorials
Just one extra point to add to Martin's excellent advice:
You appear to be using your SYSTEM schema to hold these user tables. Do not do this. You should create a separate user schema for your application tables, and connect to the DB using that. The SYSTEM user has all kinds of extra privileges that you really do not want your application users to have access to. Also, until your run your application with the right user you cannot be sure you have set up access privileges etc properly.