SQL Developer


problem: sqldev opens new datatab each time i run a query.


When i select in editor a query that i have written and run it, then resultset tab is opened with data for me.
How can i do so, that all queries that i run will show the resultset/data on the one common tab. I don't want that always new resultset tab is opened.
What settings and how should i change?
I have Sql Developer version 2.1.0.63.
Thx. 
This was logged as
Bug 9247525 - otn: worksheet results tab being pinned for f9 exec of selected sql
Workaround : Place cursor on the query, don't select it, and run.
-Raghu 
That solves the problem. Thank you.
--
(
Seems like the rules are like following:
If currently visible/opened resultset tab has (toggle)button "Pin" pushed down, then all queries you run will open the new resultset tab.
If that pin button is not pushed down, then new tab is not opened.
So if you want some resultset tabs to stay, the Pin button should be pressed down, then the new queries will not erase that datatab.
)
Edited by: CharlesRoos on Jan 6, 2010 5:37 AM 
Yes... but when I place cursor on the query (did not select the query) and click run, it executes the whole worksheet and not just the query I want to run. 
You're confused. The workaround is only needed for F5; using F9 you can highlight without duplicating tabs.
K.

Related Links

64bit 2008 R2 keeps asking for Java path
2.1.0.62: Bug editing text columns in multiple rows using editor-window
Wrapping Packages
how to migrate only packages
Data Flow Diagram - Associating Entity or Table with Information Store
2.1 EA1 Various Problems - Case Change/Auto Complete - line paste - & :
2.1 EA1 Export results
How to Change SQL Developer Password!!!
disable auto-capitalization in code editor?
Move selection up/down
SQL Developer and Cur_Type
query executing very slow
MySQL Offline Capture
MySQL Capture Issue
2.1 EA1 - Sometimes opening a package closes another
EA1 - Executing a command with control+enter

Categories

ORACLE DEV
Reports
XML
Oracle Provider for OL...
Business Intelligence ...
Oracle Help Technologies
Customers
Calendar SDK
.NET Stored Procedures
Web Access Client
Berkeley DB Family
XML (Korean)
Oracle CRM On Demand A...
XML Gateway (Korean)
Enterprise Pack for Ec...
PeopleSoft Enterprise
Hyperion Query and Rep...
Product Hub
Oracle Virtualization
Transaction Processing
Packaged Applications
MessageQ
协作套件
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
Workshop Product Famil...
Primavera Contract Man...
WebLogic Server - WebA...
LCM: Oracle Applicatio...
WebLogic Server - JCA
Java EE (Java Enterpri...
Embedded Technologies
Java HotSpot Virtual M...
Networking
Training / Learning / ...
Java 3D
Clustering
JVMTI [ARCHIVE]
Sun Java Wireless Toolkit
General Discussion [AR...
Systems Networking
Oracle FLEXCUBE Core B...
Webservice(SOA) (Korean)
IoT Developer Challenge
Oracle Mobile Security...
Oracle Messaging Cloud...
Marketing Job Board
Throwback Thursday
Eloqua For Sales
Eloqua Users with Sale...
Social Media Hub
CX Central
Markies: Sales Impact
SiteCatalyst
Road to Revenue Tour
Canadian B2B Marketers
Oracle Eloqua Training...
Orphan Threads
BICS Data Visualization
Oracle Process Cloud S...
POUG
UK Oracle User Group
SQLcl
Home of Oracle Certifi...
20 Days of Java in Brazil
Cloud Accelerate
Adopt OpenJDK
Containers
See It
Sacramento, CA Eloqua ...
SQL and PL/SQL
Human Resource Managem...
Technologies ((Korean))
기존 포럼(2006년 8월까지 게시물 T...
Oracle VM Server for x86
EPM System Management ...
开发工具
Archived Newsgroups
weblogic.developer.int...
weblogic.eventserver.g...
Web Application Develo...
Java Compiler (Develop...
Servers General Discus...
Developer Studio C/C++...
Oracle Communications ...
.NET (Japanese)
Do It
Imagine How

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App