The INSERT format produces the INSERT statements that could be used to recreate the rows in a table. The underlines don't copy to flat text, so I've manually added the underlines to show you what it looks like in a terminal screen. Rather than using a separate line of output. The ANSICONSOLE format resizes the columns to the width of the data to save space. The JSON-FORMATTED format pretty-prints the JSON, so it is human readable. The output is minified, so it is compact, but hard to read. The JSON format produces a JSON document containing the definitions of the columns along with the data they contain. The XML format produces a tag-based XML document. The output from this query is quite large, so you can see the resulting HTML in the sqlcl-emp.htm file. The contents of the table dynamically alter to match the search string entered in the top-left text field. The HTML format produces the HTML for a responsive table. The first line contains the column names. The CSV format produces standard Comma-Separated Variable output, with string values enclosed by double-quotes. SQL> SELECT * FROM emp WHERE deptno = 20 ĮMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNOħ566 JONES MANAGER 7839 02-APR-81 2975 20ħ788 SCOTT ANALYST 7566 19-APR-87 3000 20 The DEFAULT option clears all previous SQLFORMAT settings and returns to the default output. The following comments give similar results, without having to alter the SQLFORMAT setting directly.
#Oracle sql developer query result window how to#
The sections below describe how to use SQLFORMAT setting in SQLcl, but there is an alternative solution to get the same results.
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7934,'MILLER','CLERK',7782,to_date('23-JAN-82','DD-MON-RR'),1300,null,10) įeedback is turned off for the following queries, so the number of rows produced is not displayed. The examples in this article require the following table. SQLcl makes it simple to format query results using the SET SQLFORMAT command and a variety of built-in formats. Home » Articles » Misc » Here SQLcl : Format Query Results with the SET SQLFORMAT Command
0 kommentar(er)
