asked on

Oracle SQL Developer

I have a lengthy query that creates a table then fills it with about 20 INSERT statements from various other sources.

When I edit the query at times all the various pieces of the query open. Is it possible to collapse the drill in with a single key stroke or mouse click?

mlmcc

HainKurt

I could not get what you are asking here...
can you post a screenshot

slightwv (䄆 Netminder)

@HainKurt
If I understand the question correctly, they are asking if it is possible to collapse regions. I believe you are a Visual Studio person. If so, something similar to this:
https://msdn.microsoft.com/en-us/library/td6a5x4s(v=vs.100).aspx

HainKurt

you mean collapse/expand code block :)
but I dont see anywhere mention of VisualStudio...

if it is Sql Developer:

Tools > Preferences > Code Editor: Display > Show Code Folding Margin

then you should see +/- icons on left so you can collapse codes for easy edit :)

slightwv (䄆 Netminder)

>>but I dont see anywhere mention of VisualStudio...

I used that as a representative example.........................................................

Mike McCracken

ASKER

That shows the fold/unfold but there doesn't seem to be a collapse all ability

mlmcc

ASKER CERTIFIED SOLUTION

HainKurt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

ASKER

Thanks. Was right clicking in the wrong area. Had to right click the +/-

mlmcc