Help Center> GaussDB> Centralized_3.x> Application Development Guide> ECPG-based Development> Executing Dynamic SQL Statements> Executing a Statement Without a Result Set
Updated on 2024-05-07 GMT+08:00
View PDF

Executing a Statement Without a Result Set

An example of running the EXECUTE IMMEDIATE command is as follows: 
EXEC SQL BEGIN DECLARE SECTION;
    const char *stmt = "CREATE TABLE test1 (...);";
EXEC SQL END DECLARE SECTION;
    EXEC SQL EXECUTE IMMEDIATE :stmt;

EXECUTE IMMEDIATE can be used for SQL statements that do not return a result set, such as DDL, INSERT, UPDATE, and DELETE statements. However, statements for retrieving data, such as SELECT statements, cannot be executed in this way.