home *** CD-ROM | disk | FTP | other *** search
/ io Programmo 27 / IOPROG_27.ISO / SOFT / TSYNTAX.ZIP / Scripts.ZIP / SQL.txt < prev    next >
Encoding:
Text File  |  1998-10-12  |  23.8 KB  |  495 lines
  1. #define st_DEFAULT                     0
  2. #define st_COMMENT                     1
  3. #define st_IDENTIFIER                  2
  4. #define st_STRING                      3
  5. #define st_NUMBER                      4
  6. #define st_SYMBOL                      5
  7. #define st_SQLRESERVED                 6
  8. #define st_PLSQLRESERVED               7
  9. #define st_SQLFUNCTION                 8
  10. #define st_DEFAULTPACKAGE              9
  11. #define st_DEFAULTEXCEPTION           10
  12. #define st_DEFAULTPACKAGEEXCEPTION    11
  13. #define st_COMMENT_LINE               12
  14. #define st_COMMENT_STAR               13
  15. #define st_RESERVED                   14
  16. #define st_EXCEPTION                  15
  17. #define st_CONSTANT                   16
  18. #define st_DEFAULTPACKAGECONSTANT     17
  19. #define st_DATATYPE                   18
  20. #define st_SQLDATATYPE                19
  21. #define st_PLSQLDATATYPE              20
  22. #define st_DEFAULTPACKAGEDATATYPE     21
  23. #define st_TABLENAMES                 22
  24. #define st_USERPROCEDURES             23
  25.  
  26. #define _non_alpha_                 '[^_A-Za-z0-9]'
  27. #define _all_chars_                 '[\x00-\xFF]'
  28. #define _no_chars_                  '[]'
  29. #define _dont_care_                 _all_chars_
  30. #define _DEFAULT_BACKGROUND         clWhite
  31. #define _DEFAULT_FOREGROUND         clBlack
  32. #define ss_D1  200
  33. #define ss_D2  201
  34. #define ss_D3  202
  35. #define ss_D4  203
  36.  
  37. %%language
  38. StartState                = [0, ss_D1, ss_D2, ss_D3, ss_D4]
  39. Name                      = 'PL/SQL'
  40. Case                      = __INSENSITIVE
  41. Options                   = __DEFAULT_OPTIONS
  42. WordWrapColumn            = _EDGE
  43. Gutter                    = _DEFAULT_GUTTER
  44. Anchor                    = _DEFAULT_START_ANCHOR
  45. IndentStep                = 1
  46. FontName                  = 'Courier New'
  47. FontSize                  = 10
  48. ExampleText               = '\DECLARE\n\
  49.                             \  c_ausw_nr  CONSTANT VARCHAR2(4) := \'14\';\n\
  50.                             \  v_book     book%ROWTYPE;\n\
  51.                             \ \n\
  52.                             \BEGIN\n\
  53.                             \  DELETE FROM commercial\n\
  54.                             \END;\n'
  55.  
  56. EditableStyles              ('Reserved word', st_RESERVED),
  57.                             ('SQL Functions', st_SQLFUNCTION),
  58.                             ('Default Packages', st_DEFAULTPACKAGE),
  59.                             ('Exceptions',    st_EXCEPTION),
  60.                             ('Comment',       st_COMMENT),
  61.                             ('Identifier',    st_IDENTIFIER),
  62.                             ('String',        st_STRING),
  63.                             ('Number',        st_NUMBER),
  64.                             ('Symbols',       st_SYMBOL),
  65.                             ('Datatypes',     st_DATATYPE),
  66.                             ('Table Names',   st_TABLENAMES),
  67.                             ('Sql Reserved',   st_SQLRESERVED),
  68.                             ('PLSql Reserved',   st_PLSQLRESERVED),
  69.                             ('Default Exceptions',   st_DEFAULTEXCEPTION),
  70.                             ('User Procedures',   st_USERPROCEDURES),
  71.                             ('Default',       st_DEFAULT)
  72.  
  73.  
  74. %%handler
  75. st_COMMENT_LINE         '[^\n]'?                    '\n'           _discard_
  76. st_COMMENT_STAR         _all_chars_?                '*/'           _use_
  77.  
  78. %%tokens
  79. st_STRING               __STD_PASCALSTRING
  80. st_STRING               __STD_C_STRING
  81. st_NUMBER               __STD_NUMBER_OR_FP
  82. st_IDENTIFIER           __STD_IDENTIFIER
  83.  
  84. %%map
  85. st_DEFAULT                              st_DEFAULT
  86. st_IDENTIFIER                           st_IDENTIFIER
  87. st_STRING                               st_STRING
  88. st_COMMENT                              st_COMMENT
  89. st_COMMENT_LINE                         st_COMMENT
  90. st_COMMENT_STAR                         st_COMMENT
  91. st_SQLRESERVED                          st_RESERVED
  92. st_PLSQLRESERVED                        st_RESERVED
  93. st_SQLFUNCTION                          st_SQLFUNCTION
  94. st_DEFAULTPACKAGE                       st_DEFAULTPACKAGE
  95. st_DEFAULTPACKAGEEXCEPTION              st_EXCEPTION
  96. st_DEFAULTEXCEPTION                     st_EXCEPTION
  97. st_SYMBOL                               st_SYMBOL
  98. st_NUMBER                               st_NUMBER
  99. st_CONSTANT                             st_CONSTANT
  100. st_DEFAULTPACKAGECONSTANT               st_CONSTANT
  101. st_DEFAULTPACKAGEDATATYPE               st_DATATYPE
  102. st_SQLDATATYPE                          st_DATATYPE
  103. st_PLSQLDATATYPE                        st_DATATYPE
  104. st_DATATYPE                             st_DATATYPE
  105. st_TABLENAMES                           st_TABLENAMES
  106. st_USERPROCEDURES                       st_USERPROCEDURES
  107.  
  108. %%effects
  109. st_DEFAULT          []          _DEFAULT_FOREGROUND   _DEFAULT_BACKGROUND
  110. st_IDENTIFIER       []          clBlack               _DEFAULT_BACKGROUND
  111. st_STRING           []          clRed                 _DEFAULT_BACKGROUND
  112. st_COMMENT          [fsItalic]  clGreen               _DEFAULT_BACKGROUND
  113. st_RESERVED         []          clBlue                _DEFAULT_BACKGROUND
  114. st_SQLFUNCTION      []          _DEFAULT_FOREGROUND   _DEFAULT_BACKGROUND
  115. st_DEFAULTPACKAGE   []          clblue                _DEFAULT_BACKGROUND
  116. st_EXCEPTION        []          clred                 _DEFAULT_BACKGROUND
  117. st_NUMBER           []          clMaroon              _DEFAULT_BACKGROUND
  118. st_SYMBOL           []          clBlue                _DEFAULT_BACKGROUND
  119. st_DATATYPE         []          clRed                 _DEFAULT_BACKGROUND
  120. st_CONSTANT         []          _DEFAULT_FOREGROUND   _DEFAULT_BACKGROUND
  121. st_TABLENAMES       []          clOlive              _DEFAULT_BACKGROUND
  122. st_USERPROCEDURES   []          clOlive              _DEFAULT_BACKGROUND
  123.  
  124.  
  125. %%autoreplace    ActionKeys    = ';,:=[]\n\t\s'
  126.         'NDF'         = 'NO_DATA_FOUND'
  127.         'teh'         = 'the'
  128.         '(c)'         = '⌐'
  129.         '(r)'         = '«'
  130.         '(tm)'        = 'Ö'
  131.  
  132.  
  133. %%kwtables
  134.   ForState [ss_D1] endswith _non_alpha_
  135.     ( st_SQLDATATYPE is  'FLOAT', 'LONG', 'INTEGER', 'CHAR', 'NUMBER',
  136.          'RAW', 'SMALLINT', 'VARCHAR', 'VARCHAR2'
  137.     )
  138.  
  139.   ForState [ss_D2] endswith _non_alpha_
  140.     ( st_TABLENAMES is  'TOAD_PLAN_TABLE'
  141.     )
  142.  
  143.   ForState [ss_D3] endswith _non_alpha_
  144.     ( st_USERPROCEDURES is  'UNKNOWN'
  145.     )
  146.  
  147. %%words
  148. '--'             _dont_care_       st_COMMENT_LINE
  149. '/*'             _dont_care_       st_COMMENT_STAR
  150. '!'              _dont_care_       st_SYMBOL
  151. '$'              _dont_care_       st_SYMBOL
  152. '%'              _dont_care_       st_SYMBOL
  153. '^'              _dont_care_       st_SYMBOL
  154. '&'              _dont_care_       st_SYMBOL
  155. '*'              _dont_care_       st_SYMBOL
  156. '('              _dont_care_       st_SYMBOL
  157. ')'              _dont_care_       st_SYMBOL
  158. '-'              _dont_care_       st_SYMBOL
  159. '='              _dont_care_       st_SYMBOL
  160. '+'              _dont_care_       st_SYMBOL
  161. '{'              _dont_care_       st_SYMBOL
  162. '}'              _dont_care_       st_SYMBOL
  163. '['              _dont_care_       st_SYMBOL
  164. ']'              _dont_care_       st_SYMBOL
  165. ':'              _dont_care_       st_SYMBOL
  166. ';'              _dont_care_       st_SYMBOL
  167. '@'              _dont_care_       st_SYMBOL
  168. '#'              _dont_care_       st_SYMBOL
  169. '~'              _dont_care_       st_SYMBOL
  170. '<'              _dont_care_       st_SYMBOL
  171. '>'              _dont_care_       st_SYMBOL
  172. ','              _dont_care_       st_SYMBOL
  173. '.'              _dont_care_       st_SYMBOL
  174. '/'              _dont_care_       st_SYMBOL
  175. '?'              _dont_care_       st_SYMBOL
  176. '\\'             _dont_care_       st_SYMBOL
  177. 'ACCESS'         _non_alpha_       st_SQLRESERVED
  178. 'ADD'            _non_alpha_       st_SQLRESERVED
  179. 'ALL'            _non_alpha_       st_SQLRESERVED
  180. 'ALTER'          _non_alpha_       st_SQLRESERVED
  181. 'AND'            _non_alpha_       st_SQLRESERVED
  182. 'ANY'            _non_alpha_       st_SQLRESERVED
  183. 'AS'             _non_alpha_       st_SQLRESERVED
  184. 'ASC'            _non_alpha_       st_SQLRESERVED
  185. 'AUDIT'          _non_alpha_       st_SQLRESERVED
  186. 'BETWEEN'        _non_alpha_       st_SQLRESERVED
  187. 'BY'             _non_alpha_       st_SQLRESERVED
  188. 'CHAR'           _non_alpha_       st_SQLDATATYPE
  189. 'CHECK'          _non_alpha_       st_SQLRESERVED
  190. 'CLUSTER'        _non_alpha_       st_SQLRESERVED
  191. 'COLUMN'         _non_alpha_       st_SQLRESERVED
  192. 'COMMENT'        _non_alpha_       st_SQLRESERVED
  193. 'COMPRESS'       _non_alpha_       st_SQLRESERVED
  194. 'CONNECT'        _non_alpha_       st_SQLRESERVED
  195. 'CREATE'         _non_alpha_       st_SQLRESERVED
  196. 'CURRENT'        _non_alpha_       st_SQLRESERVED
  197. 'DATE'           _non_alpha_       st_SQLRESERVED
  198. 'DECIMAL'        _non_alpha_       st_SQLRESERVED
  199. 'DEFAULT'        _non_alpha_       st_SQLRESERVED
  200. 'DELETE'         _non_alpha_       st_SQLRESERVED
  201. 'DESC'           _non_alpha_       st_SQLRESERVED
  202. 'DISTINCT'       _non_alpha_       st_SQLRESERVED
  203. 'DROP'           _non_alpha_       st_SQLRESERVED
  204. 'ELSE'           _non_alpha_       st_SQLRESERVED
  205. 'EXCLUSIVE'      _non_alpha_       st_SQLRESERVED
  206. 'EXISTS'         _non_alpha_       st_SQLRESERVED
  207. 'FILE'           _non_alpha_       st_SQLRESERVED
  208. 'FLOAT'          _non_alpha_       st_SQLDATATYPE
  209. 'FOR'            _non_alpha_       st_SQLRESERVED
  210. 'FROM'           _non_alpha_       st_SQLRESERVED
  211. 'GRANT'          _non_alpha_       st_SQLRESERVED
  212. 'GROUP'          _non_alpha_       st_SQLRESERVED
  213. 'HAVING'         _non_alpha_       st_SQLRESERVED
  214. 'IDENTIFIED'     _non_alpha_       st_SQLRESERVED
  215. 'IMMEDIATE'      _non_alpha_       st_SQLRESERVED
  216. 'IN'             _non_alpha_       st_SQLRESERVED
  217. 'INCREMENT'      _non_alpha_       st_SQLRESERVED
  218. 'INDEX'          _non_alpha_       st_SQLRESERVED
  219. 'INITIAL'        _non_alpha_       st_SQLRESERVED
  220. 'INSERT'         _non_alpha_       st_SQLRESERVED
  221. 'INTEGER'        _non_alpha_       st_SQLDATATYPE
  222. 'INTERSECT'      _non_alpha_       st_SQLRESERVED
  223. 'INTO'           _non_alpha_       st_SQLRESERVED
  224. 'IS'             _non_alpha_       st_SQLRESERVED
  225. 'LEVEL'          _non_alpha_       st_SQLRESERVED
  226. 'LIKE'           _non_alpha_       st_SQLRESERVED
  227. 'LOCK'           _non_alpha_       st_SQLRESERVED
  228. 'LONG'           _non_alpha_       st_SQLDATATYPE
  229. 'MAXEXTENTS'     _non_alpha_       st_SQLRESERVED
  230. 'MINUS'          _non_alpha_       st_SQLRESERVED
  231. 'MLSLABEL'       _non_alpha_       st_SQLRESERVED
  232. 'MODE'           _non_alpha_       st_SQLRESERVED
  233. 'NOAUDIT'        _non_alpha_       st_SQLRESERVED
  234. 'NOCOMPRESS'     _non_alpha_       st_SQLRESERVED
  235. 'NOT'            _non_alpha_       st_SQLRESERVED
  236. 'NOWAIT'         _non_alpha_       st_SQLRESERVED
  237. 'NULL'           _non_alpha_       st_SQLRESERVED
  238. 'NUMBER'         _non_alpha_       st_SQLDATATYPE
  239. 'OF'             _non_alpha_       st_SQLRESERVED
  240. 'OFFLINE'        _non_alpha_       st_SQLRESERVED
  241. 'ON'             _non_alpha_       st_SQLRESERVED
  242. 'ONLINE'         _non_alpha_       st_SQLRESERVED
  243. 'OPTION'         _non_alpha_       st_SQLRESERVED
  244. 'OR'             _non_alpha_       st_SQLRESERVED
  245. 'ORDER'          _non_alpha_       st_SQLRESERVED
  246. 'PCTFREE'        _non_alpha_       st_SQLRESERVED
  247. 'PRIOR'          _non_alpha_       st_SQLRESERVED
  248. 'PRIVILEGES'     _non_alpha_       st_SQLRESERVED
  249. 'PUBLIC'         _non_alpha_       st_SQLRESERVED
  250. 'RAW'            _non_alpha_       st_SQLDATATYPE
  251. 'RENAME'         _non_alpha_       st_SQLRESERVED
  252. 'REPLACE'        _non_alpha_       st_SQLRESERVED
  253. 'RESOURCE'       _non_alpha_       st_SQLRESERVED
  254. 'REVOKE'         _non_alpha_       st_SQLRESERVED
  255. 'ROW'            _non_alpha_       st_SQLRESERVED
  256. 'ROWID'          _non_alpha_       st_SQLRESERVED
  257. 'ROWLABEL'       _non_alpha_       st_SQLRESERVED
  258. 'ROWNUM'         _non_alpha_       st_SQLRESERVED
  259. 'ROWS'           _non_alpha_       st_SQLRESERVED
  260. 'SELECT'         _non_alpha_       st_SQLRESERVED
  261. 'SESSION'        _non_alpha_       st_SQLRESERVED
  262. 'SET'            _non_alpha_       st_SQLRESERVED
  263. 'SHARE'          _non_alpha_       st_SQLRESERVED
  264. 'SMALLINT'       _non_alpha_       st_SQLDATATYPE
  265. 'START'          _non_alpha_       st_SQLRESERVED
  266. 'SUCCESSFUL'     _non_alpha_       st_SQLRESERVED
  267. 'SYNONYM'        _non_alpha_       st_SQLRESERVED
  268. 'SYSDATE'        _non_alpha_       st_SQLRESERVED
  269. 'TABLE'          _non_alpha_       st_SQLRESERVED
  270. 'THEN'           _non_alpha_       st_SQLRESERVED
  271. 'TO'             _non_alpha_       st_SQLRESERVED
  272. 'TRIGGER'        _non_alpha_       st_SQLRESERVED
  273. 'UNION'          _non_alpha_       st_SQLRESERVED
  274. 'UNIQUE'         _non_alpha_       st_SQLRESERVED
  275. 'UPDATE'         _non_alpha_       st_SQLRESERVED
  276. 'VALIDATE'       _non_alpha_       st_SQLRESERVED
  277. 'VALUES'         _non_alpha_       st_SQLRESERVED
  278. 'VARCHAR'        _non_alpha_       st_SQLDATATYPE
  279. 'VARCHAR2'       _non_alpha_       st_SQLDATATYPE
  280. 'VIEW'           _non_alpha_       st_SQLRESERVED
  281. 'WHENEVER'       _non_alpha_       st_SQLRESERVED
  282. 'WHERE'          _non_alpha_       st_SQLRESERVED
  283. 'WITH'           _non_alpha_       st_SQLRESERVED
  284. 'ABORT'          _non_alpha_       st_PLSQLRESERVED
  285. 'ACCEPT'         _non_alpha_       st_PLSQLRESERVED
  286. 'ARRAY'          _non_alpha_       st_PLSQLRESERVED
  287. 'ARRAYLEN'       _non_alpha_       st_PLSQLRESERVED
  288. 'ASSERT'         _non_alpha_       st_PLSQLRESERVED
  289. 'ASSIGN'         _non_alpha_       st_PLSQLRESERVED
  290. 'AT'             _non_alpha_       st_PLSQLRESERVED
  291. 'AUTHORIZATION'  _non_alpha_       st_PLSQLRESERVED
  292. 'BASE_TABLE'     _non_alpha_       st_PLSQLRESERVED
  293. 'BEGIN'          _non_alpha_       st_PLSQLRESERVED
  294. 'BINARY_INTEGER'  _non_alpha_       st_PLSQLDATATYPE
  295. 'BODY'           _non_alpha_       st_PLSQLRESERVED
  296. 'BOOLEAN'        _non_alpha_       st_PLSQLDATATYPE
  297. 'CASE'           _non_alpha_       st_PLSQLRESERVED
  298. 'CHAR_BASE'      _non_alpha_       st_PLSQLRESERVED
  299. 'CLOSE'          _non_alpha_       st_PLSQLRESERVED
  300. 'CLUSTERS'       _non_alpha_       st_PLSQLRESERVED
  301. 'COLAUTH'        _non_alpha_       st_PLSQLRESERVED
  302. 'COMMIT'         _non_alpha_       st_PLSQLRESERVED
  303. 'CONSTANT'       _non_alpha_       st_PLSQLRESERVED
  304. 'CRASH'          _non_alpha_       st_PLSQLRESERVED
  305. 'CURRVAL'        _non_alpha_       st_PLSQLRESERVED
  306. 'CURSOR'         _non_alpha_       st_PLSQLRESERVED
  307. 'DATABASE'       _non_alpha_       st_PLSQLRESERVED
  308. 'DATA_BASE'      _non_alpha_       st_PLSQLRESERVED
  309. 'DBA'            _non_alpha_       st_PLSQLRESERVED
  310. 'DEBUGOFF'       _non_alpha_       st_PLSQLRESERVED
  311. 'DEBUGON'        _non_alpha_       st_PLSQLRESERVED
  312. 'DECLARE'        _non_alpha_       st_PLSQLRESERVED
  313. 'DEFINITION'     _non_alpha_       st_PLSQLRESERVED
  314. 'DELAY'          _non_alpha_       st_PLSQLRESERVED
  315. 'DIGITS'         _non_alpha_       st_PLSQLRESERVED
  316. 'DISPOSE'        _non_alpha_       st_PLSQLRESERVED
  317. 'DO'             _non_alpha_       st_PLSQLRESERVED
  318. 'ELSIF'          _non_alpha_       st_PLSQLRESERVED
  319. 'END'            _non_alpha_       st_PLSQLRESERVED
  320. 'ENTRY'          _non_alpha_       st_PLSQLRESERVED
  321. 'EXCEPTION'      _non_alpha_       st_PLSQLRESERVED
  322. 'EXCEPTION_INIT' _non_alpha_       st_PLSQLRESERVED
  323. 'EXIT'           _non_alpha_       st_PLSQLRESERVED
  324. 'FALSE'          _non_alpha_       st_PLSQLRESERVED
  325. 'FETCH'          _non_alpha_       st_PLSQLRESERVED
  326. 'FORM'           _non_alpha_       st_PLSQLRESERVED
  327. 'FUNCTION'       _non_alpha_       st_PLSQLRESERVED
  328. 'GENERIC'        _non_alpha_       st_PLSQLRESERVED
  329. 'GOTO'           _non_alpha_       st_PLSQLRESERVED
  330. 'IF'             _non_alpha_       st_PLSQLRESERVED
  331. 'INDEXES'        _non_alpha_       st_PLSQLRESERVED
  332. 'INDICATOR'      _non_alpha_       st_PLSQLRESERVED
  333. 'INTERFACE'      _non_alpha_       st_PLSQLRESERVED
  334. 'LIMITED'        _non_alpha_       st_PLSQLRESERVED
  335. 'LOOP'           _non_alpha_       st_PLSQLRESERVED
  336. 'NATURAL'        _non_alpha_       st_PLSQLRESERVED
  337. 'NATURALN'       _non_alpha_       st_PLSQLRESERVED
  338. 'NEW'            _non_alpha_       st_PLSQLRESERVED
  339. 'NEXTVAL'        _non_alpha_       st_PLSQLRESERVED
  340. 'NUMBER_BASE'    _non_alpha_       st_PLSQLRESERVED
  341. 'OPEN'           _non_alpha_       st_PLSQLRESERVED
  342. 'OUT'            _non_alpha_       st_PLSQLRESERVED
  343. 'PACKAGE'        _non_alpha_       st_PLSQLRESERVED
  344. 'PARTITION'      _non_alpha_       st_PLSQLRESERVED
  345. 'PLS_INTEGER'    _non_alpha_       st_PLSQLDATATYPE
  346. 'POSITIVE'       _non_alpha_       st_PLSQLRESERVED
  347. 'POSITIVEN'      _non_alpha_       st_PLSQLRESERVED
  348. 'PRAGMA'         _non_alpha_       st_PLSQLRESERVED
  349. 'PRIVATE'        _non_alpha_       st_PLSQLRESERVED
  350. 'PROCEDURE'      _non_alpha_       st_PLSQLRESERVED
  351. 'RAISE'          _non_alpha_       st_PLSQLRESERVED
  352. 'RANGE'          _non_alpha_       st_PLSQLRESERVED
  353. 'REAL'           _non_alpha_       st_PLSQLDATATYPE
  354. 'RECORD'         _non_alpha_       st_PLSQLRESERVED
  355. 'REF'            _non_alpha_       st_PLSQLRESERVED
  356. 'RELEASE'        _non_alpha_       st_PLSQLRESERVED
  357. 'REMR'           _non_alpha_       st_PLSQLRESERVED
  358. 'RESTRICT_REFERENCES'         _non_alpha_       st_PLSQLRESERVED
  359. 'RETURN'         _non_alpha_       st_PLSQLRESERVED
  360. 'REVERSE'        _non_alpha_       st_PLSQLRESERVED
  361. 'ROLLBACK'       _non_alpha_       st_PLSQLRESERVED
  362. 'ROWTYPE'        _non_alpha_       st_PLSQLRESERVED
  363. 'RUN'            _non_alpha_       st_PLSQLRESERVED
  364. 'SAVEPOINT'      _non_alpha_       st_PLSQLRESERVED
  365. 'SCHEMA'         _non_alpha_       st_PLSQLRESERVED
  366. 'SEPERATE'       _non_alpha_       st_PLSQLRESERVED
  367. 'SPACE'          _non_alpha_       st_PLSQLRESERVED
  368. 'SQL'            _non_alpha_       st_PLSQLRESERVED
  369. 'SQLCODE'        _non_alpha_       st_PLSQLRESERVED
  370. 'SQLERRM'        _non_alpha_       st_PLSQLRESERVED
  371. 'STATEMENT'      _non_alpha_       st_PLSQLRESERVED
  372. 'SUBTYPE'        _non_alpha_       st_PLSQLRESERVED
  373. 'TABAUTH'        _non_alpha_       st_PLSQLRESERVED
  374. 'TABLES'         _non_alpha_       st_PLSQLRESERVED
  375. 'TASK'           _non_alpha_       st_PLSQLRESERVED
  376. 'TERMINATE'      _non_alpha_       st_PLSQLRESERVED
  377. 'TRUE'           _non_alpha_       st_PLSQLRESERVED
  378. 'TYPE'           _non_alpha_       st_PLSQLRESERVED
  379. 'USE'            _non_alpha_       st_PLSQLRESERVED
  380. 'VIEWS'          _non_alpha_       st_PLSQLRESERVED
  381. 'WHEN'           _non_alpha_       st_PLSQLRESERVED
  382. 'WHILE'          _non_alpha_       st_PLSQLRESERVED
  383. 'WORK'           _non_alpha_       st_PLSQLRESERVED
  384. 'WRITE'          _non_alpha_       st_PLSQLRESERVED
  385. 'XOR'            _non_alpha_       st_PLSQLRESERVED
  386. 'TO_CHAR'        _non_alpha_       st_SQLFUNCTION
  387. 'TO_DATE'        _non_alpha_       st_SQLFUNCTION
  388. 'TO_NUMBER'      _non_alpha_       st_SQLFUNCTION
  389. 'ABS'            _non_alpha_       st_SQLFUNCTION
  390. 'ACOS'           _non_alpha_       st_SQLFUNCTION
  391. 'ASIN'           _non_alpha_       st_SQLFUNCTION
  392. 'ATAN'           _non_alpha_       st_SQLFUNCTION
  393. 'ATAN2'          _non_alpha_       st_SQLFUNCTION
  394. 'CEIL'           _non_alpha_       st_SQLFUNCTION
  395. 'COS'            _non_alpha_       st_SQLFUNCTION
  396. 'COSH'           _non_alpha_       st_SQLFUNCTION
  397. 'EXP'            _non_alpha_       st_SQLFUNCTION
  398. 'FLOOR'          _non_alpha_       st_SQLFUNCTION
  399. 'LN'             _non_alpha_       st_SQLFUNCTION
  400. 'LOG'            _non_alpha_       st_SQLFUNCTION
  401. 'MOD'            _non_alpha_       st_SQLFUNCTION
  402. 'POWER'          _non_alpha_       st_SQLFUNCTION
  403. 'ROUND'          _non_alpha_       st_SQLFUNCTION
  404. 'SIGN'           _non_alpha_       st_SQLFUNCTION
  405. 'SIN'            _non_alpha_       st_SQLFUNCTION
  406. 'SINH'           _non_alpha_       st_SQLFUNCTION
  407. 'SQRT'           _non_alpha_       st_SQLFUNCTION
  408. 'TAN'            _non_alpha_       st_SQLFUNCTION
  409. 'TANH'           _non_alpha_       st_SQLFUNCTION
  410. 'TRUNC'          _non_alpha_       st_SQLFUNCTION
  411. 'CHR'            _non_alpha_       st_SQLFUNCTION
  412. 'CONCAT'         _non_alpha_       st_SQLFUNCTION
  413. 'INITCAP'        _non_alpha_       st_SQLFUNCTION
  414. 'LOWER'          _non_alpha_       st_SQLFUNCTION
  415. 'LPAD'           _non_alpha_       st_SQLFUNCTION
  416. 'LTRIM'          _non_alpha_       st_SQLFUNCTION
  417. 'NLS_INITCAP'    _non_alpha_       st_SQLFUNCTION
  418. 'NLS_LOWER'      _non_alpha_       st_SQLFUNCTION
  419. 'NLS_UPPER'      _non_alpha_       st_SQLFUNCTION
  420. 'RPAD'           _non_alpha_       st_SQLFUNCTION
  421. 'RTRIM'          _non_alpha_       st_SQLFUNCTION
  422. 'SOUNDEX'        _non_alpha_       st_SQLFUNCTION
  423. 'SUBSTR'         _non_alpha_       st_SQLFUNCTION
  424. 'SUBSTRB'        _non_alpha_       st_SQLFUNCTION
  425. 'TRANSLATE'      _non_alpha_       st_SQLFUNCTION
  426. 'UPPER'          _non_alpha_       st_SQLFUNCTION
  427. 'ASCII'          _non_alpha_       st_SQLFUNCTION
  428. 'INSTR'          _non_alpha_       st_SQLFUNCTION
  429. 'INSTRB'         _non_alpha_       st_SQLFUNCTION
  430. 'LENGTH'         _non_alpha_       st_SQLFUNCTION
  431. 'LENGTHB'        _non_alpha_       st_SQLFUNCTION
  432. 'NLS_SORT'       _non_alpha_       st_SQLFUNCTION
  433. 'ADD_MONTHS'     _non_alpha_       st_SQLFUNCTION
  434. 'LAST_DAY'       _non_alpha_       st_SQLFUNCTION
  435. 'MONTHS_BETWEEN' _non_alpha_       st_SQLFUNCTION
  436. 'NEW_TIME'       _non_alpha_       st_SQLFUNCTION
  437. 'NEXT_DAY'       _non_alpha_       st_SQLFUNCTION
  438. 'CHARTOROWID'    _non_alpha_       st_SQLFUNCTION
  439. 'CONVERT'        _non_alpha_       st_SQLFUNCTION
  440. 'HEXTORAW'       _non_alpha_       st_SQLFUNCTION
  441. 'RAWTOHEX'       _non_alpha_       st_SQLFUNCTION
  442. 'ROWIDTOCHAR'    _non_alpha_       st_SQLFUNCTION
  443. 'TO_MULTI_BYTE'  _non_alpha_       st_SQLFUNCTION
  444. 'TO_SINGLE_BYTE' _non_alpha_       st_SQLFUNCTION
  445. 'USING'          _non_alpha_       st_SQLFUNCTION
  446. 'DUMP'           _non_alpha_       st_SQLFUNCTION
  447. 'EMPTY_BLOB'     _non_alpha_       st_SQLFUNCTION
  448. 'EMPTY_CLOB'     _non_alpha_       st_SQLFUNCTION
  449. 'BFILENAME'      _non_alpha_       st_SQLFUNCTION
  450. 'GREATEST'       _non_alpha_       st_SQLFUNCTION
  451. 'LEAST'          _non_alpha_       st_SQLFUNCTION
  452. 'NLS_CHARSET_DECL_LEN'   _non_alpha_       st_SQLFUNCTION
  453. 'NLS_CHARSET_ID'         _non_alpha_       st_SQLFUNCTION
  454. 'NLS_CHARSET_NAME'      _non_alpha_       st_SQLFUNCTION
  455. 'NVL'            _non_alpha_       st_SQLFUNCTION
  456. 'USER'           _non_alpha_       st_SQLFUNCTION
  457. 'UID'            _non_alpha_       st_SQLFUNCTION
  458. 'USERENV'        _non_alpha_       st_SQLFUNCTION
  459. 'VSIZE'          _non_alpha_       st_SQLFUNCTION
  460. 'AVG'            _non_alpha_       st_SQLFUNCTION
  461. 'COUNT'          _non_alpha_       st_SQLFUNCTION
  462. 'MAX'            _non_alpha_       st_SQLFUNCTION
  463. 'MIN'            _non_alpha_       st_SQLFUNCTION
  464. 'STDDEV'         _non_alpha_       st_SQLFUNCTION
  465. 'SUM'            _non_alpha_       st_SQLFUNCTION
  466. 'VARIANCE'       _non_alpha_       st_SQLFUNCTION
  467. 'DEREF'          _non_alpha_       st_SQLFUNCTION
  468. 'REFTOHEX'       _non_alpha_       st_SQLFUNCTION
  469. 'MAKE_REF'       _non_alpha_       st_SQLFUNCTION
  470. 'DECODE'         _non_alpha_       st_SQLFUNCTION
  471. 'RAISE_APPLICATION_ERROR'         _non_alpha_       st_DEFAULTPACKAGE
  472. 'INSERTING'         _non_alpha_       st_DEFAULTPACKAGE
  473. 'DELETING'         _non_alpha_       st_DEFAULTPACKAGE
  474. 'UPDATING'         _non_alpha_       st_DEFAULTPACKAGE
  475. 'SET_TRANSACTION_USE'           _non_alpha_       st_DEFAULTPACKAGE
  476. 'OTHERS'               _non_alpha_       st_DEFAULTEXCEPTION
  477. 'DUP_VAL_ON_INDEX'     _non_alpha_       st_DEFAULTEXCEPTION
  478. 'INVALID_CURSOR'       _non_alpha_       st_DEFAULTEXCEPTION
  479. 'INVALID_NUMBER'       _non_alpha_       st_DEFAULTEXCEPTION
  480. 'LOGIN_DENIED'         _non_alpha_       st_DEFAULTEXCEPTION
  481. 'NO_DATA_FOUND'        _non_alpha_       st_DEFAULTEXCEPTION
  482. 'NOT_LOGGED_ON'        _non_alpha_       st_DEFAULTEXCEPTION
  483. 'PROGRAM_ERROR'        _non_alpha_       st_DEFAULTEXCEPTION
  484. 'STORAGE_ERROR'        _non_alpha_       st_DEFAULTEXCEPTION
  485. 'TIMEOUT_ON_RESOURCE'  _non_alpha_       st_DEFAULTEXCEPTION
  486. 'TOO_MANY_ROWS'        _non_alpha_       st_DEFAULTEXCEPTION
  487. 'VALUE_ERROR'          _non_alpha_       st_DEFAULTEXCEPTION
  488. 'ACCESS_INTO_NULL'     _non_alpha_       st_DEFAULTEXCEPTION
  489. 'COLLECTION_IS_NULL'        _non_alpha_  st_DEFAULTEXCEPTION
  490. 'SUBSCRIPT_OUTSIDE_LIMIT'   _non_alpha_  st_DEFAULTEXCEPTION
  491. 'SUBSCRIPT_BEYOND_COUNT'    _non_alpha_  st_DEFAULTEXCEPTION
  492. 'ZERO_DIVIDE'          _non_alpha_       st_DEFAULTEXCEPTION
  493. 'CURSOR_ALREADY_OPEN'  _non_alpha_       st_DEFAULTEXCEPTION
  494.  
  495.