SAP HANA: Insert into with Select Statement

Example 1:

To insert a record for a Particular Columns in a table:

Code:

INSERT INTO "KABIL_PRACTICE"."PROC_TEST" ("ID","NAME") (SELECT 1,'KABIL' FROM DUMMY);

Example 2:

To insert a record in a table:

Code:

INSERT INTO "KABIL_PRACTICE"."PROC_TEST" (SELECT 1,'KABIL' FROM DUMMY);

INSERT INTO "KABIL_PRACTICE"."PROC_TEST" SELECT 1,'KABIL' FROM DUMMY;

Example 3:

To insert a record in a table with some Calculations:

Code:

INSERT INTO "KABIL_PRACTICE"."PROC_TEST" VALUES (1, TO_CHAR(ADD_DAYS(CURRENT_DATE,1)));

Thanks For Visiting My Blog...

Share your comments...