Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR ORA00997 using Distinct

AndreNFigueiredoNov 20 2018 — edited Nov 20 2018

Guys, I need some help. I am a beginner in the PL / SQL world and I came across a problem. I can not use DISTINCT when there is a column with the LONG data type. Is there any other way to convert this data? Here is the query: SELECT DISTINCT OBSERVACAO FROM FLP_HISTORICO_OBS

Comments
Post Details
Added on Nov 20 2018
9 comments
1,607 views