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

12 votes159 views5 answers
Sql primary key
SQL
0 vote107 views1 answer
Check if due date is less than todays date sql
SQL
4 votes154 views2 answers
Mysql delete user if exists
SQL
0 vote158 views1 answer
Oracle sql number to varchar2
SQL
0 vote148 views1 answer
Check if string is a number sql
SQL
0 vote157 views1 answer
Sql server for loop
SQL
1 vote143 views3 answers
Union SQL
SQL
1 vote563 views1 answer
How to lock table in mysql
SQL
0 vote145 views1 answer
Alter table myisam to innodb
SQL
8 votes149 views1 answer
Oracle create datafile
SQL