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 vote213 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
4 votes210 views1 answer
Oracle nls_date_format
SQL
0 vote187 views1 answer
Mysql change default collation
SQL
3 votes194 views1 answer
Get current month last date in sql server
SQL
13 votes185 views2 answers
Display users in mysql
SQL
0 vote202 views1 answer
Psql datestyle
SQL
-1 vote188 views1 answer
How to check table exists or not in postgresql
SQL
0 vote192 views2 answers
How to update the multiple rows in sql
SQL
16 votes204 views3 answers
Update table from another table
SQL
14 votes231 views2 answers
Sql cast
SQL