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

SET SCAN OFF/ON

   <source lang="sql">

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></source>