BNF Index of PL SQL version 2.1 for Oracle 7

index on key words

index on special characters

plsql_block nice to start

plsql_store_in_db to handle objects in database


[other languages BNF]

index of rules

  1. alias
  2. alter_function
  3. alter_package
  4. alter_procedure
  5. argument
  6. argument_name
  7. argument_type
  8. assignment_statement
  9. boolean_exp
  10. boolean_factor
  11. boolean_literal
  12. boolean_term
  13. char_expression
  14. char_literal
  15. char_term
  16. close_statement
  17. column_list
  18. column_name
  19. comment
  20. commit_statement
  21. create_function
  22. create_package
  23. create_procedure
  24. create_trigger
  25. cursor_body
  26. cursor_declaration
  27. cursor_loop_param
  28. cursor_name
  29. cursor_spec
  30. datatype
  31. date_expression
  32. date_literal
  33. declare_spec
  34. delete_statement
  35. drop_function
  36. drop_package
  37. drop_procedure
  38. error_number
  39. exception_declaration
  40. exception_handler
  41. exception_name
  42. exception_pragma
  43. exit_statement
  44. fetch_statement
  45. field_name
  46. field_spec
  47. function
  48. function_body
  49. function_declaration
  50. function_name
  51. function_spec
  52. goto_statement
  53. host_variable
  54. if_statement
  55. index_name
  56. insert_statement
  57. integer_expr
  58. label_name
  59. link_name
  60. lock_mode
  61. lock_table_statement
  62. loop_statement
  63. match_string
  64. n
  65. null_statement
  66. number
  67. numeric_literal
  68. numeric_loop_param
  69. num_expression
  70. num_factor
  71. num_term
  72. object
  73. open_statement
  74. package_body
  75. package_name
  76. package_obj_body
  77. package_obj_spec
  78. package_spec
  79. parameter_name
  80. parameter_spec
  81. plsql_block
  82. plsql_condition
  83. plsql_expression
  84. plsql_exp_list
  85. plsql_store_in_db
  86. plsql_table_declaration
  87. plsql_table_name
  88. procedure_body
  89. procedure_declaration
  90. procedure_name
  91. procedure_spec
  92. quoted_string
  93. raise_statement
  94. record_declaration
  95. record_name
  96. record_type_dec
  97. record_var_dec
  98. reference_pragma
  99. relational_op
  100. return_statement
  101. return_type
  102. rollback_statement
  103. savepoint_name
  104. savepoint_statement
  105. schema_name
  106. search_condition
  107. select_statement
  108. seq_of_statements
  109. set_transaction_statement
  110. simple_update
  111. sql_item
  112. sql_rest_of_select
  113. sql_statement
  114. sql_subquery
  115. statement
  116. subquery_update
  117. subscript
  118. subtype_declaration
  119. table_name
  120. table_reference
  121. table_type_dec
  122. table_var_dec
  123. trigger_ref
  124. trigger_sync
  125. trigger_when
  126. type_name
  127. type_spec
  128. update_statement
  129. value
  130. variable_declaration
  131. variable_name
  132. variable_type
  133. view_name

Jacques Guyot | guyot@cui.unige.ch