SAP HANA: Insert into with Select Statement

 

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)));