Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint
Cover Image
Cover Image
Drag to reposition
Contributed Answers

Inserting an Array to a table in SAP HANA database

Is there a way to insert an Array to a table in HANA database? I have an array of EMPL_ID with multiple skill set referred by SKILL_ID. I have written below code , However the output is coming as:  , Whereas I am expecting below code ,
Answered on 8th Dec, 2017, 0 Views

As far as I know, there is no direct way of inserting an Array using SQL query. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database.

loader
Advertisements
Contribution

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.