'Full text search in all columns in Oracle

I was using the following query in PostgreSQL and I investigate if there is any similar for Oracle 19c:

SELECT * FROM table_name 
WHERE table_name::TEXT LIKE '%some_text%';

The best alternative that I can find for Oracle is the following but I am wondering if there is any better approach.

SELECT * FROM table_name
WHERE
   COALESCE(to_char(column1), '') || 
   COALESCE(to_char(column2), '') || 
   COALESCE(to_char(columnN), '') 
LIKE '%some_text%';
sqloraclesql-like


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions