Use quote in insert statement : Quotation Mark « Insert Update Delete « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Insert Update Delete
  3. Quotation Mark
SQL>
SQL> create table t ( x varchar2(255) );

Table created.

SQL>
SQL> insert into t values ( 'A''s table' );

1 row created.

SQL>
SQL> drop table t;

Table dropped.

SQL>
SQL>








4.5.Quotation Mark
4.5.1.Use a 'q' as the leading character after the parentheses
4.5.2.Two quotes really means one quote
4.5.3.Use quote in insert statement