Oracle login. SQL statement

Oracle login. SQL statement -- Define the buffer editor as videfine_editor = vi -- make DBMS_OUTPUT valid and set it to the maximum buffer, and prevent "eat" from leading spaces set serveroutput on size 1000000 format wrapped -- set the number of characters that a row can accommodate set linesize 256 -- set the number of rows on a page set pagesize 50 -- set back and forth data Display volume, this value will affect the consistent reading of data such as set arraysize 5000 during autotrace -- there is no interval between the page and the page set newpage none -- LONG or CLOB display length set long 5000 -- each line in the SPOOL output remove unnecessary spaces behind the set trimspool on -- set the query time to set timing on -- autotrace and then explain plan output format col plan_plus_exp format a120 -- the output content is not displayed on the screen at the moment, set termout off for the following SQL settings -- set the time format alter session set nls_date_format = 'hh24: mi: ss'; -- get the username and global_namecolumn global_name new_value gname select upper (user) | '@' | upper (substr (global_name, 1, decode (dot, 0, length (global_name), dot-1) global_name from (select global_name, instr (global_name ,'. ') dot from global_name ); -- set the SQL prompt to "user @ global_name" set sqlprompt '& gname _ PRIVILEGE _ date SQL>' -- set sqlprompt "_ USER @ _ CONNECT_IDENTIFIER _ PRIVILEGE>" -- display on the screen output content set termout on -- column format control col c1 format a1col C0 format a1col c2 format a2col cc2 format a2col c3 format a3col cc3 format a3col c4 format a4col cc4 format a4col c5 format a5col cc5 format export c6 format a6col cc6 format a6col c7 format a7col cc7 format a7col c8 format a8col cc8 format a8col c9 format using cc9 format using c10 format a10col cc10 format a10col c15 format a15col cc15 format a15col c20 format a20col cc20 format protocol c30 format protocol cc30 format a30col c40 format a40col cc40 format a40col c50 format a50col cc50 format a50col c60col format a60col cc60 format a60col c70 format a70col cc70 format protocol c80 format protocol c90 format encoding cc90 format encoding c100 format a100col cc100 format a100col c150 format a150col cc150 format a150col c200 format a200col cc200 format a200col protocol format encoding cc255 format encoding host format a30col db_link format a30col host format a30col db_link a30col member format a60col name format a60col owner format a15col what format a90col DEST_NAME format invalid Invalid format invalid USERNAME format invalid USERHOST format invalid TERMINAL format a15col OBJ_NAME format invalid SQL _TEXT format a60col EVENT format a70col status format a60col MESSAGE format a100col path format a30col FILE_NAME format a60col DESTINATION format a50col OBJECT_NAME format a30