Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SQL> show all
SQL> store set my_settings_file.new create
SQL> desc dual
Name Null? Type
------------------------------- -------- ----
DUMMY VARCHAR2(1)
SQL> start my_script.tst
SQL> @my_script.tst
SQL> select sysdate from dual
2
SQL> /
SYSDATE
---------
21-APR-03
SQL> spool my_output.txt
SQL> spool off
SQL> column today head 'Todays Date'
SQL> select sysdate today from dual;
Todays Da
---------
21-APR-03
SQL> column today format a11
SQL> /
Todays Date
-----------
21-APR-03
column today format a11 head 'Todays Date'
column table_name format a15
SQL> select table_name from all_tables where owner = 'SYS' order by 1;
TABLE_NAME
---------------
ACCESS$
AQ$_MESSAGE_TYP
ES
à
SQL> column num format 99,990.00
SQL> select 12345.98 num from dual;
NUM
----------
12,345.98
ed
ed my_script.tst
SQL> get my_script.new
1* select sysdate from dual;
SQL> get my_script.new nolist
SQL>
SQL> l
1* select sysdate from dual;
SQL> prompt Welcome Back!
Welcome Back!
SQL> save my_sql.new create
SQL> set def on ^
SQL> set def off
select sysdate from dual;
SQL> set echo on
SQL> @xxx
SQL> select sysdate from dual;
SYSDATE
---------
21-APR-03
SQL> set echo off
SQL> @xxx
SYSDATE
---------
21-APR-03
SQL> set feedback on
SQL> select sysdate from dual;
SYSDATE
---------
21-APR-03
1 row selected.
SQL> set feedback off
SQL> select sysdate from dual;
SYSDATE
---------
21-APR-03
SQL> set head on
SQL> select sysdate from dual;
SYSDATE
---------
21-APR-03
SQL> set head off
SQL> select sysdate from dual;
21-APR-03
SQL> set linesize 100
SQL> set long 200
SQL> set newpage 0
SQL> set pagesize 55
SQL> set scan on
SQL> set scan off
SQL> set serveroutput on
SQL> set serveroutput off
SQL> set serveroutput on size 100000
SQL> set show on
new: showmode BOTH
SQL> set linesize 100
old: linesize 100
new: linesize 100
SQL> set show off
old: showmode BOTH
SQL> set linesize 80
SQL>
select sysdate from dual;
SQL> set term on
SQL> @xxx
SYSDATE
---------
22-APR-03
SQL> set term off
SQL> @xxx
SQL>
SQL> set time on
13:31:33 SQL>
SQL> set timing off
SQL> @xxx
SYSDATE
---------
22-APR-03
SQL> set timing on
SQL> /
SYSDATE
---------
22-APR-03
real: 10
set trim on
set trim off
set trims on
set trims off
select '&1' hi from dual;
SQL> set truncate off
SQL> set linesize 25
SQL> @xxx 123456789012345678901234567890
HI
-------------------------
1234567890123456789012345
67890
SQL> set truncate on
SQL> /
HI
-------------------------
1234567890123456789012345
select '&1' hi from dual;
SQL> @xxx Hello!
old 1: select '&1' greeting from dual
new 1: select 'Hello!' greeting from dual
HI
------
Hello!
SQL> set verify off
SQL> @xxx Greetings!
HI
----------
Greetings!
select '&1' msg from dual;
SQL> set verify off
SQL> set feed off
SQL> set echo off
SQL> column msg format a25 head FAQ_Purpose
SQL> @xxx 'Hope this helps!'
FAQ_Purpose
-------------------------
Hope this helps!