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

2 votes274 views2 answers
Spring import sql
SQL
34 votes271 views5 answers
Oracle alter table add column
SQL
11 votes274 views5 answers
Sql server reset identity
SQL
3 votes342 views4 answers
Sql interview questions
SQL
1 vote288 views1 answer
Liquibase alter column type / length
SQL
0 vote317 views1 answer
Redshift running queries
SQL
3 votes265 views4 answers
Psql list tables in schema
SQL
25 votes285 views1 answer
How to update an attribute in MySQL
SQL
1 vote267 views1 answer
Epoch time converter in snowflake
SQL
2 votes276 views1 answer
Postgresql create table as select
SQL