assimilate this!

[expat]

I had a big PL/SQL file (OK I don't normally do coding any more but I still can) and I wanted to find all the LOOP ... END LOOP pairs, and get a quick picture of how they were nested and sequenced. What text editor would the Board use to do that? It's a unix system but most work is done on the Windows PC, e.g. by UltraEdit and FTP.

Obviously you can search and mark in any editor, but I wanted to be able to visualise the pairings (e.g. as you can in Textpad with Ctrl-m to find the mate for a bracket: but how do you define Loop and END LOOP as brackets?)

In the end I opened it in SPF and did a "X ALL;F ALL LOOP". Ah, a real editor is still useful.

[AtW]

EditPlus is good.

[Fleetwood]

In the end I opened it in SPF and did a "X ALL;F ALL LOOP". Ah, a real editor is still useful.

That would just give you a list of the all the lines containing "LOOP". It wouldn't tell you which "LOOP" went with which "END-LOOP".

[expat]

That would just give you a list of the all the lines containing "LOOP". It wouldn't tell you which "LOOP" went with which "END-LOOP".

No, but since you've eXcluded all the irrelevant lines, the structure is clear at a glance. If it was anybody but IBM, they'd have copyrighted the look and feel of X ALL, it's so powerful.

[hyperD]

What the hell ever happened to the For Next or Do While Loop stuff?

hyperd in "I'm so stupid so what the hell am I doing in IT" mode

[Jabberwocky]

And the Jabber said Emacs. And it grew into a large cube and
destroyed all those who touched it.

[expat]

And the Jabber said Emacs. And it grew into a large cube and
destroyed all those who touched it.

I know, I know. I sometimes ask myself why I'm not an Emacs enthusiast. But I'm not.

[EternalOptimist]

well write a little loop dump that goes through the text - **** s*ke

[TwoWolves]

Use text replacement of the BEGIN and END statements into "{" and "}".

Then put it into Eclipse or Developer Studio, they allow you to open/collapse code blocks.

[andy]

Real men use vi editor