Subject | TIMESTAMP as UDF argument [2] |
---|---|
Author | IvanSS |
Post date | 2001-11-13T03:20:03Z |
also this works too:
************************
SELECT * FROM T1 WHERE
ID=DUMMY_UDF((SELECT D FROM DUMMY_DT_TBL));
if:
*********************************
create table DUMMY_TBL
( D TIMESTAMP);
commit;
INSERT INTO DUMMT_DT_TBL (D) VALUES ('1/1/2002');
COMMIT;
[Non-text portions of this message have been removed]
************************
SELECT * FROM T1 WHERE
ID=DUMMY_UDF((SELECT D FROM DUMMY_DT_TBL));
if:
*********************************
create table DUMMY_TBL
( D TIMESTAMP);
commit;
INSERT INTO DUMMT_DT_TBL (D) VALUES ('1/1/2002');
COMMIT;
[Non-text portions of this message have been removed]