Open topic with navigation
When defining Oracle database sources, SQL SELECT statements that select data, or call a function that returns a value, can be invoked from the User defined SQL statement tab of the Source Database Table dialog. Errors are issued by DMExpress when using inappropriate syntax or calling an unsupported statement.
The following error messages may be issued by DMExpress when using unsupported expressions or invalid syntax in the User defined SQL statement tab of the Source Database Table dialog:
You can enter the following as SQL Text in the User defined SQL statement tab of the Source Database Table dialog when defining Oracle sources:
When using user-defined SQL to define an Oracle source, adhere to the following guidelines:
SELECT * FROM TABLE(return_dept_data(10))
SELECT t1.customer_id, t1.lastname, t1.firstname, t2.*
FROM customer t1, TABLE(t1.address) t2
SELECT empno, ename, get_bonus(ename) AS emp_bonus, sal FROM emp
SELECT max(sal) from emp
SELECT empno, ename, sal FROM emp WHERE deptno = 10
See the attached file, 131_Examples.pdf , for complete definitions of objects used in the above examples.
A TABLE collection expression tells Oracle that the value returned by a collection expression should be treated as a table. The collection expression can be a sub-query, a nested table column, a function, or a collection constructor which returns a collection.
For more information on Oracle collection data types, refer to the Oracle documentation.
For details on user-defined SQL statements for Oracle sources, see Source Database Table dialog in the DMExpress Help.
Copyright © 2016 Syncsort All rights reserved.