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 vote277 views1 answer
Ubuntu access database from terminal
SQL
0 vote297 views1 answer
Command line mysql xampp
SQL
1 vote270 views1 answer
Oracle check table space
SQL
4 votes271 views3 answers
Drop Table Oracle
SQL
-1 vote208 views1 answer
Mysql how to set update or create
SQL
0 vote296 views1 answer
Sql column contains special character
SQL
1 vote270 views1 answer
Postgres get month name from date
SQL
0 vote304 views1 answer
Add super privilege mysql
SQL
1 vote273 views1 answer
Access the postgres psql
SQL
16 votes282 views6 answers
Install sqlite3 python
SQL