Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Modify data
Insert rows
Syntax rules for inserts on columns
Rows that contain named row types

Rows that contain named row types

The following statement shows you how to insert a row into the employee table in Create the student table.:

INSERT INTO employee
   VALUES ('Poole, John', 
   ROW('402 High St', 'Willits', 'CA', 
   ROW(69055,1450))::address_t, 35000 );

Because the address column of the employee table is a named ROW type, you must use a cast operator and the name of the ROW type (address_t) to insert a value of type address_t.