Devshed has added a new bbcode called “highlighter” which is used for generic syntax highlighting. It supports generic SQL and Specific Oracle SQL syntax highlighting.

Usage :
[ highlight=language ]
Codes
[ /highlight ]

Sample generic SQL statement highlighting:
sql Code:
CREATE TABLE multiple_ids (
  `name` VARCHAR(50)) NOT NULL DEFAULT '',
  `id` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY(`name`, `id`)
)

Sample Oracle specific syntax highlighting:
oracle8 Code:
CREATE PROCEDURE addtuple3(a NUMBER, b OUT NUMBER)
AS
BEGIN
    b := 4;
    INSERT INTO T3 VALUES(a, b);
END;