Oracle转义字符的使用场景有哪些

?Oracle????,????(Escape Character)??????????????????????????????????????:

1. ???????????: ???????????????(?????????)????,???????????,????????"50%"???,????LIKE????????:

   SELECT * FROM table_name WHERE column_name LIKE 'P\%%' ESCAPE '\';
   

2. ???????: ???????????????,????????????????????,????????"a.b"???,????REGEXP_LIKE???????:

   SELECT * FROM table_name WHERE REGEXP_LIKE(column_name, 'a\.b', 'c');
   

3. ??????????????: ??????????????????,???????????,????????????????,????????:

   INSERT INTO table_name (column_name) VALUES ('It''s a nice day!');
   

4. ???????????: ??????????????????,????????????????????,???????????????,????????:

   CREATE OR REPLACE PROCEDURE my_procedure IS
   BEGIN
     DBMS_OUTPUT.PUT_LINE('Hello, "World"!');
   END;
   

??,?Oracle????,?????????????????????????????????????,??????????????????????