separate sql queries in .sql files without giving any explicit escape character
i am trying to have jdbc connectivity between the application and database. The queries and the pl/sql blocks to be executed are put in several .sql files. The problem is how to split the queries / pl/sql blocks because the delimiter ( ; ) is not ony occuring at the end of the statement but also within the statements also. so in this case , am not able to split a complete sql block or query. I can use a escape character and accomplish the task but i dont want to do that as there are many .sql files. Jdbc also accepts only 1 query at a time. is there any way i can handle this issue. thanks in advance!!!!