END-EXEC

Oracle

Example

EXEC SQL
    SELECT *
    INTO :variable
    FROM table_name
END-EXEC;

Output

Assuming the output of the query was stored in a variable called ‘variable’, the output should be the values from the selected column of the table.

Explanation

The END-EXEC statement is used to mark the end of an SQL statement within a host program. The above code simply retrieves data from a table. The keyword INTO leading with : is used to represent the host variable where the retrieved data is stored. The keyword FROM is indicating the table to extract data from.

SQL Server

Example

EXEC SQL
SELECT * From Employee
END-EXEC;

Output

Id | Name | Position
-- | ---- | --------
1  | John | Manager
2  | Jane | Analyst
3  | Bob  | Developer

Explanation

In the example, the EXEC SQL and END-EXEC statements indicate the beginning and end of SQL commands. The SQL statement SELECT * FROM Employee retrieves all data from the Employee table. Output represents the returned rows from the table. Note: EXEC SQL and END-EXEC are largely used in embedded SQL in languages like C and COBOL, SQL Server does not use these commands.