![]() ![]() You can specify the following values for SQLCHECK: However, SQLCHECK cannot check dynamic SQL statements because they are not defined fully until run time. The extent of checking can include data manipulation statements and PL/SQL blocks. With SQLCHECK, the type of checking can be syntactic, semantic, or both. You control the type and extent of checking by specifying the SQLCHECK option on the command line. The rules of SQL syntax and semantics are defined in the Oracle7 Server SQL Reference.Ĭontrolling the Type and Extent of Checking For example, the following embedded SQL statements contain semantic errors:ĮXEC SQL DELETE FROM EMPP WHERE DEPTNO = 20 ĮXEC SQL SELECT * FROM EMP WHERE ENAME = :emp_name Thus, semantic checking verifies that references to database objects and host variables are valid and that host-variable datatypes are correct. Rules of semantics specify how valid external references are made. ![]() missing parentheses around column names COMM and SALĮXEC SQL INSERT INTO EMP COMM, SAL VALUES (NULL, 1500) For example, the following embedded SQL statements contain syntax errors:ĮXEC SQL DELETE FROM EMP WERE DEPTNO = 20 Thus, syntactic checking verifies that keywords, object names, operators, delimiters, and so on are placed correctly in your SQL statement. Rules of syntax specify how language elements are sequenced to form valid statements. ![]() This appendix shows you how to use the SQLCHECK option to control the type and extent of checking.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |