ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #sqldeveloper
Learn how to export SQL Developer query results to CSV, Excel, or other formats using the Data Export Wizard and reuse settings with saved templates.
Use SQL Developer's Database Cart to drag schema objects into a named cart, export DDL and data as scripts, and deploy them to new environments with validation checks.
SQL Developer's Explain Plan shows an optimizer prediction; Autotrace shows what actually ran. A practical workflow for validating query rewrites using consistent gets, plan comparison, and DBMS_XPLAN.
SQL Developer's Export Wizard defaults to INSERT statements, but that format fails catastrophically at scale. This post walks through format selection—INSERT vs Loader vs CSV—with a 10,000-row worked example, delimiter pitfalls, and a verification checklist you can run today.
An architecture note covering the three-phase pipeline trust boundaries and operational validation for offline database migration to Oracle.
SQLcl replaces SQL*Plus with JavaScript/TypeScript scripting, embedded Liquibase, and JSON output — making Oracle automation work in modern CI/CD pipelines. Includes a worked example and the trade-offs you'll hit.
Learn how to use the Oracle SQL Developer Export Wizard to move targeted subsets of data between environments using portable SQL Insert scripts.
SQL Developer's built-in formatter supports portable XML profiles. Define indentation, keyword casing, and comma style once, share the file, and enforce consistency via Ctrl+Shift+F or the sdcli command-line tool in CI.
Oracle SQL Developer's Export Wizard replaces hand-written spool scripts for moving table data to CSV. Here is how to use it, verify the output, and automate it with sdcli.