User:DrewJensen/SQL Colors

From Apache OpenOffice Wiki
Jump to: navigation, search

OOo Wiki language highlighting

Lang = SQL

SELECT 
  "ID_Number" AS "ID", 
  CONCAT( "FirstName", CONCAT( ' ', "Surname")) AS "Name", 
  TO_CHAR( "DOB", 'D - MON, dd YYYY' ) AS "DOB",
  '100 Some st' || CHAR( 13 ) || 'Anytown, MD 111111'  AS "Address" 
FROM "Patient" 
WHERE "ID_Number" < 5

Lang = mysql

SELECT 
  "ID_Number" AS "ID", 
  CONCAT( "FirstName", CONCAT( ' ', "Surname")) AS "Name", 
  TO_CHAR( "DOB", 'D - MON, dd YYYY' ) AS "DOB",
  '100 Some st' || CHAR( 13 ) || 'Anytown, MD 111111'  AS "Address" 
FROM "Patient" 
WHERE "ID_Number" < 5

Lang = TSQL

SELECT 
  "ID_Number" AS "ID", 
  CONCAT( "FirstName", CONCAT( ' ', "Surname")) AS "Name", 
  TO_CHAR( "DOB", 'D - MON, dd YYYY' ) AS "DOB",
  '100 Some st' || CHAR( 13 ) || 'Anytown, MD 111111'  AS "Address" 
FROM "Patient" 
WHERE "ID_Number" < 5

Lang = plsql

SELECT 
  "ID_Number" AS "ID", 
  CONCAT( "FirstName", CONCAT( ' ', "Surname")) AS "Name", 
  TO_CHAR( "DOB", 'D - MON, dd YYYY' ) AS "DOB",
  '100 Some st' || CHAR( 13 ) || 'Anytown, MD 111111'  AS "Address" 
FROM "Patient" 
WHERE "ID_Number" < 5

Lang = oracle8

SELECT 
  "ID_Number" AS "ID", 
  CONCAT( "FirstName", CONCAT( ' ', "Surname")) AS "Name", 
  TO_CHAR( "DOB", 'D - MON, dd YYYY' ) AS "DOB",
  '100 Some st' || CHAR( 13 ) || 'Anytown, MD 111111'  AS "Address" 
FROM "Patient" 
WHERE "ID_Number" < 5

Lang = oobas

SELECT 
  "ID_Number" AS "ID", 
  CONCAT( "FirstName", CONCAT( ' ', "Surname")) AS "Name", 
  TO_CHAR( "DOB", 'D - MON, dd YYYY' ) AS "DOB",
  '100 Some st' || CHAR( 13 ) || 'Anytown, MD 111111'  AS "Address" 
FROM "Patient" 
WHERE "ID_Number" < 5
Personal tools