Oracle PL/SQL Tutorial/SQL PLUS Session Environment/SCAN

SET SCAN OFF/ON

SQL>
SQL> CREATE TABLE myTable (
  2       name  VARCHAR2(25) NOT NULL,
  3       price NUMBER(4,2)  NOT NULL,
  4       start_date DATE);
Table created.
SQL>
SQL> SET SCAN OFF
SQL> INSERT INTO myTable VALUES ("Fifth Product""s Name", 25, "05-MAY-06");
1 row created.
SQL> SET SCAN ON
SQL>
SQL>
SQL> SELECT * FROM myTable;

NAME                           PRICE START_DAT
------------------------- ---------- ---------
Fifth Product"s Name              25 05-MAY-06
SQL> drop table myTable;
Table dropped.
SQL>
SQL>
SQL>