|
-
hi suvashish
the table is a global tempporary table and thescript s below.
CREATE GLOBAL TEMPORARY TABLE TEMP_TRANSD1
(
BT_OPTION VARCHAR2(6),
BT_BRANCH VARCHAR2(6),
BT_TRNO VARCHAR2(15),
BT_PROCESSDT DATE,
BT_UNITS NUMBER(20,3),
BT_AGENT VARCHAR2(16),
BT_PURRED VARCHAR2(8),
BT_ACNO VARCHAR2(16),
BT_SEQNO NUMBER(4)
)
ON COMMIT PRESERVE ROWS;
thnks
sknaidu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|