PLD11: Totals directive in SQL Window

[Bert Gombos]

This doesn't work correctly.

-- Totals=[maxct_free]
select *
from user_tables;

This causes warning: Unknown column for totals: "PCT_FREE]"

But "-- Totals=[maxct_free" works sometimes.

How can I use multiple directives?

 

[Marco Kalter]

You should not use brackets:

-- Totals=maxct_free

For multiple columns:

-- Totals=maxct_free,pct_used,sum:blocks

This displays the maximum value for the pct_free and pct_used columns, and the sum for the blocks column.

 

[Bert Gombos]

Thanks. This feature's description in New features was midleading a bit.