Sqlcl format

SQL> SET SQLFORMAT ANSICONSOLE
SQL> SELECT * FROM emp WHERE deptno = 20;
  EMPNO ENAME   JOB          MGR HIREDATE       SAL   COMM   DEPTNO
   7369 SMITH   CLERK       7902 17-DEC-80      800              20
   7566 JONES   MANAGER     7839 02-APR-81     2975              20
   7788 SCOTT   ANALYST     7566 19-APR-87     3000              20
   7876 ADAMS   CLERK       7788 23-MAY-87     1100              20
   7902 FORD    ANALYST     7566 03-DEC-81     3000              20


SQL>

Source: oracle-base.com

Similar codes

0 vote207 views1 answer
Mysql zerofill
SQL
0 vote193 views2 answers
Postgresql get last day of month
SQL
0 vote191 views1 answer
Sql replace id with name from another table
SQL
3 votes188 views1 answer
Créer une table sql
SQL
0 vote205 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote193 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote200 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote201 views1 answer
Closure in sql
SQL
0 vote208 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote191 views1 answer
Mysql with
SQL