表字段varchar2类型插入一段字符语句

来源：互联网发布：java 生成二维码demo 编辑：程序博客网时间：2024/05/24 03:25

1.需要插入的内容

QUERY_SQL=select {COLUMN_NAME} from {from_schema_table} where region = ${REGION} and STOP_TIME>trunc(add_months(sysdate,-3),''MM'')#;
DELETE_SQL=delete from {TO_SCHEMA_TABLE} where region = ${REGION}#;#
INSERT_SQL=insert into {TO_SCHEMA_TABLE} ({COLUMN_NAME},oprtime) values (?,?,?,?,?,?,?,?,?,?,sysdate)#;#

2.采用方法

insert into tv values(
q'[QUERY_SQL=select {COLUMN_NAME} from {from_schema_table} where region = ${REGION} and STOP_TIME>trunc(add_months(sysdate,-3),''MM'')#;];||chr(10)||
q'[DELETE_SQL=delete from {TO_SCHEMA_TABLE} where region = ${REGION}#;#]'||chr(10)||
q'[INSERT_SQL=insert into {TO_SCHEMA_TABLE} ({COLUMN_NAME},oprtime) values (?,?,?,?,?,?,?,?,?,?,sysdate)#;#]')

commit;

SQL> desc tv
Name Null? Type
----------------------------------------- -------- ----------------------------
V VARCHAR2(4000)

Here are some valid text literals using the alternative quoting mechanism:
q'!name LIKE '%DBMS_%%'!'
q'<'So,' she said, 'It's finished.'>'
q'{SELECT * FROM employees WHERE last_name = 'Smith';}'
nq'ï Ÿ1234 ï'
q'"name like '['"'