Description should include the procedures for defining methods and properties that enable PL/SQL commands to send and receive SQL from a database through the following interfaces:
The following table provides a summary of each interface's purpose and recommended use:
Interface Type |
Recommended Use |
Statement |
Use for general-purpose access to a database. Useful when using static SQL statements at runtime. The Statement interface cannot accept parameters. |
CallableStatement |
Use when accessing database stored procedures. The CallableStatement interface can accept runtime input parameters. |
PreparedStatement |
Use when planning to use the SQL statements many times. The PreparedStatement interface accepts input parameters at runtime. |