SQL> CREATE TABLE TT (A VARCHAR2(10));表已创建。SQL> SET DEFINE OFF SQL> INSERT INTO TT VALUES('ASDF&BA');已创建 1 行。SQL> COMMIT;提交完成。SQL> SELECT * FROM TT;A ---------- ASDF&BA
直接用&的Ascii码(chr(&的Ascii码))
也可以这样SQL> SET DEFINE ON SQL> INSERT INTO TT VALUES('ASDF' || '&'|| 'BA');已创建 1 行。SQL> COMMIT;提交完成。SQL> SELECT * FROM TT;A ---------- ASDF&BASQL> SELECT * FROM TT WHERE A LIKE '%' || '&' || '%';A ---------- ASDF&BA
SQL> INSERT INTO TT VALUES('ASDF&BA');已创建 1 行。SQL> COMMIT;提交完成。SQL> SELECT * FROM TT;A
----------
ASDF&BA
SQL> INSERT INTO TT VALUES('ASDF' || '&'|| 'BA');已创建 1 行。SQL> COMMIT;提交完成。SQL> SELECT * FROM TT;A
----------
ASDF&BASQL> SELECT * FROM TT WHERE A LIKE '%' || '&' || '%';A
----------
ASDF&BA