create table table1(
id NUMBER(10),
t1 VARCHAR2(10) default '111');执行成功的
update table1 set t1 = default;现在我想这样执行,请问如何处理?
select * from table1 where t1 = default;
id NUMBER(10),
t1 VARCHAR2(10) default '111');执行成功的
update table1 set t1 = default;现在我想这样执行,请问如何处理?
select * from table1 where t1 = default;
CREATE OR REPLACE FUNCTION LongToString( COL_NAME VARCHAR2,TAB_NAME VARCHAR2) RETURN VARCHAR2
AS
Result_Value LONG;
BEGIN
SELECT DATA_DEFAULT INTO Result_Value FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME=COL_NAME AND TABLE_NAME=TAB_NAME;
RETURN REPLACE(TRANSLATE(TRIM(Result_Value),CHR(13)||CHR(10),','),'''','');
END;第二步:直接用就可以了:
SELECT * FROM TABLE1
WHERE T1 IN
(
SELECT LONGTOSTRING('T1','TABLE1') T FROM DUAL
);
t1 字段为 默认值的记录,于是我这样处理 ,把默认值保存到一个临时变量中
insert into table1 values(999999999)RETURN t1 INTO vNum;
select * from table1 where t1 = vNum;
delete from table1 where id = 999999999;