i have a database link with MS SQL server.
When I select like b
select col1 from tab@mssql;
The above works fine.
select distinct col1 from tab@mssql;
The above gives error.
ORA-02070: database DBNAME does not support select distinct in this context
02070. 00000 - "database %s%s does not support %s in this context"
*Cause: The remote database does not support the named capability in
the context in which it is used.
*Action: Simplify the SQL statement.
Error at Line: 8 Column: 9
col1 on remote database is varchar(4000).
Any idea why I'm getting error?