After you have completed your XSQL file, you should check your XML syntax and then run it.
To run an XSQL servlet file:
JDeveloper will scan the XSQL file looking for XML syntax errors and display the results in the Log window.
JDeveloper compiles the servlet. It then starts its built-in OC4J web server, launches your default web browser, and displays the output of the servlet in the browser.
Creating an XSQL File
Formatting XML Data with a Style Sheet
Viewing Output from Running XSQL Files as Raw XML Data