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 vote203 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote204 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote180 views1 answer
Python mysql query where
SQL
0 vote179 views1 answer
Oracle execute package dblink
SQL
12 votes180 views5 answers
Sql primary key
SQL
1 vote199 views1 answer
Oracle list data files
SQL
0 vote192 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote192 views1 answer
Time in sql server
SQL
1 vote215 views1 answer
Opensuse restart MySQL
SQL
0 vote201 views1 answer
Mysql join only one column
SQL