Oracle SQL Developer Tool 19c- Mastering Tips & Tricks

Download Oracle SQL Developer 19c from the Oracle site, install with JDK if needed, sign in or create an Oracle account, unzip and run the exe to open SQL Developer.

Learn how to create your first database connection in Oracle SQL Developer, including host, port, SID or service name, user, and how to test the connection.

Explore the Oracle SQL Developer 19c interface by mastering its key components: object navigator, reports, data modeling, worksheet, and script output or results windows.

Increase the gui font size in oracle sql developer by editing ide.properties to 15, improving visibility of emp table’s columns (empno, job, ename, mgr, hiredate, sal, comm, deptno).

Increase the font size for the worksheet and results grid in Oracle SQL Developer Tool 19c. Open Tools > Preferences > Code Editor > Fonts and set a larger font.

Enable zebra pattern in Oracle SQL Developer Tool 19c to create a grid with alternate row colors in worksheet output by selecting tools, preferences, database, worksheet, and zebra pattern.

Navigate to worksheet via the connections view or SQL Worksheet button (Alt+F10), select a connection like scott, then run a query. Reset Windows, then use File > Exit.

Learn to create database objects—tables, a view, and a procedure—within the user_demo schema, using run scripts, committing or rolling back data, granting privileges, and refreshing the object navigator.

Reset the Oracle SQL Developer layout to factory settings by choosing Window > Reset Windows To Factory Settings, restoring the object navigator, query results, and worksheet to their original arrangement.

Master color formatting of connections in Oracle SQL Developer 19c by labeling dev, UAT, and prod with distinct colors to prevent mistakes when switching between environments.

Master code formatting in Oracle SQL Developer Tool 19c by learning to align keywords, identifiers, and aliases, manage whitespace, and apply advanced formatting options.

Learn to use the code snippet and create your own templates in Oracle SQL Developer 19c, exploring numeric, null, and PL/SQL functions for reusable templates.

Learn essential shortcuts in oracle sql developer tool 19c to speed coding: format with ctrl+f7, go to line with ctrl+g, view structure with shift+f4, and use code helper with ctrl+space.

Group connections in Oracle SQL Developer Tool 19c by creating folders for development, prod, and uat, adding SYS and user accounts, and testing connections to segregate schemas by environment.

Master oracle sql developer 19c by learning how to select specific columns from emp, arrange them, and export to csv or generate insert scripts with headers and delimiters.

Generate an html report from the employee table by exporting to test.html on the d drive and view the resulting html file with all columns and data.

Master debugging in Oracle SQL Developer 19c by using the line gutter to show line numbers, toggle them, and copy code blocks with control-drag for efficient error resolution.

Discover how SQL history in Oracle SQL Developer Tool 19c stores and timestamps all executed scripts. Access, spool, and reuse historic queries from the country table example.

Identify which database objects depend on a table by querying the data dictionary, such as user_dependencies, to see how changes to employee affect synonyms, procedures, and views.

Learn to debug PL/SQL procedures and packages using Oracle's debug tools, set breakpoints, step through code, inspect variables with smart data and watches, and diagnose runtime errors.

Master how to add watches to variables and data while debugging in Oracle SQL Developer Tool 19c, and observe how smart data tracks changes as you step through code.

Connect to MySQL, SQL Server, Sybase, and MS Access databases from SQL Developer by installing third-party JDBC drivers, configuring them in Preferences, and creating new connections to view data.

Connect to heterogeneous databases and migrate a single MySQL table to Oracle by copying it to the UAT schema, then verify via a select showing three records Ram, Shyam, Hari.

Learn to use the database difference tool in Oracle SQL Developer 19c to compare two schemas, generate delta reports, and synchronize new or changed objects.

Create and schedule Oracle jobs in SQL Developer using PL/SQL blocks or stored procedures, set minutely intervals, monitor runs, and apply required sys grants for the scott schema.

Learn to generate and view explain plans in SQL Developer, compare script output with the gui, and interpret plan details such as object name emp, cardinality 7, and cost 2.

Enable autotrace in SQL Developer, run a sample query, fix privilege errors with DBA scripts, reconnect, and view the auto trace execution plan.

Explore data modeling by defining entities (tables) and attributes (columns), create an ERD, and perform reverse engineering by importing a schema's data dictionary.

Forward engineer an oracle er model by creating tables, defining columns, and establishing primary and foreign keys, then generate and run the oracle script to build objects.

Create user defined reports in SQL developer by building graph and drilldown reports, master and child reports, and using bind variables like :deptno to reveal department and employee details.

Create and customize a user-defined report to build pie and bar charts, grouping by department with salary as the value, then export the chart to HTML.

Create a master-detail gauge report with a single column value; build a child query with sum(sal) by deptno, set min 0, max 10000, and export to html.

Export charts and reports to an XML file using save as for backup or sharing. Import the XML by opening it in SQL Developer to restore a report.

Export the dept_emp_gauge html report from Oracle SQL Developer Tool 19c and share it by placing the file and its folder on a shared or intranet location for stakeholders.

Learn to change the SQL Developer 19c language from English to French by editing ide.conf and setting the user language to fr, then restart; revert to English.

Hide unused objects in the Oracle SQL Developer navigator using the navigation filter. Enable the filter in preferences, exclude items, apply, and reconnect to verify the changes.

Export and import Oracle connections to back up or share configurations, choosing whether to encrypt passwords with a key or omit them during export and re-import.

Learn to selectively exclude features in Oracle SQL Developer 19c to create a lighter, faster tool. Understand interdependencies to avoid breaking functionality when disabling options like Data Miner and OLAP.

Define the BRD requirements to automate employee reports, generate date-stamped csv files on a server, track ETL job status, and notify stakeholders via email using Oracle jobs.

Learn Oracle SQL Developer 19c tips to set up folders and directories, create procedures and packages, generate data files, manage tables, and implement email notifications with logging.

Install Oracle 21c express edition and explore the multitenant architecture, including the pluggable database. Create a demo account for practice while following the Oracle site download, extraction, and setup steps.

Explore the Oracle multitenant architecture, comparing non multi-tenant and multi-tenant databases, and learn how a container database with pluggable databases shares resources and supports common and local users.

Create a demo pdb in 21c from seed, set up a local and a common user with grants, and connect via sql plus and sql developer to validate access.