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 vote216 views1 answer
Top 3 salary in sql
SQL
0 vote215 views3 answers
Mysql keyword search
SQL
3 votes206 views1 answer
Sql select all
SQL
0 vote205 views1 answer
Mysql select all table that have field names
SQL
3 votes213 views3 answers
Stop mysql ubuntu
SQL
0 vote229 views1 answer
Openquery join two tables
SQL
-1 vote208 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote182 views1 answer
Provera dupliranih konatakata
SQL
1 vote214 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote205 views1 answer
Like and not like together in sql
SQL