SQL

SQL Delimiter

SQL> select name||'|'||open_mode||'|'||database_role from v$database;

NAME||'|'||OPEN_MODE||'|'||DATABASE_ROLE

-----------------------------------------------

ORCLCDB|READ WRITE|PRIMARY

SQL> set heading off

SQL> /

ORCLCDB|READ WRITE|PRIMARY

SQL> set feedback off

SQL> /

ORCLCDB|READ WRITE|PRIMARY

SQL> set echo off

SQL> /

ORCLCDB|READ WRITE|PRIMARY

SQL>

SQL Date

SQL> select to_char(sysdate,('DD-MON-YYYY HH24:MI:SS'))||','||NAME FROM JTEST1;

07-AUG-2020 05:16:30,ORCLCDB

SQL>