8 Replies Latest reply on Sep 30, 2016 5:21 PM by thatJeffSmith-Oracle

about query results/script output

nohup Sep 30, 2016 1:25 PM

Hello,

Issue 0)

When a query or F5 on a query or show parameter sqlplus command is run the Script output appears. It seems to borrow less amount of space from the worksheet area than Query results. First time after a connection is established.

Establish a connection
Run command

show all

Establish another connection
Run query using control+Enter

select * from dba_tables;

The difference is that, for the first time (and only the first time )that any command is run Script output takes less space compared to Query Results. So if the first query or command executed is a sqlplus command, or run using F5, the Script Output appears and borrows less space, compared to, if a query was executed using Control+Enter, which shows data in Query results and borrows more space from Worksheet.

But notice that among Query Results and Script Output, if Script Output was the first to borrow space from Worksheet, Query results does not borrow more space from the worksheet when subsequent commands are run using Control +Enter. One has to manually pull it up and let it use more space from the worksheet. It would have been okay if subsequent "query results" (run after the first query run used Script Output to show results)automatically borrowed more space like it did if/when the first query run after establishing a connection was shown in Query results.

Issue 1)

When a connection is established, the startup script is run from the preferences menu called "Filename for the connection startup script".

I wrote a query to get the database name in that connection startup script because I want to make sure that the connection name to which I add the database name, is indeed the database I have connected to.

But the output of this query appears in the Messages box/pane/l, and not on the Script Output of the worksheet of that connection which opens because I have "Open a Worksheet on Connect" enabled. It would have been good if the output of connection startup script appeared in the Script output or Query results when "Open a worksheet on connect" is checked instead of the Messages box/pane/l.

Issue 2)

This button which looks like the reversible reaction. It is not very evident what it does and does not have that pressing effect(like the the buttons that can be depressed and remain in the depressed state untill mouse click is completed). For example the "Run statement" button on the worksheet which gets slightly darker/deeper in colour when mouse pointer hovers over it

This is fine. But after this button is pressed and the Script Output and/or Query results get minimized, it does not come back up even after subsequent queries are run. We have to manually go to the reversible reaction up arrow and maximize the Script Output/Query results.

May I suggest getting a new minimize button just like the three buttons that appear when there are too many Worksheets/Connections open like below, which is awesome.

I have "Show query results in new tabs" checked.

Thanks

===================

About

-----

Oracle SQL Developer 4.1.5.21

Version 4.1.5.21

Build MAIN-21.78

IDE Version: 12.2.1.0.42.151001.0541

Product ID: oracle.sqldeveloper

Product Version: 12.2.0.21.78

Version

-------

Component Version

========= =======

Oracle IDE 4.1.5.21.78

Java(TM) Platform 1.8.0_102

Versioning Support 4.1.5.21.78

Properties

----------

Name Value

==== =====

file.encoding.pkg sun.io

org.osgi.framework.executionenvironment OSGi/Minimum-1.0,OSGi/Minimum-1.1,OSGi/Minimum-1.2,JRE-1.1,J2SE-1.2,J2SE-1.3,J2SE-1.4,J2SE-1.5,JavaSE-1.6,JavaSE-1.7,JavaSE-1.8

ide.firstrun true

osgi.framework file:/D:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/platform/modules/ext/org.eclipse.osgi_3.9.1.v20140110-1610.jar

java.home C:\Program Files\Java\jdk1.8.0_102\jre

ide.pref.dir C:\Users\myname.here\AppData\Roaming\SQL Developer

oracle.xdkjava.compatibility.version 9.0.4

org.osgi.framework.bootdelegation *

ide.launcherProcessId 5388

ide.work.dir.base C:\Users\myname.here\Documents

java.endorsed.dirs C:\Program Files\Java\jdk1.8.0_102\jre\lib\endorsed

ide.startingcwd D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin

osgi.bundlestore C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache\var\cache\netigso\org.eclipse.osgi\bundles

sun.java2d.noddraw true

ide.product oracle.sqldeveloper

sun.os.patch.level Service Pack 1

java.vendor.url http://java.oracle.com/

java.version 1.8.0_102

ide.build MAIN-21.78

oracle.ide.launcher.startup.time 1474633215037

objectweb-asm.library D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../modules/asm-3.1.jar

oracle.jdbc.Trace true

ide.java.maxversion 1.9

osgi.os win32

osgi.compatibility.bootdelegation false

org.eclipse.equinox.simpleconfigurator.configUrl file:bundles.info

felix.log.level 4

org.osgi.framework.uuid 10184316-8881-0016-17a6-9bb7a60e8bc5

org.openide.major.version IDE/1

java.vendor.url.bug http://bugreport.sun.com/bugreport/

netbeans.buildnumber 201411261024

oracle.jrf.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper

ide.user.dir C:\Users\myname.here\AppData\Roaming\SQL Developer

user.name myname.here

org.osgi.framework.version 1.7.0

sun.io.unicode.encoding UnicodeLittle

org.osgi.framework.system.packages javax.accessibility,javax.activation,javax.activity,javax.annotation,javax.annotation.processing,javax.crypto,javax.crypto.interfaces,javax.crypto.spec,javax.imageio,javax.imageio.event,javax.imageio.metadata,javax.imageio.plugins.bmp,javax.imageio.plugins.jpeg,javax.imageio.spi,javax.imageio.stream,javax.jws,javax.jws.soap,javax.lang.model,javax.lang.model.element,javax.lang.model.type,javax.lang.model.util,javax.management,javax.management.loading,javax.management.modelmbean,javax.management.monitor,javax.management.openmbean,javax.management.relation,javax.management.remote,javax.management.remote.rmi,javax.management.timer,javax.naming,javax.naming.directory,javax.naming.event,javax.naming.ldap,javax.naming.spi,javax.net,javax.net.ssl,javax.print,javax.print.attribute,javax.print.attribute.standard,javax.print.event,javax.rmi,javax.rmi.CORBA,javax.rmi.ssl,javax.script,javax.security.auth,javax.security.auth.callback,javax.security.auth.kerberos,javax.security.auth.login,javax.security.auth.spi,javax.security.auth.x500,javax.security.cert,javax.security.sasl,javax.sound.midi,javax.sound.midi.spi,javax.sound.sampled,javax.sound.sampled.spi,javax.sql,javax.sql.rowset,javax.sql.rowset.serial,javax.sql.rowset.spi,javax.swing,javax.swing.border,javax.swing.colorchooser,javax.swing.event,javax.swing.filechooser,javax.swing.plaf,javax.swing.plaf.basic,javax.swing.plaf.metal,javax.swing.plaf.multi,javax.swing.plaf.nimbus,javax.swing.plaf.synth,javax.swing.table,javax.swing.text,javax.swing.text.html,javax.swing.text.html.parser,javax.swing.text.rtf,javax.swing.tree,javax.swing.undo,javax.tools,javax.transaction,javax.transaction.xa,javax.xml,javax.xml.bind,javax.xml.bind.annotation,javax.xml.bind.annotation.adapters,javax.xml.bind.attachment,javax.xml.bind.helpers,javax.xml.bind.util,javax.xml.crypto,javax.xml.crypto.dom,javax.xml.crypto.dsig,javax.xml.crypto.dsig.dom,javax.xml.crypto.dsig.keyinfo,javax.xml.crypto.dsig.spec,javax.xml.datatype,javax.xml.namespace,javax.xml.parsers,javax.xml.soap,javax.xml.stream,javax.xml.stream.events,javax.xml.stream.util,javax.xml.transform,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transform.stax,javax.xml.transform.stream,javax.xml.validation,javax.xml.ws,javax.xml.ws.handler,javax.xml.ws.handler.soap,javax.xml.ws.http,javax.xml.ws.soap,javax.xml.ws.spi,javax.xml.ws.spi.http,javax.xml.ws.wsaddressing,javax.xml.xpath,org.ietf.jgss,org.omg.CORBA,org.omg.CORBA_2_3,org.omg.CORBA_2_3.portable,org.omg.CORBA.DynAnyPackage,org.omg.CORBA.ORBPackage,org.omg.CORBA.portable,org.omg.CORBA.TypeCodePackage,org.omg.CosNaming,org.omg.CosNaming.NamingContextExtPackage,org.omg.CosNaming.NamingContextPackage,org.omg.Dynamic,org.omg.DynamicAny,org.omg.DynamicAny.DynAnyFactoryPackage,org.omg.DynamicAny.DynAnyPackage,org.omg.IOP,org.omg.IOP.CodecFactoryPackage,org.omg.IOP.CodecPackage,org.omg.Messaging,org.omg.PortableInterceptor,org.omg.PortableInterceptor.ORBInitInfoPackage,org.omg.PortableServer,org.omg.PortableServer.CurrentPackage,org.omg.PortableServer.POAManagerPackage,org.omg.PortableServer.POAPackage,org.omg.PortableServer.portable,org.omg.PortableServer.ServantLocatorPackage,org.omg.SendingContext,org.omg.stub.java.rmi,org.w3c.dom,org.w3c.dom.bootstrap,org.w3c.dom.css,org.w3c.dom.events,org.w3c.dom.html,org.w3c.dom.ls,org.w3c.dom.ranges,org.w3c.dom.stylesheets,org.w3c.dom.traversal,org.w3c.dom.views,org.w3c.dom.xpath,org.xml.sax,org.xml.sax.ext,org.xml.sax.helpers

ide.bundle.search.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\dropins

sun.jnu.encoding Cp1252

java.runtime.name Java(TM) SE Runtime Environment

ide.work.dir C:\Users\myname.here\Documents\SQL Developer

oracle.ide.osgi.boot.api.OJStartupHook oracle.dbtools.raptor.startup.HomeSupport

ide.conf D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

jdk.home C:\Program Files\Java\jdk1.8.0_102\jre\..

private.jdev.load.remote.schemas false

org.netbeans.CLIHandler.server false

osgi.instance.area.default file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/

ide.bootstrap.start 5645153748843

netbeans.dirs D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\fcpbridge;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\ide;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\dropins

java.specification.name Java Platform API Specification

sun.awt.datatransfer.timeout 1000

org.osgi.supports.framework.fragment true

osgi.framework.useSystemProperties true

oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW

user.timezone

nb.native.filechooser false

org.osgi.framework.system.capabilities osgi.ee; osgi.ee="OSGi/Minimum"; version:List<Version>="1.0, 1.1, 1.2",osgi.ee; osgi.ee="JRE"; version:List<Version>="1.0, 1.1",osgi.ee; osgi.ee="JavaSE"; version:List<Version>="1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8"

osgi.nl en_IN

osgi.contextClassLoaderParent app

org.openide.specification.version 6.2

user.script

path.separator ;

java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory

osgi.framework.activeThreadType normal

file.encoding Cp1252

osgi.arch x86_64

ice.browser.forcegc false

sun.java.command oracle.ide.osgi.boot.OracleIdeLauncher

https.nonProxyHosts IN1-mycompnamehere

oracle.ide.IdeFrameworkCommandLineOptions -clean,-console,-debugmode,-migrate,-migrate:,-nomigrate,-nonag,-nondebugmode,-noreopen,-nosplash,-role:,-su

tool.user.conf C:\Users\myname.here\AppData\Roaming\sqldeveloper\4.1.5\sqldeveloper.conf

org.osgi.supports.framework.requirebundle true

oracle.jdbc.mapDateToTimestamp false

osgi.classloader.type parallel

osgi.bundles.defaultStartLevel 1

java.io.tmpdir C:\Users\mynamehere~1.JAS\AppData\Local\Temp\

org.osgi.framework.os.name Windows7

ice.pilots.html4.tileOptThreshold 0

user.language en

javax.xml.stream.XMLInputFactory com.ctc.wstx.stax.WstxInputFactory

line.separator \r\n

sqldev.debug false

ice.pilots.html4.ignoreNonGenericFonts true

eclipse.parsers.setTCCL false

org.osgi.framework.processor x86-64

oracle.ide.extension.HooksProcessingMode LAZY

java.vm.info mixed mode

osgi.manifest.cache C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache\var\cache\netigso\org.eclipse.osgi\manifests

sun.desktop windows

java.vm.specification.name Java Virtual Machine Specification

javax.xml.stream.util.XMLEventAllocator oracle.ideimpl.xml.stream.XMLEventAllocatorImpl

netbeans.dynamic.classpath D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\asm-all-5.0.1.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\core.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\org-netbeans-libs-asm.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\org-openide-filesystems.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_de.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_es.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_fr.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_it.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_ja.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_ko.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_pt_BR.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_zh_CN.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_zh_TW.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_de.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_es.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_fr.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_it.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_ja.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_ko.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_pt_BR.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_zh_CN.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_zh_TW.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\fcpbridge\core\org-netbeans-core-dynamicconfig.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\fcpbridge\core\locale\core_jdev.jar

jdbc.library D:\app\myname.here\product\12.1.0\dbhome_1\jdbc\lib\ojdbc7.jar

http.nonProxyHosts IN1-mycompnamehere

excluded.modules org.eclipse.osgi

ide.boot.class.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../ide/lib/javax-ide.jar,file:../../ide/lib/javatools.jar,file:../../modules/oracle.javatools/javatools-nodeps.jar,file:../../modules/oracle.javatools/javatools-jndi-local.jar,file:../../ide/extensions/oracle.ide.jar,file:../../ide/lib/idert.jar,file:../../modules/oracle.javatools/oicons.jar,file:../../ide/lib/uic.jar,file:../../ide/lib/audit-boot.jar,file:../../ide/lib/indexing-migrator-boot.jar,file:../../jlib/jewt4.jar,file:../../modules/oracle.bali.share/share.jar,file:../../jlib/help4.jar,file:../../jlib/inspect4.jar,file:../../modules/oracle.xdk/xmlparserv2.jar

osgi.configuration.area file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/var/cache/netigso/

sun.java2d.ddoffscreen false

java.awt.printerjob sun.awt.windows.WPrinterJob

ide.cluster.dirs /sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/fcpbridge/:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/ide/:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/../

ilog.propagatesPropertyEditors false

oracle.jdbc.useFetchSizeWithLongColumn true

netbeans.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform

org.osgi.framework.storage file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/var/cache/netigso

ide.shell.enableFileTypeAssociation D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe

osgi.ws win32

javax.xml.transform.TransformerFactory oracle.ide.xml.switchable.SwitchableTransformerFactory

org.osgi.supports.framework.extension true

oracle.jdbc.autoCommitSpecCompliant false

gosh.args --nointeractive

osgi.parentClassloader app

org.osgi.framework.language en

os.name Windows 7

eclipse.home.location file:/D:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/

java.specification.vendor Oracle Corporation

java.vm.name Java HotSpot(TM) 64-Bit Server VM

org.openide.version deprecated

ide.AssertTracingDisabled true

sun.awt.enableExtraMouseButtons true

java.library.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Perl64\site\bin;C:\Perl64\bin;D:\app\myname.here\product\12.1.0\dbhome_1\bin;D:\app\myname.here\product\11.2.0\client_1\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x64;C:\Program Files\TortoiseSVN\bin;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\WinMerge;C:\Program Files (x86)\Brackets\command;C:\Users\myname.here\AppData\Local\Programs\Python\Python35-32\Scripts\;C:\Users\myname.here\AppData\Local\Programs\Python\Python35-32\;C:\Users\myname.here\AppData\Local\atom\bin;.

ide.cfu.class.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../modules/oracle.bali.share/share.jar,file:../../jlib/jewt4.jar,file:../../modules/oracle.xdk/xmlparserv2.jar,file:../../ide/lib/javatools.jar,file:../../modules/oracle.javatools/javatools-nodeps.jar,file:../../ide/lib/idert.jar,file:../../ide/extensions/oracle.ide.jar,file:../../ide/extensions/oracle.ide.webupdate.jar

jna.boot.library.name jnidispatch-410

java.class.version 52.0

user.conf C:\Users\myname.here\AppData\Roaming\sqldeveloper\4.1.5\product.conf

ide.extension.search.path sqldeveloper/extensions:jdev/extensions:ide/extensions

ide.config_pathname D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

oracle.ide.reportEDTViolations.exceptionsfile /sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/ide/bin/swing-thread-violations.conf

ide.system.dir C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\

java.util.logging.config.file logging.conf

osgi.instance.area file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/

osgi.install.area file:/D:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/

sun.boot.library.path C:\Program Files\Java\jdk1.8.0_102\jre\bin

svnkit.sax.useDefault true

sun.management.compiler HotSpot 64-Bit Tiered Compilers

netbeans.logger.console true

java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment

user.variant

ide.pref.dir.base C:\Users\myname.here\AppData\Roaming

ide.splash.screen splash.gif

ide.update.usage.servers http://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml

osgi.user.area file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/

ide.debugbuild false

java.vm.specification.version 1.8

sun.locale.formatasdefault true

osgi.noShutdown true

orai18n.library.dir D:\app\myname.here\product\12.1.0\dbhome_1\jlib

awt.toolkit sun.awt.windows.WToolkit

xdb.library D:\app\myname.here\product\12.1.0\dbhome_1\rdbms\jlib\xdb6.jar

sun.cpu.isalist amd64

ide.java.minversion 1.8

java.ext.dirs C:\Program Files\Java\jdk1.8.0_102\jre\lib\ext;C:\Windows\Sun\Java\lib\ext

os.version 6.1

osgi.framework.version 3.9.1.v20140110-1610

http.agent SQL Developer/4.1.5 (Windows 7 6.1; amd64; Java 1.8.0_102; NA; c3b9baf3-0151-1000-8001-0a32016a3694; ) 4.1.5.21.78

user.home C:\Users\myname.here

org.xml.sax.driver oracle.xml.parser.v2.SAXParser

ide.mw.relative.home .

java.vm.vendor Oracle Corporation

javax.xml.parsers.DocumentBuilderFactory oracle.xml.jaxp.JXDocumentBuilderFactory

ide.user.dir.var IDE_USER_DIR

osgi.hook.configurators.include org.netbeans.modules.netbinox.NetbinoxHooks

ide.startingArg0 D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe

user.dir D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin

org.osgi.framework.os.version 6.1.0

ide.RectangularSplashScreen true

osgi.user.area.default file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/

sun.cpu.endian little

reserved_filenames con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$

osgi.support.multipleHosts true

ORACLE_HOME D:\sqldeveloper-4.1.5.21.78-no-jre

java.vm.version 25.102-b14

oracle.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper

java.class.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\ide-boot.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\boot.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-util-ui.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-util.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-util-lookup.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-modules.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\fcpboot.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\xml-factory.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\woodstox-core-asl-4.2.0.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\stax2-api-3.1.1.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\lib\oracle.sqldeveloper.homesupport.jar

oracle.fcp.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper

os.arch amd64

oracle.ide.reportEDTViolations bug

ide.devbuild false

netbeans.user C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache

windows.shell.font.languages

org.osgi.framework.vendor Eclipse

ide.diagnostics.dir C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\.diagnostics\

nb.core.windows.no.lazy.loading true

java.vm.specification.vendor Oracle Corporation

file.separator \

java.runtime.version 1.8.0_102-b14

sun.boot.class.path /sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/rdbms/jlib/ojdi.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_102\jre\classes;C:\Program Files\Java\jdk1.8.0_102\lib\tools.jar;C:\Program Files\Java\jdk1.8.0_102\lib\dt.jar

user.country IN

osgi.configuration.cascaded false

oracle.ide.startup.features sqldeveloper

osgi.logfile C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache\var\cache\netigso\1474633216985.log

sqldeveloper.oci.available true

jdeveloper.system_http_proxy DIRECT

osgi.framework.properties C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache

xmlparser.library D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../modules/oracle.xdk/xmlparserv2.jar

java.vendor Oracle Corporation

oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG true

sqldev.onsd true

osgi.bundlefile.limit 500

ide.feedback-server ide.us.oracle.com

oracle.ide.classload.layer osgi

osgi.locking none

java.specification.version 1.8

oracle.product.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper

sun.arch.data.model 64

java.memory.heap.init 134217728

java.memory.heap.max 746061824

java.memory.heap.used 133345144

java.memory.nonheap.init 2555904

java.memory.nonheap.max -1

java.memory.nonheap.used 201587256

Extensions

----------

Name Identifier Version Status Registration Time Initialization Time Total Time

==== ========== ======= ====== ================= =================== ==========

Integrated Development Environment (IDE) Platform Core oracle.ide 12.2.1.0.42.151001.0541 Fully Loaded 98ms 164ms 262ms

Peek oracle.ideimpl.peek 12.2.1.0.42.151001.0541 Fully Loaded 7ms 5ms 12ms

Code Editor oracle.ide.ceditor 12.2.1.0.42.151001.0541 Fully Loaded 15ms 109ms 124ms

Persistent Storage oracle.ide.persistence 12.2.1.0.42.151001.0541 Fully Loaded 0ms 4ms 4ms

File Change Monitor oracle.ide.file 12.2.1.0.42.151001.0541 Fully Loaded 0ms 5ms 5ms

Web Browser and Proxy oracle.ide.webbrowser 12.2.1.0.42.151001.0541 Fully Loaded 1ms 23ms 24ms

Indexing Service oracle.ide.indexing 12.2.1.0.42.151001.0541 Fully Loaded 0ms 2ms 2ms

Property Inspector oracle.ide.inspector 12.2.1.0.42.151001.0541 Fully Loaded 8ms 14ms 22ms

Markers oracle.ide.markers 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Audit Core Framework oracle.ide.audit 12.2.1.0.42.151001.0541 Fully Loaded 1ms 8ms 9ms

Status and Background Audit oracle.ide.status 12.2.1.0.42.151001.0541 Fully Loaded 2ms 1ms 3ms

IDE macros oracle.ide.macros 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Libraries oracle.ide.library 12.2.1.0.42.151001.0541 Fully Loaded 29ms 11ms 40ms

Virtual File System oracle.ide.vfs 12.2.1.0.42.151001.0541 Fully Loaded 1ms 1ms 2ms

Navigator oracle.ide.navigator 12.2.1.0.42.151001.0541 Fully Loaded 1ms 6ms 7ms

Runner oracle.ide.runner 12.2.1.0.42.151001.0541 Fully Loaded 4ms 6ms 10ms

External Tools oracle.ide.externaltools 12.2.1.0.42.151001.0541 Fully Loaded 10ms 2ms 12ms

File Support oracle.ide.files 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms

Palette 2 oracle.ide.palette2 12.2.1.0.42.151001.0541 Fully Loaded 4ms 0ms 4ms

Object Gallery oracle.ide.gallery 12.2.1.0.42.151001.0541 Fully Loaded 8ms 4ms 12ms

Import/Export Support oracle.ide.importexport 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms

Technology oracle.jdeveloper.technology 12.2.1.0.42.151001.0541 Fully Loaded 4ms 1ms 5ms

Extended IDE Platform oracle.jdeveloper.common 12.2.1.0.42.151001.0541 Fully Loaded 9ms 17ms 26ms

JavaCore oracle.jdeveloper.java.core 12.2.1.0.42.151001.0541 Fully Loaded 7ms 15ms 22ms

Insight oracle.ide.insight 12.2.1.0.42.151001.0541 Fully Loaded 4ms 2ms 6ms

Database UI oracle.ide.db 12.2.1.0.42.151001.0541 Fully Loaded 17ms 51ms 68ms

Database Connections oracle.jdeveloper.db.connection 12.2.1.0.42.151001.0541 Fully Loaded 4ms 21ms 25ms

Database Object Explorers oracle.ide.db.explorer 12.2.1.0.42.151001.0541 Fully Loaded 0ms 11ms 11ms

JDBC Proxy oracle.sqldeveloper.jdbcproxy 12.2.0.21.78 Fully Loaded 0ms 2ms 2ms

Code Editor Find oracle.ide.ceditor-find 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms

Oracle SQL Developer Utilities oracle.sqldeveloper.utils 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms

Compare API oracle.ide.compareapi 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms

Help System oracle.ide.help 12.2.1.0.42.151001.0541 Fully Loaded 8ms 4ms 12ms

Code Editor Save Actions oracle.ide.ceditor-saveactions 12.2.1.0.42.151001.0541 Fully Loaded 2ms 5ms 7ms

Oracle Deployment Core Module oracle.deploy.core 12.2.1.0.42.151001.0541 Fully Loaded 2ms 13ms 15ms

Make and Rebuild oracle.jdeveloper.build 12.2.1.0.42.151001.0541 Fully Loaded 24ms 6ms 30ms

JDeveloper Runner Core oracle.jdeveloper.runner.core 12.2.1.0.42.151001.0541 Fully Loaded 0ms 19ms 19ms

JDeveloper Runner oracle.jdeveloper.runner 12.2.1.0.42.151001.0541 Fully Loaded 7ms 224ms 231ms

PL/SQL Probe Debugger oracle.jdeveloper.db.debug.probe 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

JDeveloper Runner JDI oracle.jdeveloper.jdev-runner-jdi 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Local History oracle.ide.localhistory 12.2.1.0.42.151001.0541 Fully Loaded 0ms 136ms 136ms

History Support oracle.jdeveloper.history 12.2.1.0.42.151001.0541 Fully Loaded 8ms 19ms 27ms

Check For Updates oracle.ide.webupdate 12.2.1.0.42.151001.0541 Fully Loaded 2ms 2ms 4ms

Core Database Development oracle.sqldeveloper 12.2.0.21.78 Fully Loaded 30ms 710ms 740ms

SQL Worksheet oracle.sqldeveloper.worksheet 12.2.0.21.78 Fully Loaded 7ms 51ms 58ms

Database Reports oracle.sqldeveloper.report 12.2.0.21.78 Fully Loaded 3ms 10ms 13ms

Bookmarks oracle.ide.bookmarks 12.2.1.0.42.151001.0541 Fully Loaded 5ms 4ms 9ms

Oracle SQL Developer - SSH Support oracle.sqldeveloper.ssh 12.2.0.21.78 Fully Loaded 3ms 1ms 4ms

Oracle SQL Developer - Extras oracle.sqldeveloper.extras 12.2.0.21.78 Fully Loaded 4ms 76ms 80ms

Oracle SQL Developer - Unit Test oracle.sqldeveloper.unit_test 12.2.0.21.78 Triggers Loaded 4ms 0ms 4ms

Versioning Support oracle.ide.vcscore 12.2.1.0.42.151001.0541 Fully Loaded 2ms 1ms 3ms

Patch Support oracle.jdeveloper.patch 12.2.1.0.42.151001.0541 Fully Loaded 4ms 0ms 4ms

Replace With oracle.ide.replace 12.2.1.0.42.151001.0541 Fully Loaded 1ms 1ms 2ms

IDE Thumbnail oracle.ide.thumbnail 12.2.1.0.42.151001.0541 Fully Loaded 1ms 3ms 4ms

VHV oracle.ide.vhv 12.2.1.0.42.151001.0541 Fully Loaded 0ms 9ms 9ms

QuickDiff oracle.ide.quickdiff 12.2.1.0.42.151001.0541 Fully Loaded 0ms 1ms 1ms

Versioning Support oracle.jdeveloper.vcs 12.2.1.0.42.151001.0541 Fully Loaded 3ms 37ms 40ms

BM Share oracle.bm.jdukshare 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

MOF XMI oracle.mof.xmi 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Code Editor Macro oracle.ide.ceditor-macro 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms

Database XML Schema oracle.sqldeveloper.xmlschema 12.2.0.21.78 Fully Loaded 0ms 2ms 2ms

Oracle SQL Developer - Migrations T-SQL Translator oracle.sqldeveloper.migration.translation.core 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations MySQL SQL Translator oracle.sqldeveloper.migration.translation.mysql_translator 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - File Navigator oracle.sqldeveloper.filenavigator 12.2.0.21.78 Fully Loaded 5ms 3ms 8ms

Versioning Support for Subversion oracle.jdeveloper.subversion 12.2.1.0.42.151001.0541 Fully Loaded 6ms 234ms 240ms

Oracle SQL Developer - Cloud Support oracle.sqldeveloper.cloud 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer Data Modeler oracle.datamodeler 4.1.5.907 Triggers Loaded 26ms 0ms 26ms

Third Party Database Development oracle.sqldeveloper.thirdparty.browsers 12.2.0.21.78 Fully Loaded 0ms 16ms 16ms

Oracle SQL Developer - Migrations Core oracle.sqldeveloper.migration 12.2.0.21.78 Fully Loaded 5ms 114ms 119ms

Oracle SQL Developer - Migrations Teradata oracle.sqldeveloper.migration.teradata 12.2.0.21.78 Triggers Loaded 1ms 0ms 1ms

Searchbar oracle.ide.searchbar 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms

Oracle SQL Developer Data Modeler - Reports oracle.sqldeveloper.datamodeler_reports 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms

JViews Registration Addin oracle.diagram.registration 12.2.1.0.42.151001.0541 Fully Loaded 0ms 30ms 30ms

Oracle SQL Developer - Migrations Translation UI oracle.sqldeveloper.migration.translation.gui 12.2.0.21.78 Fully Loaded 2ms 54ms 56ms

Oracle SQL Developer - Security oracle.sqldeveloper.security 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations Microsoft SQL Server oracle.sqldeveloper.migration.sqlserver 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations Microsoft Access oracle.sqldeveloper.migration.msaccess 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Database Snippets oracle.sqldeveloper.snippet 12.2.0.21.78 Fully Loaded 0ms 7ms 7ms

Diagram Framework oracle.diagram 12.2.1.0.42.151001.0541 Fully Loaded 1ms 14ms 15ms

OLAP oracle.olap 12.2.0.21.78 Fully Loaded 12ms 817ms 829ms

Protocol Handler Classpath oracle.jdeveloper.classpath 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms

Dependency Tracking oracle.ide.dependency 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Code Style oracle.jdeveloper.style 12.2.1.0.42.151001.0541 Fully Loaded 2ms 9ms 11ms

Code Editor Tint oracle.ide.ceditor-tint 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms

ToDo Tasks Markers oracle.jdeveloper.markers.todo 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms

XML Editing Framework oracle.ide.xmlef 12.2.1.0.42.151001.0541 Fully Loaded 11ms 48ms 59ms

Oracle SQL Developer - DBA Navigator oracle.sqldeveloper.dbanavigator 12.2.0.21.78 Fully Loaded 5ms 280ms 285ms

Oracle SQL Developer - Scheduler oracle.sqldeveloper.scheduler 12.2.0.21.78 Fully Loaded 0ms 232ms 232ms

Oracle SQL Developer - Migrations PostgreSQL oracle.sqldeveloper.migration.postgresql 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

OLAPDV oracle.olapdv 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations Sybase Adaptive Server oracle.sqldeveloper.migration.sybase 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Versioning Support for Git oracle.jdeveloper.git 12.2.1.0.42.151001.0541 Triggers Loaded 6ms 0ms 6ms

TimesTen Integration oracle.ide.db.timesten 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - TimesTen oracle.sqldeveloper.timesten 12.2.0.21.78 Fully Loaded 1ms 104ms 105ms

Oracle SQL Developer - Migrations MySQL oracle.sqldeveloper.migration.mysql 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations DB2 oracle.sqldeveloper.migration.db2 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Print System oracle.ide.print 12.2.1.0.42.151001.0541 Triggers Loaded 1ms 0ms 1ms

Oracle SQL Developer - Spatial oracle.sqldeveloper.spatial 12.2.0.21.78 Fully Loaded 3ms 6ms 9ms

Oracle SQL Developer - RESTful Services Administration oracle.sqldeveloper.rest 12.2.0.21.78 Fully Loaded 4ms 8ms 12ms

Help Oracle Start Page oracle.ide.helpstartpage 12.2.1.0.42.151001.0541 Fully Loaded 3ms 0ms 3ms

Code Editor Bookmarks oracle.ide.ceditor-bookmarks 12.2.1.0.42.151001.0541 Fully Loaded 0ms 7ms 7ms

Oracle SQL Developer - Migrations Teradata SQL Translator oracle.sqldeveloper.migration.translation.teradata 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Mac OS X Adapter oracle.ideimpl.apple 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms

Oracle SQL Developer - Migrations DB2 Translator oracle.sqldeveloper.migration.translation.db2 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms

Usage Tracking oracle.ide.usages-tracking 12.2.1.0.42.151001.0541 Fully Loaded 0ms 1ms 1ms

Oracle SQL Developer - Real Time SQL Monitoring oracle.sqldeveloper.sqlmonitor 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms

Oracle SQL Developer - APEX Listener Administration oracle.sqldeveloper.listener 12.2.0.21.78 Triggers Loaded 4ms 0ms 4ms

(Name Unavailable) oracle.sqldeveloper.tuning 12.2.0.21.78 Fully Loaded 2ms 1ms 3ms

Log Window oracle.ide.log 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms

Oracle SQL Developer - Change Mangement oracle.sqldeveloper.em_cm 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms

Database UI Extras oracle.jdeveloper.db.extras 12.2.1.0.42.151001.0541 Triggers Loaded 0ms 0ms 0ms

Oracle SQL Developer - Schema Browser oracle.sqldeveloper.schemabrowser 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms

Component Palette oracle.ide.palette1 12.2.1.0.42.151001.0541 Fully Loaded 7ms 0ms 7ms

Oracle SQL Developer - Database Cart oracle.sqldeveloper.dbcart 12.2.0.21.78 Triggers Loaded 1ms 0ms 1ms

Oracle SQL Developer - Migrations Application Migration oracle.sqldeveloper.migration.application 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms

Data Miner oracle.dmt.dataminer 12.2.0.21.78 Fully Loaded 9ms 243ms 252ms

1. Re: about query results/script output

thatJeffSmith-Oracle Sep 30, 2016 12:49 PM (in response to nohup)

I'm not understanding issue #1 - more/less space? Can you post screenshots that demonstrate this?

For #2, i'm able to use that control to advance the results up to the top, back to the middle, down to the bottom, and back up again...
Like Show 0 Likes(0)

Actions
2. Re: about query results/script output

nohup Sep 30, 2016 1:35 PM (in response to thatJeffSmith-Oracle)

Sorry. The text until Issue 1 is now Issue 0.

Establish connection to EMPLOY database. A new worksheet opens because "Open a worksheet on connect" is checked. The first command executed after establishing a connection in the first image showed output in "Script output".

Now compare it to

Establish connection to DEPLOY database. A new worksheet opens because "Open a worksheet on connect" is checked.
The first command executed after establishing a connection in the second image showed output in "Query Results".

Observe that Script Output took less space compared to the second image in which more space was taken by "Query results"

The issue 0 is that say the first command run after establishing a connection is an sqlplus command like the one run on EMPLOY database(or any other command that brings up Script Output). Now when I run any other query using control +Enter in the EMPLOY database, the "query results" shows like the below image

My question is, why subsequent commands run using Control Enter does not let Query results take up as much space when compared to how much space the Query results take when the first command executed after establishing a connection is shown on "query results".

So just because Script output came first (because of sqlplus command which was run first after establishing a connection) , "Query results " is not able to claim as much space as it would have if it were first(because of a control+Enter command).
Like Show 0 Likes(0)

Actions
3. Re: about query results/script output

thatJeffSmith-Oracle Sep 30, 2016 1:49 PM (in response to nohup)

I'm not observing the output panels resizing based on run script or execute statement - it's always the same amount of space
Like Show 0 Likes(0)

Actions
4. Re: about query results/script output

nohup Sep 30, 2016 1:50 PM (in response to thatJeffSmith-Oracle)

Issue 1 is just that the output of commands in the startup file is showed in the Messages pane instead of "query results" or "Script output" of the connection double clicked.
Open a worksheet on new connection is enabled
Like Show 0 Likes(0)

Actions
5. Re: about query results/script output

nohup Sep 30, 2016 1:55 PM (in response to thatJeffSmith-Oracle)

About Issue 2: Yes the reversible reaction button is fully functional when clicked.

But when output panel is in the minimized state if a query is run it does not realise that a query is run and that it has to maximize itself automatically.
So whenever we use that button to minimize Output panel we need to first maximize it before running queries. The query runs and the output is there in the minimized state but it remains in the minimized state unless we manually maximize it.
Like Show 0 Likes(0)

Actions
6. Re: about query results/script output

nohup Sep 30, 2016 2:07 PM (in response to thatJeffSmith-Oracle)
Jeff Smith Sqldev Pm-Oracle wrote:

I'm not observing the output panels resizing based on run script or execute statement - it's always the same amount of space
Yes output panels are not resizing based on run script or execute statement. Correct.
Please read below cases.

Case 1
Establish a connection
Run script (F5)
Output panel has only Script output which takes 2 inches

Case 2
Establish a connection
Execute (Control Enter)
Output panel has only Query results which takes 5 inches

Case 3
Establish a connection
Run script (F5)
Output panel has only Script output which takes 2 inches
Execute
Output panel has Script output and beside it is now query results. Total screen length of output panel 2 inches

Case 4
Establish a connection
Execute (Control Enter)
Output panel has only Query results which takes 5 inches
Run script (F5)
Output panel has Query results and beside it is now Script output. Total screen lenght of output panel is 5 inches

Observe that there is difference in total screen space consumed by Output panel in case 3 and case 4

Thanks
Like Show 0 Likes(0)

Actions
7. Re: about query results/script output

thatJeffSmith-Oracle Sep 30, 2016 5:21 PM (in response to nohup)

if you want more space for your results, just drag them up?
Like Show 0 Likes(0)

Actions
8. Re: about query results/script output

thatJeffSmith-Oracle Sep 30, 2016 5:21 PM (in response to nohup)

right, if you hide it, it stays hidden until you un-hide it
Like Show 0 Likes(0)

Actions

Go to original post