Originally posted by Sunny Jain:
Here PL/SQL queries means simple select,delete, update and insert statement, I can not create a procedure with those queries and also I can not hard code them into JAVA code, I am looking for a best place to keep those queries..
O'rite. Actually, I got confused a bit, because for those we just normally use the
word "SQL queries", instead. The word PL/SQL sounds procedural to me and I start thinking of procedures, cursors, triggers etc.. However, the properties file sounds better in your case, as already suggested by a few folks.