Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Other syntax segmentsThese topics describe syntax segments, which are language elements, such as database object names or optimizer directives, that appear as a subdiagram reference in the syntax diagrams of some SQL or SPL statements.
Owner nameThe owner name specifies the owner of a database object. Use this segment whenever you see a reference to Owner Name in a syntax diagram.
Using Quotation Marks

Using Quotation Marks

Within quotation marks, owner is case sensitive. Quotation marks instruct the database server to read or store the name exactly as typed when you create or access a database object. For example, suppose that you have a table whose owner is Sam. You can use either one of the following two statements to access data in the table:

SELECT * FROM table1;
SELECT * FROM 'Sam'.table1;

The first query succeeds because the owner name is not required. The second query succeeds because the specified owner name matches the owner name as it is stored in the database.