rest.static.js.ace-code-editor.snippets.sql.js Maven / Gradle / Ivy

Go to download
/**
 * Drill SQL Syntax Snippets
 */

ace.define("ace/snippets/sql",["require","exports","module"], function(require, exports, module) {
"use strict";

exports.snippetText = "snippet info\n\
	select * from INFORMATION_SCHEMA.${1:};\n\
snippet sysmem\n\
	select * from sys.memory;\n\
snippet sysopt\n\
	select * from sys.options;\n\
snippet sysbit\n\
	select * from sys.drillbits;\n\
snippet sysconn\n\
	select * from sys.connections;\n\
snippet sysprof\n\
	select * from sys.profiles;\n\
snippet cview\n\
	create view ${1:[workspace]}.${2:} ( ${3:} )  as \n\
	${4:};\n\
snippet ctas\n\
	create table ${1:} ( ${2:} )  as \n\
	${3:};\n\
snippet ctemp\n\
	create temporary table ${1:} ( ${2:} )  as \n\
	${3:};\n\
snippet cfnjar\n\
	create function using jar '${1:}.jar';\n\
snippet alt\n\
	alter session set `${1:}` = ${2:};\n\
snippet reset\n\
	alter session reset `${1:}`;\n\
snippet explain\n\
	explain plan for\n\
	${1:};\n\
snippet s*\n\
	select *\n\
	from ${1:}\n\
	where ${2:};\n\
snippet cast\n\
	cast(${1:} AS ${2:}) ${3:}\n\
";

exports.scope = "sql";

});