My Oracle Support Banner

Using Column Names Instead of Using * in a SQL Query Can't Work With SAP ASE(Sybase) (Doc ID 2958400.1)

Last updated on JUNE 29, 2023

Applies to:

Oracle Integration-OIC - Version 23.3.2 and later
Information in this document applies to any platform.


If using the column names instead of using * in a sql query, there're validation failure. Say [select column_name1,column_name2 from table_name where column_name1 = # column_name1 and column_name2 = # column_name2] works, but [select column_name1,column_name2 from table_name where column_name1 = # column_name1] doesn't work. This will impact the data volumn size when querying, as 10 MB is the limitation for database query.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.