File: jobserve.xsql

package info (click to toggle)
xmlstarlet 1.0.0-1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 2,036 kB
  • ctags: 383
  • sloc: ansic: 4,500; sh: 3,109; xml: 1,821; makefile: 95
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>