How to added the SQL query used generate the excel file in DATAGRIP IDE?
I'm a SQL developer user, usually, I extract data from Oracle database and store them into excel files on a daily basis, the nice thing about Oracle's SQL Developer when exporting the file into excel file, you get two worksheets one for your data, and another worksheet contain the SQL query that used to generate this report.
Now I'm using DATAGRIP IDE from JetBrains, I noticed when I export the file into excel sheet I only get the data and I don't the SQL query that I used to generate this excel file.
is there any way to add the SQL query to the exported file?
There is no possibility to include the SQL tab automatically. But every grid has it's own "View Query" option where you can see and copy the needed SQL.
To have this tab, please create a feature request here: https://youtrack.jetbrains.com/issues/DBE
- How to replace null values with a text?
- Microsoft SSIS - Issues switching from attunity driver to new Microsoft Oracle Connector v1.3
- Writing SQL Query With Same Client ID , same Tax_year, same Tax_effective_date But with Different Tax_id & Payroll_ID in ORACLE SQL
- Oracle XE installation aborts with no error explanation
- How to process tabular data from Oracle PL/SQL function in JAVA?
- How do you execute SQL from within a bash script?
- How to connect to Oracle 8i using Java
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- 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
- 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'