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 vote122 views1 answer
Count database access django
SQL
2 votes110 views1 answer
Mysql time ago difference
SQL
0 vote107 views1 answer
Mysql disable query caching
SQL
0 vote118 views1 answer
Yesql
SQL
0 vote125 views1 answer
Sql cmd no truncate
SQL
1 vote165 views1 answer
Primary key reset in SQL database
SQL
0 vote106 views1 answer
Wordpress database query change url
SQL
5 votes111 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote103 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
1 vote108 views1 answer
How to install mysql 8.0 windows service
SQL