INSERTING DATA CONTAINING APOSTROPHES : INSERT Column Name « Insert Delete Update « Oracle PL / SQL

1. Oracle PL / SQL
2. Insert Delete Update
3. INSERT Column Name

INSERTING DATA CONTAINING APOSTROPHES

 
SQL>
SQL> CREATE TABLE purchase (
  2       product_name  VARCHAR2(25) NOT NULL,
  3       product_price NUMBER(4,2)  NOT NULL,
  4       purchase_date DATE
  5       );

Table created.

SQL>
SQL>
SQL> SET SCAN OFF
SQL>
SQL> INSERT INTO purchase VALUES ('Fifth Product''s Name', 25, '05-MAY-03');

1 row created.

SQL>
SQL> SET SCAN ON
SQL>
SQL>
SQL> SELECT * FROM purchase;

PRODUCT_NAME              PRODUCT_PRICE PURCHASE_
------------------------- ------------- ---------
Fifth Product's Name                 25 05-MAY-03

1 row selected.

SQL>
SQL> DROP TABLE purchase;

Table dropped.

SQL>

 

Related examples in the same category