Questions AND answers from today’s masterclass series on Data Modeling for DBAs – using Oracle SQL Developer Data Modeler.
How to launch Oracle SQL Developer connections from the command line.
New features and look for SQL Developer Web in the Oracle Cloud Autonomous Database.
How to set JVM flags or change the user interface language for Oracle SQLcl.
Detecting SQL injection in your PL/SQL with Oracle SQLcl, your modern command line interface for the Oracle Database.
Working with your Oracle Database in the Oracle Cloud is as easy as opening your browser – you can even open a shell prompt and start using SQLcl!
The Oracle SQL Developer team is looking to hire a developer! If you know your way around an Oracle Database and have experience with Java and web apps, please take a look!
Because the code is shared amongst our Oracle database tools (SQL Developer, ORDS, SQLcl) – many of the features you love in one tool, work just as expected in the others.
Oracle REST Database Services (ORDS) makes the full power of the Oracle Converged Database available via the world’s most popular interface – HTTP(s).
Yes, yet another Tips & Tricks post for Oracle SQL Developer.
These are the most very basic tips (5) you need to know when getting started with Oracle’s #1 development, query, and administration tool.
A quick walk through of the enhancements for the LOAD command in Oracle SQLcl version 20.2.
You’ll at some point need to use a DATE as a predicate to get an item or collection of items out of your Oracle Database REST APIs. Here’s our least favorite, yet most common example, HR.EMPLOYEES. HIRE_DATE – when did you start working here? Let’s build a RESTful Service that lets me pull ALL of the employees hired on a certain DAY. Step One: Define the Template Step Zero would be to define the module,…
How to import your AVRO, JSON, and XML data into Oracle Database tables using Oracle SQL Developer Web.
With Oracle REST Data Services version 20.2, you have a TON of new end points available to help manage and monitor your Oracle Database. Here’s a quick tour.
In fairness, it’s really only 8 lines of code, but @krisrice is a fan of comments. Here’s the setup: I have a query I want to run, where I can dump out a BLOB column in my table to separate files. And I need to automate this.A customer, in not so many words, more or less Using the SCRIPT command in SQLcl SQLcl will let you run whatever SQL or PL/SQL you want. And it…