Re: Escape sequence
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Wed, 27 Aug 2003 17:44:29 -0400
Message-ID: <3292998.1062020669_at_dbforums.com>
Date: Wed, 27 Aug 2003 17:44:29 -0400
Message-ID: <3292998.1062020669_at_dbforums.com>
Don't know what you are doing because it works for me:
SQL>select * from emp where last_name = 'ADAM''S';
POSITION_CODE MGR_POSITION_CODE EMP_NBR
------------------------ ------------------------ -------
FIRST_NAME LAST_NAME
------------------------- -------------------------
EMAIL POSITION_TYPE SALES_TE
------------------------------ --------------- --------
DMS_PASSWD P PW_LAST_L PW_RETRIES TRAINING MP_SUFFIX
-------------------------------- - --------- ---------- ------------ ----------
AE0101020501 AE01010205 ADAM'S AE-TER 49060105 06-JUN-03 0 000000000000 AE-TER
1 row selected.
SQL> ???
--
Posted via http://dbforums.com
Received on Wed Aug 27 2003 - 23:44:29 CEST