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 vote204 views1 answer
Alter constraint postgres
SQL
4 votes218 views4 answers
Pl sql output
SQL
4 votes198 views1 answer
Mysql insert from local csv
SQL
0 vote195 views1 answer
Pl sql search in all packages
SQL
0 vote214 views1 answer
Mysql sum per week
SQL
0 vote211 views2 answers
Psql commande \gset
SQL
0 vote207 views1 answer
Oracle synonym procedure dblink
SQL
1 vote217 views2 answers
Begin transaction in sql
SQL
1 vote214 views2 answers
Mysql between
SQL
1 vote203 views1 answer
How to run parallel queries in sql server with entity framework
SQL