Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Basic for-next loop in TDV


Recommended Posts

Is this what you mean

 

procedure basicForLoop()

begin

declare tables cursor for

select schema_name, table_name

from /services/databases/system/ALL_TABLES

where schema_name is not null

and table_name is not null;

 

for tab as tables do

call print(tab.schema_name || '.' || tab.table_name);

end for;

end

Link to comment
Share on other sites

  • 2 weeks later...
  • 7 months later...
×
×
  • Create New...