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!

How do I use the filter in Oracle SQL Developer ?

675068Feb 10 2009 — edited Feb 11 2009

Hi there !

I'm using Oracle SQL Developer to browse my DB.
I have a View called "ResourceVIEW" where I have columns "DataSet" and "Displayname".
But this view is containing thousound of entries, and I would like to filter all Displayname starting with "SBC", anf filter all Displaynames containing "SBC".

I'm trying different syntax, but obviously the wrong ones, since I'm always getting the wrong error message :

ora-00936 missing expression.

Could you please help me understanding the syntax to be used in the Filter field ?
Many Thanks !!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2009

Added on Feb 10 2009

8 comments

2,739 views