(Andrejus Baranovskis) Combo box LOV with filtering is simple, but effective feature not used often. You should rethink LOV design and apply combo box LOV with filtering where possible. Advantage of such LOV implementation is pretty clear – fast list items access, based on filter criteria.
Tag: Oracle
Smart Combo Box LOV with Filter
(Andrejus Baranovskis) Combo box LOV with filtering is simple, but effective feature not used often. You should rethink LOV design and apply combo box LOV with filtering where possible. Advantage of such LOV implementation is pretty clear – fast list items access, based on filter criteria.
Parallel Projection
(Randolf Geist) A recent case at a client reminded me of something that isn’t really new but not so well known – Oracle by default performs evaluation at the latest possible point in the execution plan.
Mr DISTINCT might not be your friend
(connormcdonald) Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure that you are not hiding just a larger issue. It actually might represent either incorrect use of SQL or incorrect assumptions from the data model.
Move Table Partition between Tables
(Anand) I was recently asked if we can move partition of one table into another? Basically a developers had truncated the partition and the team wanted to move the partition from one table to another.Both the table were structurally the same and had same data.
Parallel Projection
(Randolf Geist) A recent case at a client reminded me of something that isn’t really new but not so well known – Oracle by default performs evaluation at the latest possible point in the execution plan.
Mr DISTINCT might not be your friend
(connormcdonald) Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure that you are not hiding just a larger issue. It actually might represent either incorrect use of SQL or incorrect assumptions from the data model.
Move Table Partition between Tables
(Anand) I was recently asked if we can move partition of one table into another? Basically a developers had truncated the partition and the team wanted to move the partition from one table to another.Both the table were structurally the same and had same data.
Managing ORE in-database Data Stores using SQL
(Brendan Tierney) When working with ORE you will end up creating a number of different data stores in the database. Also as your data science team increases the number of data stores can grow to a very large number.
ORA-01034: ORACLE not available
(Natik Ameen) Question: What is the cause of the error “ORA-01034: ORACLE not available” when I log into sqlplus?