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

1 vote297 views1 answer
How to show index type in postgresql
SQL
1 vote295 views1 answer
Mysql check string don't have number
SQL
0 vote307 views1 answer
How to run mysql on terminal mac
SQL
2 votes264 views1 answer
Mysql auto increment jumping
SQL
2 votes331 views1 answer
Python sql
SQL
0 vote275 views1 answer
Get who is hired in january in sql
SQL
14 votes335 views6 answers
Finding duplicate rows mysql
SQL
0 vote318 views1 answer
Show all sequences postgres
SQL
0 vote275 views1 answer
Update table sql multiple set
SQL
0 vote293 views1 answer
Como saber si tengo mysql instalado
SQL