I sincerely despise how it hides the primary keys of a table when creating a interactive grid with a form subpage for entering new data, I have to unhide the primary key twice, on two different places. I know it does that for the master details as well, and I think it does the same for reports as well. Like, come on! It’s so infuriating how much time i have to waste just changing the primary key to be visible. Won’t even gonna mention how much it’s necessary to scroll to change a field to a dropdown list. The RESTful services are at least somewhat straightforward. Really like when it gives me “Under unscheduled maintenance” and then I gotta figure if it’s my SQL or they being down for real… Also for some reason, all of Oracle’s pages just take foooreever to load on my network. It’s not my router, it’s not my connection, since all other websites just load fine…
In both cases, I was using Oracle products for seminar projects. Specifically for Apex, I had to make a simple database with 15 tables, and visualise all of them in the Apex as a page. I am empathetic to anyone who has to use either in a production environment on a real project…
I don’t seem to be able to locate that option in the SQL Workshop… If true that’d saved me so much time, since that wasn’t shown to me during the course.
Thanks anyway, though! 👍
It’s been a while since I’ve used Apex so I hope you find the solution, I remember messing with the default settings a lot before it became useful at all
I sincerely despise how it hides the primary keys of a table when creating a interactive grid with a form subpage for entering new data, I have to unhide the primary key twice, on two different places. I know it does that for the master details as well, and I think it does the same for reports as well. Like, come on! It’s so infuriating how much time i have to waste just changing the primary key to be visible. Won’t even gonna mention how much it’s necessary to scroll to change a field to a dropdown list. The RESTful services are at least somewhat straightforward. Really like when it gives me “Under unscheduled maintenance” and then I gotta figure if it’s my SQL or they being down for real… Also for some reason, all of Oracle’s pages just take foooreever to load on my network. It’s not my router, it’s not my connection, since all other websites just load fine…
In both cases, I was using Oracle products for seminar projects. Specifically for Apex, I had to make a simple database with 15 tables, and visualise all of them in the Apex as a page. I am empathetic to anyone who has to use either in a production environment on a real project…
I thought you could just go to the UI settings within the SQL Workshop and unmark the PK as Hidden for that
I don’t seem to be able to locate that option in the SQL Workshop… If true that’d saved me so much time, since that wasn’t shown to me during the course. Thanks anyway, though! 👍
It’s been a while since I’ve used Apex so I hope you find the solution, I remember messing with the default settings a lot before it became useful at all