{"id":17219,"date":"2023-04-28T18:04:44","date_gmt":"2023-04-28T18:04:44","guid":{"rendered":"https:\/\/kiusi.com\/?p=17219"},"modified":"2023-07-07T17:07:24","modified_gmt":"2023-07-07T17:07:24","slug":"oracle-apex-23-1-nuevo-explorador-de-objetos","status":"publish","type":"post","link":"https:\/\/kiusi.com\/en\/oracle-apex-23-1-nuevo-explorador-de-objetos\/","title":{"rendered":"Oracle APEX 23.1 - Modernized Object Browser"},"content":{"rendered":"

Many new features have arrived to make our lives easier in this new release of Oracle APEX 23.1!<\/p>\n\n\n\n

In this opportunity I want to show you the new SQL Workshop Object Explorer.<\/p>\n\n\n\n

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 \ud83d\ude42<\/p>\n\n\n\n

Let's see how the Object Explorer looks now, compared to how it looks in version 22.2.<\/p>\n\n\n

\n
\"\"<\/a>
Oracle APEX 23.1<\/figcaption><\/figure>\n<\/div>\n\n
\n
\"\"<\/a>
Oracle APEX 22.2<\/figcaption><\/figure>\n<\/div>\n\n\n

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.<\/p>\n\n\n\n

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!<\/p>\n\n\n

\n
\"\"<\/a>
Create a table in the new Object Explorer - Oracle APEX 23.1<\/figcaption><\/figure>\n<\/div>\n\n\n

Clicking on the SQL Preview button shows the SQL script that will be executed to create the demo table in this case.<\/p>\n\n\n

\n
\"\"<\/a>
Preview SQL Script<\/figcaption><\/figure>\n<\/div>\n\n\n

When creating the table we see all the information that we could see before in the previous version.<\/p>\n\n\n

\n
\"\"<\/a>
Definition of the Demo table<\/figcaption><\/figure>\n<\/div>\n\n\n

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.<\/p>\n\n\n

\n
\"\"<\/a>
Enable object for REST<\/figcaption><\/figure>\n<\/div>\n\n\n

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.<\/p>\n\n\n

\n
\"\"<\/a>
Enable Demo table for REST<\/figcaption><\/figure>\n<\/div>\n\n\n

Also something very interesting is that we can see and filter the objects of all types of the database easily, from a single tree. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

On the other hand, something that I have used many times and that is now unavailable<\/s> 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! <\/p>\n\n\n\n

https:\/\/www.linkedin.com\/in\/monicagodoymillan\/<\/a> 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!<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

It should be noted that in the free instance of apex.oracle.com this functionality is not available for obvious reasons :).<\/p>\n\n\n\n

Te dejo el enlace a una demostraci\u00f3n sobre el Explorador de Objetos: <\/p>\n\n\n\n

\n