sqlcl format

Solutions on MaxInterview for sqlcl format by the best coders in the world

showing results for - "sqlcl format"
Greta
29 Aug 2017
1SQL> SET SQLFORMAT ANSICONSOLE
2SQL> SELECT * FROM emp WHERE deptno = 20;
3  EMPNO ENAME   JOB          MGR HIREDATE       SAL   COMM   DEPTNO
4   7369 SMITH   CLERK       7902 17-DEC-80      800              20
5   7566 JONES   MANAGER     7839 02-APR-81     2975              20
6   7788 SCOTT   ANALYST     7566 19-APR-87     3000              20
7   7876 ADAMS   CLERK       7788 23-MAY-87     1100              20
8   7902 FORD    ANALYST     7566 03-DEC-81     3000              20
9
10
11SQL>
queries leading to this page
sqlcl report formatsqlcl format