Mega Code Archive

 

Categories / Oracle PLSQL / Insert Delete Update

 

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>