Toad World® Forums

Sorting Oracle Triggers in Object Explorer


#1

I have an Oracle DB with many triggers.

TFDA lists one column (NAME) for Oracle Triggers.

This column is clickable and looks like it wants to sort by name.

Nothing happens when you click this column heading.

Any Ideas?


#2

What version are you using? Triggers sort for me.

All columns that are sortable show a triangle showing the direction it is currently sorted in. See attached screenshot.

If you have a lot of triggers I would suggest building a filter, so you can better deal with them. There is a cone or funneling looking icon that will bring up the filter dialog. Here you can define a filter and save it. See attached. You can toggle applying the filter with the drop down next to it.

Debbie
NamedFilter.png


#3

What version are you using? Triggers sort for me.

All columns that are sortable show a triangle showing the direction it is currently sorted in. See attached screenshot.

If you have a lot of triggers I would suggest building a filter, so you can better deal with them. There is a cone or funneling looking icon that will bring up the filter dialog. Here you can define a filter and save it. See attached. You can toggle applying the filter with the drop down next to it.

Debbie
SortTriggers.png