Oracle database 19C, In SQL query how to compare ‘[“a”, “b”]’ = ‘[“b”, “a”]’ is TRUE

Oracle database;

Oracle database 19C, In SQL query how to compare ‘[“a”, “b”]’ = ‘[“b”, “a”]’ is TRUE

Oracle database;

Oracle database 19C, In SQL query how to compare ‘[“a”, “b”]’ = ‘[“b”, “a”]’ is TRUE

Oracle database;

Oracle sqlplus rollback action while setup [closed]

Closed 35 mins ago.

Oracle sqlplus rollback action while setup [closed]

Closed 35 mins ago.

Error when trying to run a statement using a cursor

Under Oracle 19c I made a simple select with cursors :

Oracle 19 INSERT 50M rows take 400 seconds [closed]

Closed 3 days ago.

Oracle 19 INSERT 50M rows take 400 seconds [closed]

Closed 3 days ago.

Can’t login in SQL PLUS [closed]

Closed 4 days ago.

Oracle truncate and insert (back up table data took too much time

We have large table (many columns ) Table1 but only small number of column need backup and do further processing
Here is the plan. We create another Table2 and only include few columns (essential data)