Model 24.4.1 is now accessible for obtain.
The statusbar on the backside, is displaying my line#:curpos | linked person | connection identify | editor mode | pending transactions | final question execution time.
You already know that SQLcl helps named connections now, similar to in SQL Developer (VS Code!), proper?
A Fast Detour to initiatives
Many of the work accomplished over the previous 3 months was spent optimizing the initiatives function we launched in 24.3.
An individual within the APEX group wrote this submit, however it 100% applies to builders engaged on initiatives which are NOT APEX, as properly! It’s an excellent learn in order for you a break from me!
I’ll simply tease the function right here, however that is undoubtedly the simplest we’ve ever made it to work with an Oracle Database improvement venture, the place it is advisable handle the code behind your database objects and PL/SQL applications.
I can create a brand new venture, whose database objects occupy a number of schemas, and we’ll set all the things up for you.
And then you definitely’ll have a supply and dist set of folders the place you may each preserve straightforward monitoring of variations for the objects as you developer them (src), AND construct a deployment script that will take you from v1, to v2, to v3 (dist).
What your native file system will seem like now –
We use the present Liquibase assist in SQLcl and in your database the place you’ve got deployed initiatives to handle versioning and to supply reporting of who utilized what, the place, and when.
Discover the docs, full with tutorial right here. And we’re engaged on a LiveLab tutorial ASAP.
Okay, onto the subject at hand…
Let’s discuss importing information
This launch provides assist for Excel information through the LOAD command, along with the present CSV loader.
And the earlier launch, 24.3, added assist migrating your Entry MDBs (I received’t name them databases, however they’re kinda databases).
Let’s take a fast have a look at each.
Entry
The command you need to have a look at is ‘mdb’ – the assistance provides you with the remainder.
Then we will select to repeat 1 or all the tables.
Excel
I’ve talked fairly a bit concerning the LOAD function, so that you’ll need to have a look the Docs to get a really feel for the way it works.
The very first thing it is advisable do is ready the ‘loadformat’ parameter such that the load command will know to count on incoming Excel, both xlsx or xls.
So what I really ran was:
--switch listing to LOAD can see/discover my excel information
cd /customers/thatjeffsmith/paperwork
--set load settings to 'xlsx' mode
set loadformat xlsx
--load the information, to a NEW desk, known as RANDOM_TABLE
load random desk export.xlsx newThe SET LOADFORMAT and LOAD instructions have a ton of settings and accompanying HELP.
Be aware that in case your excel file has columns formatted as dates, we’re bringing them over as VARCHAR2s, however this will probably be addressed shortly.
