Many new features have arrived to make our lives easier in this new release of Oracle APEX 23.1!
In this opportunity I want to show you the new SQL Workshop Object Explorer.
The change has been made, according to the APEX development team, because they are thinking about something more powerful in the future and to work on it they needed to change internally how to work with the object browser, mostly for technical issues, with this we see that more changes in this feature are coming 🙂
Let's see how the Object Explorer looks now, compared to how it looks in version 22.2.
As we see the new Object Explorer, we have at hand all the most used objects to be able to create, modify and work with the database objects.
If we want to create a table or any other object a modal window opens and there we can enter all the information of the table and everything is much more simplified!
Clicking on the SQL Preview button shows the SQL script that will be executed to create the demo table in this case.
When creating the table we see all the information that we could see before in the previous version.
The difference is that the REST tab is no longer available in the object browser but has been moved to the RESTful Services module, since that module is where you work with everything related to REST.
For this purpose, a button has been added that allows us to select the object, whether it is a table, view, package, procedure, function or materialized view, to enable it.
Also something very interesting is that we can see and filter the objects of all types of the database easily, from a single tree.
On the other hand, something that I have used many times and that is now unavailable is to be able to select the name of the columns and be able to copy. I thought you could not copy column names but you can!
https://www.linkedin.com/in/monicagodoymillan/ who is Product Manager of APEX, told me that we can select the columns and do Ctrl + C to copy and Ctrl + V to paste where we need it! We don't use the mouse but we use the key combinations to copy and paste! That's great!
Last but not least to mention is that now in this version a link was added in the SQL Workshop module that allows us to enter the SQL Developer Web directly, yes, the schema must be enabled to RESTful Services, in case it is not enabled, a message will appear for us to enable it, then we register the schema with ORDS and finally we will have access to the SQL Developer web.
It should be noted that in the free instance of apex.oracle.com this functionality is not available for obvious reasons :).
Te dejo el enlace a una demostración sobre el Explorador de Objetos:
Conclusion
I really like being able to see and filter all the database objects in one place and not having to be always selecting whether it is table, triggers, sequence, view, etc, that really speeds up the work when one needs to quickly search for a database object to work on.
I invite you to continue exploring the new features of Oracle APEX 23.1 that promise to be very, very interesting!
See you soon!
Hola buena tarde, tengo una inquietud referente al theme Redwood Ligth el cual no permite la visualizacion de imagen de fondo en la forma de Login. Existe alguna forma de poder visualizarlo a diferencia de los otros theme que si lo permiten.
Saludos desde Panama
Hola Ariel, puedes subir una imagen a los archivos estáticos de la aplicacion y luego colocar este CSS inline en la página del login:
.t-Login-bg {
background-image: url(#APP_FILES#bg.jpg);
background-repeat: no-repeat;
background-attachment: fixed;
background-size: cover;
}
Saludos
Clarisa