Embedded SQL statements are used to incorporate DDL, DML and TCL statements within the body of a procedural language program. These are:
- DEFINE- used to define cursors
- OPEN- used to allocate cursors
- DECLARE- used to assign variable names
- EXECUTE- used to execute SQL statements
- FETCH- used to retrieve data from database
No comments:
Post a Comment