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 vote187 views1 answer
Selecting specific day in colum sql
SQL
1 vote139 views1 answer
Psql filed name alter
SQL
2 votes139 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote131 views1 answer
Mysqlcli how to load external sql file
SQL
3 votes104 views2 answers
Coalesce mysql
SQL
1 vote164 views1 answer
Mysql current running queries
SQL
-1 vote125 views1 answer
Plsql while
SQL
0 vote129 views1 answer
View acl table oracle
SQL
0 vote158 views1 answer
How to to get time in sql
SQL
-1 vote186 views4 answers
Full outer join in sql
SQL