출처: http://munduki.tomeii.com/darkhorse/entry/ORACLE-%ED%8A%B9%EC%88%98%EB%AC%B8%EC%9E%90-%EC%9E%85%EB%A0%A5
set escape on
UPDATE TBL_US_MEMBER_BPINFO SET BP_EMAIL_AUTH_URL = 'http://idp.nate.com/web/JC.mail?q=64adff31fc80c86f8991a90bf0cad011c5e364370f1b45a4b2bca822d7683c3135628ec969ef57352f3e9b0e429db66b1c7ff0d7adeef4d42f6bcedbc96b63d3085d0fcef961826ed2a963f304d4efbb3af99ad07da28057c835683cdf48ad219de23d21376576530539089db264d3602fdc44908d3e98e45c9c03ec7e67e1d82c0c91a0ed61366508ffd5fb4acba40dce8400621d77af8ca051a7d5a28144e33bf10b78dcf3a79384f7365a47d49fdc3f25466e6e5d360544d4e472c3da8ac9\&\&resp_url=http%3A%2F%2Fbp.tstore.co.kr%2Fbppoc%2Fmember%2FidpEmailAuth.omp'
set escape off
set escape on
UPDATE TBL_US_MEMBER_BPINFO SET BP_EMAIL_AUTH_URL = 'http://idp.nate.com/web/JC.mail?q=64adff31fc80c86f8991a90bf0cad011c5e364370f1b45a4b2bca822d7683c3135628ec969ef57352f3e9b0e429db66b1c7ff0d7adeef4d42f6bcedbc96b63d3085d0fcef961826ed2a963f304d4efbb3af99ad07da28057c835683cdf48ad219de23d21376576530539089db264d3602fdc44908d3e98e45c9c03ec7e67e1d82c0c91a0ed61366508ffd5fb4acba40dce8400621d77af8ca051a7d5a28144e33bf10b78dcf3a79384f7365a47d49fdc3f25466e6e5d360544d4e472c3da8ac9\&\&resp_url=http%3A%2F%2Fbp.tstore.co.kr%2Fbppoc%2Fmember%2FidpEmailAuth.omp'
set escape off
'프로그래밍 > DB' 카테고리의 다른 글
| [oracle] 제약조건 확인하기 (0) | 2010.02.25 |
|---|---|
| [Toad] tab 간격 조정하기 (0) | 2010.02.02 |
| [Oracle] Toad 단축키 (0) | 2009.08.22 |
| [oracle10g] 페이징 시 rownum 사용하기 (0) | 2009.04.06 |
| [Oracle] [펌] sqlplus 사용법 (0) | 2009.03.24 |
