Well hello i just wanted to ask you a question. Before 1.5 years i installed 23ai version and i downloaded sql developer. Before 1 month i opened my sql developer and i saw that my hr user is locked so i had to connect to sys user and then i pressed the following code -> ALTER SE...

Hello, We have a Java process that calls OR stored procedure via JPA. This procedure was initially declared outside of a package, and everything worked fine, but when we moved it into a package, we encountered date conversion problems related to the incorrectly initialized Oracle...

We don't seem to be able memoptimize a table for read when there are triggers on it (this seems to be undocumented however ?). But: we can add the triggers later on without problem and the table continues to be memoptimized for read. Question: WHY ? Is it a bug ? It is a bit anno...

Hi all, I have a hierarchy between levels in my_hierarchy table (between id_lvl and id_lvl_sup). Each level (lvl) may have items (id_item), and each item has a category (id_item_sup). These data is stored in my_items table. Now I want to build a report based on the my_view view. ...

My goal is to create a fast refreshable materialized view (MV) that holds all the combinations of records in specific related tables. So also the 'incomplete combinations'. So the query that is needed contains a full outer join. First a disclaimer about using LiveSQL. I tried but...