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 vote186 views1 answer
Get rows from 1 table with other table empty mysql
SQL
2 votes163 views1 answer
Sql server conection string
SQL
3 votes156 views2 answers
Oracle for loop
SQL
2 votes290 views5 answers
Unique in sql server
SQL
0 vote181 views2 answers
Import .sql into postgres db command
SQL
0 vote172 views1 answer
Uuid sqlalcomany
SQL
0 vote168 views1 answer
Sqlite closes value
SQL
0 vote124 views1 answer
Java spring boot connect to sql server
SQL
1 vote164 views1 answer
Real world example of nosql
SQL
2 votes166 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL