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

3 votes354 views1 answer
Set default today mysql
SQL
0 vote303 views1 answer
Mysql find foreign key references
SQL
1 vote355 views1 answer
Mysql size int
SQL
0 vote304 views8 answers
Convert sql query to linq online
SQL
1 vote360 views1 answer
Expression number 1 of select list is not in group by clause
SQL
1 vote336 views1 answer
Mysql history command
SQL
0 vote404 views1 answer
Mssql find deadlocks
SQL
15 votes355 views1 answer
Mysql int range
SQL
2 votes352 views2 answers
Created at and updated at in mysql
SQL
0 vote345 views3 answers
Joins and views sql
SQL