In an Oracle tenant, `||` is used as a string connector.
SQL statement for querying the name of a customer in an Oracle tenant:
SELECT c_first || ' ' || c_last full_name FROM cust ORDER BY c_last;
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
OceanBase Database
Download PDF
In an Oracle tenant, `||` is used as a string connector.
SQL statement for querying the name of a customer in an Oracle tenant:
SELECT c_first || ' ' || c_last full_name FROM cust ORDER BY c_last;