Equivalent of BREAK ON BLABLA in PL*SQL

[Giani]

Hi all,

What's the equivalent of "BREAK ON BLABLA" in PL*SQL.
eg:
from SQLPLUS prompt I can do "BREAK ON TABLESPACE_NAME"
How do I write it in PL*SQL?

TIA

[marist89]

SQL*Plus is a tool. You can do lots of pretty formatting and such with it.

PL/SQL is a programming language (more or less, no flames please). You write a function/procedure and can format the results from the host language from which you called the procedure.

In other words, you can't do it.

[stecal]

You can create an artificial break by doing a test (if-then-else) on the tablespace name.

Pretend you are coding in COBOL, doing record keeping.

current record = ts name of interest
do a check to see if select ts name = current record
if so, do whatever
if not (the "else"), current record = new ts name


When the tablespace name changes, skip a line, output the new tablespace name, and continue.

You can find an example of this in a generic programming logic book.