Hi, I have a column in table that have yet text in fields. Some of fields have in the end of text: distance: R1: a R2: b R3: c mm mm mm I want to insert before the first mm d/a, the second mm d/b and the third mm d/c. It will be : distance R1: a R2: b R3: c d/a mm d/b mm d/c mm P...

Hi Tom, This is a DDL question/observation, which puzzles me a bit: Given the following succesfull creation of a table in a schema PL, on Oracle 19c: create table pl.constraint_test ( id integer, end_date date, constraint end_date_not_null check (end_date is not null) );

I need to union two database querieres for an export job. Any idea how this is formatted on a par file?

here is the test. create table t1(id int, name char(10)); create table t2(id int, name char(12)); insert into t1 values(100, 'yang'); insert into t2 values(200, 'yang'); commit; -- return 1 row select * from t1, t2 where t1.name = t2.name and t1.name = 'yang'; -- return 1 row se

So I am able work out partition by reference with the DDL below, but can seem to figure out how to also get IOT too. The examples with IOT I have seen needed the PK defined in the create table DDL. Since my solution for making the PK on the child table with partition local requir...