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 vote224 views1 answer
Timestamp in sqlite
SQL
1 vote232 views1 answer
Mysql show long running queries
SQL
1 vote215 views1 answer
How to give access to database in postgresql server to another user
SQL
4 votes229 views1 answer
Mysql query first character
SQL
1 vote217 views1 answer
Mysql find tables with column name
SQL
0 vote242 views1 answer
Procedure excute monthly oracle
SQL
0 vote247 views1 answer
One table with another
SQL
1 vote310 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote226 views1 answer
Sql string contains case sensitive
SQL
13 votes221 views2 answers
Sql join
SQL