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 30, 2024

Applies to:

Symptoms

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.

Cause

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