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

21 votes181 views5 answers
Oracle all tables
SQL
1 vote180 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote192 views1 answer
Sql script to remove default from column
SQL
0 vote144 views1 answer
Flask_sqlalchemy install
SQL
1 vote183 views1 answer
Cross schema query oracle 2 users
SQL
0 vote243 views1 answer
Create table as select sql server error
SQL
0 vote201 views1 answer
Power bi find all ids not in other tables
SQL
15 votes185 views2 answers
Select Options
SQL
1 vote190 views1 answer
Sql week commencing date
SQL
2 votes147 views4 answers
Mysql change database character set to utf8mb4
SQL