17,082
社区成员
发帖
与我相关
我的任务
分享
select * from table1 where t1 = default;
--oracle语法报错
insert into table1 values(999999999)RETURN t1 INTO vNum;
select * from table1 where t1 = vNum;
delete from table1 where id = 999999999;
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
);