JDBC 3.0 specification includes support for User-Defined-Type (UDT) by providing various methods in the PreparedStatement, CallableStatement and ResultSet interface. Most of the database now enable you to create structured types, used todefine complex data types. This is required in case you want to create a user-defined-type (UDT) in a database. For example, you migth...
Most of the database vendors supports inbuilt functions, such as the numeric, string, time etc.This functions are used in SQL statement and returns scalar values that are stored in database. In addition to these per-defined functions, RDBMS provide also supports user defined functions. User Defined Functions can be used in following situation. In the...
A cursor defines the runtime execution environment for a query where the result of the query execution can be captured. That is, we can open the cursor and execute the query in that environment and read the output of the query from the cursor. The syntax used to create a cursor is as follows....
