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 vote191 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote136 views1 answer
Power bi union columns
SQL
0 vote130 views1 answer
Why we have to set the password for my sql server
SQL
0 vote141 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote133 views1 answer
Mysql create index lost connection
SQL
3 votes133 views3 answers
Remove all spaces from string sql
SQL
5 votes221 views2 answers
Mysql date greater than 30 days
SQL
0 vote125 views1 answer
How to connect pgadmin with excel
SQL
0 vote141 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote134 views1 answer
Select a row include list of array with join table SQL
SQL