oracle18c
How to fill a table by a range specified in another table
There is a table:
CREATE TABLE table (
start_range varcahar2(10),
end_range varcahar2(10),
val_range NUMBER(10)
);
At ... erent table table2 with rows in the range between start_range and end_range?
To make it look like this: (a1, a2, a3, a4, a5).
What is the alternative to REGEXP REPLACE for creating a functional index?
After migrating to Oracle 18c Enterprise Edition, creating a functional index (FBI) fails.
This is what DDLs look like for c ... c?
If such a feature is no longer supported for the FBI, what other way is there to provide such functionality for the index?
Using collections of packages declared in the PL/SQL specification in an SQL context
You must insert the values in the table from the collection declared in the package.
Creating the following:
create table t_ ... releases, the collection's data type had to be declared at the schema level.)
What am I doing wrong, and what has changed?