oracleoracle-sqldeveloper
How to change query type for drag and drop action in SQLDeveloper
In SQLDeveloper there is a feature which generates query when you drag and drop table from connection browser to worksheet. There is a window which asks if one want select, update or delete query to be generated. I've marked once select and checked the box to not ask again. Now when I drag and drop I got always select without pop-up window.
How can I change query that is generated (I need insert not select) without reinstalling SQLDeveloper?
Solution
Go into the preferences. Database page. Then on 'Drag and Drop.'
- How to sort all numbers before letters with linguistic sorting?
- Oracle Sql Statement for unique timestamp for each row
- ambiguity error when adding pivot to existing SQL oracle statement
- Within PL/SQL script create table based on Oracle Edition
- Connect to sqlplus in a shell script and run SQL scripts
- Oracle SQL hierarchical query data accumulation
- Does Oracle field contain all letters from a string?
- Oracle JSON_TABLE to PostgreSQL - how to search from the second hierarchical key in a JSON column
- ORA-00902: invalid datatype with EF Core
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- SQL query to get the employee who has not been appraised
- TOAD for Oracle, variables for schema/ table names
- ORACLE APEX ADMIN LOGIN ISSUE
- Fetch last row for each month, or previous month if not found
- How to update/add large amount of data into Oracle database from ASP.NET Core
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- Why my query to select from Oracle database turn to text (blank query) every time i run it
- Oracle ORA-00902 Invalid datatype error
- Check if Advanced Compression is available
- Strange full table scan statements in Oracle
- Options to enforce a logical constraint in an Oracle database
- How to sort numbers before letters with linguistic sorting?
- Oracle Trigger Creation Error: PLS-00049 BAD BIND VARIABLE 'OLD'
- plsql script is raising 'ERROR at line 1 DECLARE', I don't see the reason
- Update table column based on join in Oracle
- Oracle Apex - Download CSV produces an empty report
- SSIS - the value cannot be converted because of a potential loss of data
- Filtering duplicate values, searching for pairs
- Trying to filter a sql report by a range of numbers
- Adding html target attribute to APEX tree link