Newer
Older
LaTeX / listings / lstlangansisql.sty
Nigel Stanger on 12 Sep 2016 4 KB Merge commit '7e71120' as 'listings'
\lst@definelanguage[SQL86]{SQL}%
{	morekeywords={all,and,any,as,asc,authorization,avg,between,by,char,character,%
		close,cobol,commit,count,create,current,cursor,dec,decimal,declare,delete,%
		desc,distinct,double,escape,exists,fetch,float,for,fortran,from,grant,%
		group,having,in,indicator,insert,int,integer,into,is,language,like,max,%
		min,module,not,null,numeric,of,on,open,option,or,order,pascal,pli,%
		precision,privileges,procedure,public,real,rollback,schema,select,%
		set,smallint,some,sqlcode,sum,table,union,unique,update,user,values,%
		view,where,with,work},%
	sensitive=false,%
	morecomment=[l]--,%
	morestring=[b]'%
}[keywords,comments,strings]

\lst@definelanguage[SQL89]{SQL}[SQL86]{SQL}%
{	morekeywords={ begin,check,continue,default,end,end-exec,exec,foreign,found,%
		go,goto,key,primary,references,section,sql,sqlerror,to,whenever},%
	sensitive=false%
}[keywords]

\lst@definelanguage[SQL92]{SQL}[SQL89]{SQL}%
{	morekeywords={absolute,action,ada,add,allocate,alter,are,assertion,at,bit,%
		bit_length,both,c,cascade,cascaded,case,cast,catalog,catalog_name,%
		character_length,character_set_catalog,character_set_name,%
		character_set_schema,char_length,class_origin,coalesce,collate,%
		collation,collation_catalog,collation_name,collation_schema,column,%
		column_name,command_function,committed,condition_number,connect,%
		connection,connection_name,constraint,constraints,constraint_catalog,%
		constraint_name,constraint_schema,convert,corresponding,cross,%
		current_date,current_time,current_timestamp,current_user,cursor_name,%
		data,date,datetime_interval_code,datetime_interval_precision,day,%
		deallocate,deferrable,deferred,describe,descriptor,diagnostics,%
		disconnect,domain,drop,dynamic_function,else,except,exception,%
		execute,external,extract,false,first,full,get,global,hour,identity,%
		immediate,initially,inner,input,insensitive,intersect,interval,%
		isolation,join,last,leading,left,length,level,local,lower,match,%
		message_length,message_octet_length,minute,month,more,mumps,name,%
		names,national,natural,nchar,next,no,nullable,nullif,number,octet_length,%
		only,outer,output,overlaps,pad,partial,position,prepare,preserve,prior,%
		read,relative,repeatable,restrict,returned_length,returned_octet_length,%
		returned_sqlstate,revoke,right,rows,row_count,scale,schema_name,scroll,%
		second,serializable,server_name,session,session_user,size,space,sqlstate,%
		subclass_origin,substring,system_user,table_name,temporary,then,time,%
		timestamp,timezone_hour,timezone_minute,trailing,transaction,translate,%
		translation,trim,true,type,uncommitted,unknown,unnamed,upper,usage,%
		using,value,varchar,varying,when,write,year,zone},%
	sensitive=false,%
	morestring=[b]"%
}[keywords,strings]

\lst@definelanguage[SQL99]{SQL}[SQL92]{SQL}%
{	deletekeywords={sqlcode,sqlerror},%
	morekeywords={abs,admin,after,aggregate,alias,array,asensitive,assignment,%
		asymmetric,atomic,before,binary,bitvar,blob,blocked,boolean,breadth,%
		call,cardinality,chain,characteristics,checked,class,clob,%
		command_function_code,completion,concatenate,condition,constructor,%
		contains,control,cube,current_path,current_role,cycle,datalink,db,%
		depth,deref,destroy,destructor,deterministic,dictionary,dispatch,%
		dlcomment,dlfilesize,dlfilesizeexact,dllinktype,dlurlcomplete,%
		dlurlpath,dlurlpathonly,dlurlschema,dlurlserver,dlvalue,do,dynamic,%
		dynamic_function_code,each,elseif,equals,every,existing,exit,expand,%
		expanding,file,final,free,function,general,generated,grouping,handler,%
		hash,hold,host,if,ignore,infix,initialize,inout,instantiable,integrity,%
		iterate,key_member,key_type,large,lateral,leave,less,limit,link,%
		localtime,localtimestamp,locator,loop,meets,message_text,method,%
		mod,modifies,modify,nclob,new,none,normalize,object,off,old,operation,%
		options,ordering,ordinality,out,overlay,overriding,parameter,parameters,%
		parameter_mode,parameter_ordinal_position,parameter_specific_catalog,%
		parameter_specific_name,parameter_specific_schema,path,period,permission,%
		postfix,precedes,prefix,preorder,reads,recovery,recursive,redo,ref,%
		referencing,repeat,resignal,restore,result,return,returns,role,rollup,%
		routine,routine_catalog,routine_name,routine_schema,row,row_type_catalog,%
		row_type_name,row_type_schema,savepoint,search,selective,self,sensitive,%
		sequence,sets,signal,similar,simple,source,specific,specifictype,%
		specific_name,sqlexception,sqlwarning,start,state,static,structure,%
		style,sublist,succeeds,symmetric,system,terminate,than,%
		transactions_committed,transactions_rolled_back,transaction_active,%
		transform,treat,trigger,trigger_catalog,trigger_name,trigger_schema,%
		under,undo,unlink,until,user_defined_type_catalog,user_defined_type_name,%
		user_defined_type_schema,variable,while,without,yes}%
}[keywords]