File: jobserve.xsql

package info (click to toggle)
xmlstarlet 1.6.1-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 2,412 kB
  • ctags: 656
  • sloc: sh: 4,735; ansic: 4,183; xml: 1,936; makefile: 70; awk: 43
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>