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 vote198 views1 answer
Store query result in variable sql
SQL
12 votes224 views5 answers
Sql primary key
SQL
0 vote239 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
4 votes252 views1 answer
Postgresql list sequences
SQL
0 vote223 views1 answer
Sql query to check if column contains alphabets
SQL
15 votes263 views3 answers
Mysql update add to existing value
SQL
0 vote231 views1 answer
How to select even id in sql
SQL
10 votes235 views4 answers
Join with multiple conditions sql
SQL
11 votes265 views6 answers
Mysql else if
SQL
6 votes227 views1 answer
Allsource oracle
SQL