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 vote106 views1 answer
Trigger value from maltiple table to single table mysql
SQL
2 votes98 views1 answer
SELECT INTO
SQL
0 vote105 views1 answer
Load data from text file to mysql database on mac terminal
SQL
25 votes101 views5 answers
Date in mysql
SQL
0 vote115 views1 answer
Codigo crear tablas sql server
SQL
0 vote135 views1 answer
Oracle sqlp update amount / quantity
SQL
1 vote113 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
4 votes96 views3 answers
Oracle sql first day of quarter
SQL
0 vote106 views1 answer
How get data from database if id not found then search another column
SQL
0 vote91 views1 answer
Lister les index d'une table oracle
SQL