User:DrewJensen/SQL Colors
From Apache OpenOffice Wiki
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