Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,791 Comments
v17.4 => Oracle 12.1
TNS_ADMIN
I can connect with SQLPlus using the tnsnames entry
Why is SQLDev spinning wheels?
Who knows. Maybe SQLDev isn’t using the same tnsnames file that SQL*Plus is. You haven’t told or shown me anything that would allow me to help you.
In the worksheet, run…
‘show tns’
Does it list the ‘correct’ TNSNames file?
If ‘yes’, then tell me what you mean by ‘spinning wheels.’
Sorry to not have given you enough information
I am using Windows 10
in the User Environment Variables I have added an Entry for TNS_ADMIN => Directory where the tnsnames.ora file is located
From the command line I get a response from tnsping
D:\KTScase\Dba>tnsping P202
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 – Production on 28-JAN-2018 19:14:41
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
D:\Oracle\Ora12.1.0.2\NETWORK\ADMIN\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kts64)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = P202.knowtech.ca)))
OK (0 msec)
In the Preferences for Database => Advanced, I specify use OCI Thick Driver and point to the same directory for TNSNAMES Directory
Who knows. Maybe SQLDev isn’t using the same tnsnames file that SQL*Plus is. You haven’t told or shown me anything that would allow me to help you.
In the worksheet, run…
How does one open a worksheet without connecting to any service??
‘show tns’
Does it list the ‘correct’ TNSNames file?
If ‘yes’, then tell me what you mean by ‘spinning wheels.’
There is a little bar at the bottom showing Running and the blue spot keeps moving left to right and back
Currently, I am trying to open a connection by clicking on the + . A folder symbol appears with Loading … and the spot is moving from left to right and back
Your connection is working. The ‘loading’ message means that we’re in your db, and running a query to get a list of tables.
Disable the thick connections option in preferences – you probably don’t need it – and try again. Also, open the View > Log panel. There should be a statements pages there. It will show which query is hanging.
This in the logging page
SEVERE 223 0 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.javatools.editor.BasicView.revalidateRowMap(BasicView.java:1546)
Yeah, that’s not good. What about the statements panel? If your group has an Oracle Support account, I suggest opening a Service Request for this.
I do not have a Support Account. I am just using a local database to try things out.
Again, what about the statements panel?
How do I get to the Statements panel? All I see is Log and Task in the View Menu
On another environment against Oracle 12.2
LEVEL SEQUENCE ELAPSED SOURCE MESSAGE
—— ——– ——- ——————————————- ——————————————-
SEVERE 1355 0 oracle.dbtools.raptor.phighlight.TableAdvice Failed to obtain database connection
SEVERE 1354 251253 oracle.dbtools.raptor.phighlight.TableAdvice select owner,object_name from all_objects
where object_type in (‘TABLE’,’VIEW’)
and object_name in (?)
Yeah, that’s not good. Something isn’t right.
How do I cleanly uninstall SQL Dev and then reinstall from scratch?
Di I need to get rid of nything in the Users directory — ..\Roaming?
I work for a corporation which has Oracle 12c, 11g, etc.; My role is developer. The corp requires 3rd party software to be vetted before it is permitted to be installed on its desktop workstations. I am the Oracle SQL Developer “sponsor” and a user of this product. One of the benefits I cited when promoting its use is that is supported with an enterprise license. I am now the product “owner” and the 1st point of contact for questions from anyone. I assume that the preferred forum for posting reproducible bugs is “My Oracle support” and I do not have an account. Using my pubic account, Ive posted to both SQL Developer Forum & Exchange ( someone kindly added two of them to “Bug -Log in Metalink”.) As an employee of an enterprise customer ( with multiple Oracle versions & licenses) I would prefer to use the “My Oracle Support” for reporting reproducible bugs rather than the public forum. Can you suggest a course of action how to get an account?
Who at your company has a MOS account for your 12c, 11g, etc. databases? Adding your name to the MOS account list should be easy.
Jeff,
How can I ignore storage details on when comparing my Relational Model to my DB? Thanks.
Two options to disable on the Compare
What you’re seeing.
Do this.
Ta-da.
Hope this helps!
Perfect! Thank you.
Hi Jeff,
stumbled upon your site and will be a regular reader from now on….
I have one question for you.
it is about the Gutter in SQL Developer.
when viewing or writing code, using the default syntax color, the gutter shows a blue-ish highlight to show the code that ‘falls’ within the block you are in. Moving the mouse over in the gutter, we get a thin blue line identifying the block or sub-block (whilst the blue-ish highlight exists as well) . This is great, especially trying to read-decipher existing ‘complex’ code
.
However, im quite fond of the twilight syntax. when using the twilight syntax highlighting, the highlight color of the gutter to identify the current block is the same blueish color as the default syntax , this making it ‘invisible’ againest the black background color of the gutter . moving over the gutter with the mouse still gives the blue thin line to identify the block or sublock which is fine….but the real ‘problem’ is the high light of the gutter. i have checked in the preferences but cannot alter this behaviour…. any ideas please !
Thanks,
George
Welcome!
Preferences > Code Editor > Line Gutter. ‘Use Custom Colors,’ and change the background color.
Goodmorning Jeff (morning in US I Believe)
Thanks for your brief reply.
however this does not do the trick. Maybe its my fault, as what i am describing is not the actual Gutter,
but rather the thin strip on its right side, and on the left of the dotted vertical line !!!
its where the boxed + or – appear for expanding and collapsing the code blocks !!!
I hope i make myself more clear now.
sorry for throwing you of course with the ‘gutter’ !!!
Show me a picture, so I can see what you’re seeing.
hi
I hope this comes through.
i have painted arrows. the top and bottom ones show the bleuish identification of the block the cursor is clicked in.
you can also see the thin blue line if you move the mouse in the thin strip area .
the bluish line for clikcing in the code is visible (in the default syntax) and you also get an overlay of the thin blue line. so you can still see general – outside block with the shaded bluish background and the sub blocks with the thin line.
lets see…
https://drive.google.com/file/d/1TDJ7GzBX3zyyqhGF3iSwo0yuZJquKLRJ/view?usp=sharing
Ok, that is hard to describe, thanks for the picture!
I don’t have an answer unfortunately. I also don’t see a way to control the display of that particular 4 pixles-wide bit of the editor itself
Hi,
Used to use version 4.2 of SQL Developer…
Now our DB is hosted on Oracle 12c, and would like to use the latest version 17.x.
How can I migrate my preferences and connections info to the new version?
can’t figure that out… thanks
You don’t have to do anything if you’re on the same machine. When you start up 17.x, it will ask you if you want to migrate your stuff from 4.2. Just say ‘yes.’
How do you create a connection in sqldeveloper using a proxy?
The proxy has been created and I can login outside of sqldeveloper using the format me[proxy_name]@db_name successfully.
You should be able to do the same in SQL Developer, see today’s post.
I need to know how can I execute in background one SQL query in SQL Developer.
Open an unshared worksheet, run your query there. You’ll be free to use the UI to do other things in your database.
But, If I try to execute the query, and close the sql developer, the query still works? or it’s killed. I need to execute the query in the server, not in the client…
The only way to guarantee what you want is to login to the server and write a nohup shell script for sqlcl or sqlplus
Or…you could write a database job to run the query.
Hi Jeff,
When upgrading from 17.2 to 17.4, do we need to download the version with the JDK or can we simply use the non JDK version since the JDK is already installed from a previous version install?
Looks like the JDK version has sqldeveloper64W.exe and the non JDK has sqldeveloper.exe.
Is there a difference. It looks like the non-64W version utilizes less memory.
Thanks,
David
Both packages contain both versions of sqldeveloper. So my question should be, what’s the difference. We are using on Windows Server 2012.
Thanks
we don’t install any jdk. we EMBED a java home inside the zip…nothing else can use it but that copy of sqldev
so if you only have java from the embedded jdk’s then you would ALWAYS have to grab the sqldev with the embedded jdk
stay out of the bin directory, just run the EXE in the top level dir
Thank you.
Hello, Im a beginner on SQL, self taught, and learning a lot from your page. That said, I need to load a lot of data from excel to my Oracle database. I read all your posts about the different methods BUT my problem is I am not able to preview the data as my excel file has 60,000 rows. I get the error message GC overhead limit exceeded. I do use xlsx format. What is the best approach? reduce the size of the file somehow?
Thanks,
Update. Just by converting to CSV file I was able to preview and import some of the data. Not all. Despite defining every column type and size, there were error messages related to data exceeding the size limit for them. Will try again…
Hi Jeff,
it’s not possible to modify a tables partitions by clicking on edit table, after installing the latest version of the SQL Developer 17.4 . The entry “Partition” is not visible anymore in the menue. Is it a bug?
Regards
Ulli
My range partitioned table works just fine. Can you share the ddl, so I can try to reproduce? And what version did you have previously where it was available?
The previous version was 17.3.1.279. The current version is 17.4.0.355. There was an entry in the edit table menue on the left hand side, together with other entries like Columns, Constraints,…
All other entries are still there in the new version, but no way to edit the partitions at all? We can only add or modify the partitions when creating the table.
——————————————————–
— DDL for Table PARTITION_TEST
——————————————————–
CREATE TABLE “ZPDB”.”PARTITION_TEST”
( “COLUMN1” NUMBER
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “T_PUFFERDB”
PARTITION BY RANGE (“COLUMN1”)
(PARTITION “PARTITION1” VALUES LESS THAN (10) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “T_PUFFERDB” ,
PARTITION “PARTITION2” VALUES LESS THAN (20) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “T_PUFFERDB” ,
PARTITION “PARTITION3” VALUES LESS THAN (30) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “T_PUFFERDB” ) ;
Yeah, your table works just fine for me. I’m on Oracle Database version 12.2.0.1.
View > Log > Statements. Observe what the Edit dialog runs to build the screen. Take those queries, and run them in a SQL Worksheet. Any problems?
We are using 11.2.0.4 with the latest patches.
It seems to be a problem with the query to get the parameter “PARTITIONED”?!? There is a missing comma between “…EXTERNAL_TAB” and “‘N’ SHARDED…”!
Please see the findings below:
Error : “java.sql.SQLSyntaxErrorException: ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden
” building PARTITION_TEST, executing sql:
SELECT /*OracleDictionaryQueries.ALL_TABLE_TYPE_QUERY*/
A.TEMPORARY, A.DURATION, A.IOT_TYPE, A.PARTITIONED, A.NESTED,
( SELECT 1 FROM SYS.DBA_EXTERNAL_TABLES E WHERE E.OWNER = A.OWNER AND E.TABLE_NAME = A.TABLE_NAME ) EXTERNAL_TAB
‘N’ SHARDED, ‘N’ DUPLICATED
FROM SYS.DBA_TABLES A
WHERE A.OWNER = ? AND A.TABLE_NAME = ?
This one works fine:
SELECT /*OracleDictionaryQueries.ALL_TABLE_TYPE_QUERY*/
A.TEMPORARY, A.DURATION, A.IOT_TYPE, A.PARTITIONED, A.NESTED,
( SELECT 1 FROM SYS.DBA_EXTERNAL_TABLES E WHERE E.OWNER = A.OWNER AND E.TABLE_NAME = A.TABLE_NAME ) EXTERNAL_TAB,
‘N’ SHARDED, ‘N’ DUPLICATED
FROM SYS.DBA_TABLES A
WHERE A.OWNER = ‘ZPDB’ AND A.TABLE_NAME = ‘PARTITION_TEST’;
Is there any simple way to fix it?
OK, so that query is wrong for a non-12c db. It’s already been logged as a bug on 17.4 and FIXED for 18.1 – which will be available later this quarter.
In the meantime, best to work with v17.3 of the tool to get around this current limitation.
In Sql 4.2.0.1 I can’t copy and paste into a script row. When I click on the row the first word in the row is highlighted. In older versions the first word wouldn’t highlightc rather, the cursor would click into a space in front of the first word and then I could add content as needed. Gosh. I
In 17.4, I just ran via F5
SELECT * FROM HR.EMPLOYEES
In the script output, i triple-clicked to select the row.
Ctrl+C
And now I paste here…since you can’t see me paste into my worksheet.
100 Steven King SKING 515.123.4567 17-JUN-87 AD_PRES 24000 90I have the selected info that I want to paste but I can’t get the cursor to sit where I put it so I can copy and paste in front of it. I am adding to a row but when I click on the row the first word is highlighted and I can’t paste in front of the first word.
>>cursor to sit where I put it
Where exactly? The script output window is a display, you can’t paste down there.
Where are you trying to paste to?
How do I unsubscribe? The link in the emails does not work. Please unsubscribe me from everything. Thanks.
Ok, you’re out. Sorry for the SPAM, and let me know if you need anything else.
Hello experts,
I cannot find out a difference between to kind of exporting data from Oracle SQL Developer.
When I exported Query from Oracle SQL Developer manually and then import this output to MS Access, there is no problem here.
I create BAT file with SQL PLUS commands , which execute this SELECT with this parameter :
set termout off
set tab on
set colsep “;”
set pagesize 0 embedded on
set linesize 8000
SET FEEDBACK OFF
set underline off
SET TRIMSPOOL ON
spool C:\…..\MY_Output.txt
SELECT
;
spool off
Then I import this output file to MS Access, system show me this message : The search key was not found in any record”
I try to google it, but I do not find any relevant answer for my issue. Can you please help me ?
thank you
Tomas
What are you trying to do? Export data from Oracle to MS Access via a CSV file?
Yes, I try to import data to MS Access via CSV file or txt file. When I do it manually, everything works well, when I try to automate this proces by sql plus executed by BAT file, system show me this error message in MS Access, so I think it related with SQL PLUS command.
I’m here to help folks with SQL Developer and SQLcl – not with SQL*Plus. And DEFINITELY not with Access.
Good luck.
Hello,
I would like to ask how to generate e.g. table names in DDL script in lowercase/uppercase/ … ? I generate script from Data Modeler.
An hour ago I had found such option somewhere and I changed it to lowercase and it works. There were also other options (uppercase/mixed/”keep as it is”, etc.), unfortunately I’m not able to find this setting again.
Thanks in advance.
Regards,
PeterR
… already found … 🙂
Tools -> Preferences -> Code Editor -> Format (for SQL Developer v17.4)
Is there a way to have SQL Developer give a warning when I forget my forward slashes on PL SQL code blocks?
Not that I know of…but a parser warning indicator might come in handy. I’ll ask the dev tomorrow…problem is trying to eval legit SQL vs what SQL*Plus expects.
Agreed, I thought as much. I look forward to any additional info the dev might have.
Jeff,
Any plans to allow the Query Results tab to act as a floating window? Sometimes I need to move the results to my large, portrait oriented monitor. I’d rather continue my workflow in SQL Dev than export to Excel.
Connor
No, it’s a customized editor type in the framework…which means it does what we need, but it also means it’s REALLY hard to let it do things like this, without breaking other stuff.
I cannot see in the Navigator tree synonyms for other users.
My account has grants to use the synonyms and related objects in the other schema, I can run SQL statements to use the data, and I can see the list of available synonyms when I query ALL_SYNONYMS .
But when I expand the Navigator tree, go to “Other Users”, select the other schema, and select the node “Synonyms” the list is always empty. The node “Tables” under the other schema shows the available tables. I have filtered the tables (under the other schema) and enabled “Include synonyms” but it did not make any difference. It looks like the option to “Include synonyms” works only in the node “Tables” of the current account.
Am I missing a setting? I see the small problem in two versions 4.1.5.21 and 17.3.1.279
Thanks
Witold
If i go to Other Users, Synonyms tree, and expand – I see the synonyms for that schema.
This is the SQL we run
If you don’t have access to the DBA_ views, it’ll fall back onto ALL_ views.
Thanks for the quick reply and SQL.
I will have to work with DBAs to check permissions. I don’t have access to DBA_OBJECTS and ALL_OBJECTS does not show me the synonyms from the other schema. But ALL_SYNONYMS has the synonyms. It looks like something is filtered out in the query for ALL_OBJECTS
Thanks
Witold
Is using the Save Password option on a connection with the SYSDBA role considered to be safe by Oracle?
I don’t speak on behalf of Oracle.
But.
Is your machine secure? If it is, you’re fine. If it’s not and you think someone other than you can get access to your machine, then you shouldn’t save any passwords.
Or let Google/Chrome save your passwords.
When you say “someone other than you can get access to your machine” , do you mean with my Windows login and password?
If they got the file that has the passwords, could they import it and use it?
Are the passwords themselves encrypted in a manner that is very difficult to decrypt?
Yes, you’re in trouble if someone without authorization can get into your machine.
If it weren’t considered safe by us, we wouldn’t offer the feature. You need to decide if the feature is safe for you.
We do encrypt the passwords. You can’t simply copy the connections file off of someone’s machine and use it – we’ll strip out the passwords unless you use the connection export/import routine in the UI.
Good afternoon from Australia
Using:
Java(TM) Platform 1.8.0_151
Oracle IDE 17.4.0.355.2349
Just updated to 17.4. All went smoothly. Connected to one of my 11GR2 databases and in the DBA section then chose Security/Users and get
An error was encountered performing the requested operation:
ORA-00904: “ALL_SHARD”: invalid identifier
00904. 00000 – “%s: invalid identifier”
*Cause:
*Action:
Vendor code 904
Although I can continue every time I select the General tab of Users I get the same error.
A bug or do I need to make a change elsewhere?
Kind regards
Steve
Hi All
Minor update: Installed this on Windows 10 and Widows 7 desktop machines with the same result.
Regards
Steve
it wouldn’t be OS specific, it’d be a bug with 17.4. if it’s too annoying, go get version 17.3.1 instead
No, it sounds likes a bug. Can you report this to My Oracle Support?
Will do
Thanks for the feedback.
Regards
Hi Jeff,
I am using Oracle SQL Developer 17.3.1.279 and would like to copy my query from the Developer to MS Word keeping the query ‘formatted’ when I paste it into Word. (keeping the colors/fonts). Unfortunately, when I paste the query into Word, it drops the formatting. I’ve searched the blogs for a resolution to this issue, but have been unable to find the answer.
Can you tell me how to keep the SQL Developer format (font/colors) of the query when copying/pasting into another application such as MS Word?
You can’t. It’s an open enhancement request.
Hi Jeff,
The enhancement request that I referred to in my first post was #45481 – the ability to catch PLSQL named exceptions in the unit tester.
I hope this helps,
Mark
Hi Jeff,
The following link explains it better than I ever could:
https://oracle-base.com/articles/12c/code-based-access-control-12cr1
Basically I want to be able to create CBAC roles and the grants to PL/SQL program units directly in the model as they form part of the application scheme design. It would also be good if these objects could be generated as DDL.
I hope this helps,
Mark
Hi Jeff,
Any more news on this enhancement for supporting code-based access control?
Hi Jeff,
I have noticed some more enhancements in addition to the granting of roles to stored PL/SQL units that would aid the modelling of an application that uses the smart-database model and CBAC:
*) When comparing two models, the tool identifies objects that have been created/modified/removed and it is possible to generate the differential DDL. For some reason role objects whilst are identified as different, are not considered for DDL generation. I wonder if other objects are also excluded in compare mode?
*) Support for granting roles to users in DELEGATE mode rather than ADMIN.
*) A way of generating an editioning view based upon a table definition for the purposes of EBR.
Do you see the benefits of the above and will they make their way into the product?
Many thanks in advance,
Mark.
I don’t see much uptake in these features, or even folks asking for the support. For now, it’s you. Some of this can be done already with custom scripting that the tool supports. Have you considered asking for help building those in the forums?
Hi Jeff,
I know this question is quite old, but I was wondering whether 18.2 of SQL Data Modeller would support code-based access control?
18.2 Data Modeler just has bug fixes, no new features of note.
Hi Jeff,
I am currently using Oracle SQL data modeller 17.3 and am trying to set up an Oracle 12cR2 physical model to support code based access control and invoker rights.
I can create roles and am able to assign privileges to that role but I cannot find a way to assign the role directly to a procedure/function/package definition which is required for CBAC to work. Is there a way to do this in the tool or is it a feature request?
Slightly off topic, is the Oracle SQL developer exchange still active? I posted some feature requests back in August that haven’t changed status (as far as I can tell anyways).
Many thanks in advance and keep up the good work!!
Mark.
Hi Jeff,
Do you have any thoughts on this please?
Many thanks
Mark.
>>to assign the role directly to a procedure/function/package definition
I read this and immediately thought, I don’t think you can assign a role to a PL/SQL object. I’m happy to admit I’m wrong though – can you show me a docs link describing what you’re looking for?
Hi Jeff,
I have an issue with the SQL DEVELOPER unit test repository. I am running a unit test against a function that returns REF CURSOR. I do not need to test the returned REF CURSOR data so have left the ‘Test Result’ box unchecked. This succeeds until I attempt to run a subsequent ‘Process Validation’ step, when I then get the error below. Please advise.
Regards,
Steve.
The following procedure was run.
Execution Call
BEGIN
:1 := “SETUP”.”RPT_GL_PKG”.”SPS_BALANCE_EXPORT”(P_SYSCM=>:2,
P_GLP=>:3);
END;
Bind variables used
:1 REF CURSOR OUT (null)
:2 NUMBER IN 1
:3 NUMBER IN 155
Execution Results
ERROR
: Expected: [Any value because apply check was cleared], Received: [SYSCM GLP ACCOUNT_NUMBER SEGMENT0 SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 ACCT_DESC ACC_TYPE TYPE_DESC PTD YTD PRIOR_PTD PRIOR_YTD
—…
]
Validation User PL/Sql Code failed: Unable to convert to REF CURSOR.
Hi,
is it possible to auto add db link after table name, for example:
SELECT * FROM APPS.AP_INVOICES_ALL@db_link1
something like alter session.
No, insight isn’t setup today to support that, but it’s not a half bad idea.
in my opinion ist 100% good idea to add this option into connection setup