diff options
Diffstat (limited to 'examples/xsql/jobserve.xsql')
| -rw-r--r-- | examples/xsql/jobserve.xsql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/examples/xsql/jobserve.xsql b/examples/xsql/jobserve.xsql new file mode 100644 index 0000000..13dacf8 --- /dev/null +++ b/examples/xsql/jobserve.xsql @@ -0,0 +1,8 @@ +<?xml version="1.0"?> +<?xml-stylesheet type="text/xsl" href="jobserve.xsl"?> +<xsql:query connection="jobs" xmlns:xsql="urn:oracle-xsql" max-rows="5"> + SELECT substr(title,1,26) short_title, title, location, skills + FROM job + WHERE UPPER(title) LIKE '%ORACLE%' + ORDER BY first_posted DESC +</xsql:query> |