File: jobserve.xsql

package info (click to toggle)
xmlstarlet 1.0.1-2
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k, lenny
  • size: 2,164 kB
  • ctags: 389
  • sloc: ansic: 4,578; sh: 3,109; xml: 1,821; makefile: 92
file content (8 lines) | stat: -rw-r--r-- 306 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
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>