OraFAQ Forum: SQL & PL/SQL » how can I do it without error,keep the rowid

Home » SQL & PL/SQL » SQL & PL/SQL » how can I do it without error,keep the rowid

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can I do it without error,keep the rowid [message #597875]

Wed, 09 October 2013 01:33

zhaoquer
Messages: 35
Registered: October 2013

Member

CREATE TABLE CD_TRANS_GLIDE
( "TRANS_GLIDE_ID" CHAR(32) NOT NULL ENABLE,
"CARD_SEQ_NO" CHAR(10),
"SUBACCOUNT_NO" VARCHAR2(10),
"CASH_FLAG" CHAR(1),
"RPT_FLAG" CHAR(1),
"RPT_DATE" DATE,
"TXN_TP" VARCHAR2(10),
"TXN_DT" DATE,
"TXN_AMT" NUMBER(10,2),
"FEE_TP" VARCHAR2(10),
"APP_FLAG" VARCHAR2(4),
"ACCOUNT_TYPE" VARCHAR2(10),
"ACCEPT_TP" VARCHAR2(10),
"BRANCH_NO" VARCHAR2(24),
"TXN_ADJ_FLG" CHAR(2),
"WARRANTID" VARCHAR2(10),
"OPR_NO" VARCHAR2(24),
"TERM_NO" VARCHAR2(20),
"TERM_SEQ" CHAR(10),
"SAM_NO" VARCHAR2(24),
"SAM_SEQ" CHAR(10),
"BUSINESS_NO" CHAR(10),
"RECV_DATE" DATE,
"RECV_OPR_NO" VARCHAR2(24),
"RECV_BUSI_NO" CHAR(10),
"CT_SEQ" VARCHAR2(24),
"REVC_CT_SEQ" VARCHAR2(24),
"ACCOUNT_SIGN" VARCHAR2( Cool

,
"CARD_UNIQUE_NO" VARCHAR2(32),
"DIV_FACTORY" VARCHAR2(32),
"TXN_TAC" VARCHAR2( Cool

,
"PAYMENT_TYPE" CHAR(1) DEFAULT '0',
"PAYMENT_TYPE_EXT" CHAR(1) DEFAULT '0',
"TACID" CHAR(32),
"REAL_TXN_AMT" NUMBER(10,2),
"CARD_SEQ_NO_1" VARCHAR2(10),
"TXN_DT_1" DATE,
"TXN_AMT_1" NUMBER,
"APP_TYPE" VARCHAR2(10),
"DEAL_TYPE" CHAR(2),
"LAST_OPR_NO" VARCHAR2(24),
"LAST_OPR_DATE" DATE)

insert into cd_trans_glide
(TRANS_GLIDE_ID,
CARD_SEQ_NO,
APP_TYPE,
SUBACCOUNT_NO,
CASH_FLAG,
RPT_FLAG,
RPT_DATE,
TXN_TP,
TXN_DT,
TXN_AMT,
FEE_TP,
APP_FLAG,
ACCOUNT_TYPE,
ACCEPT_TP,
BRANCH_NO,
TXN_ADJ_FLG,
WARRANTID,
OPR_NO,
TERM_NO,
TERM_SEQ,
SAM_NO,
SAM_SEQ,
BUSINESS_NO,
RECV_DATE,
RECV_OPR_NO,
RECV_BUSI_NO,
CT_SEQ,
REVC_CT_SEQ,
ACCOUNT_SIGN,
CARD_UNIQUE_NO,
DIV_FACTORY,
TXN_TAC,
PAYMENT_TYPE,
PAYMENT_TYPE_EXT,
TACID,
REAL_TXN_AMT,
DEAL_TYPE,
LAST_OPR_NO,
LAST_OPR_DATE,
ROWID)
values
('5ac1e9c81742b45ef19e89aa0d85ad8d',
'0002379017',
'',
'0136569833',
'1',
'0',
null,
'3211',
to_date('26-08-2013 11:41:21', 'dd-mm-yyyy hh24:mi:ss'),
50.00,
'0',
'80',
'2000000101',
'06',
'00705000053',
'00',
'',
'66666666',
'214001008494',
'0000002692',
'214001008494',
'',
'1044957304',
null,
'',
'',
'320200201308260032783625',
'',
'',
'',
'',
'',
'',
'',
'',
50.00,
'10',
'66666666',
to_date('26-08-2013 11:50:04', 'dd-mm-yyyy hh24:mi:ss'),
'AAATgwAATAAD1ttAAe');

Report message to a moderator

Re: how can I do it without error,keep the rowid [message #597876 is a reply to message #597875]

Wed, 09 October 2013 01:37

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle assigns rowid automatically, you don't do that manually. Besides, it is subject to change so ... why do you want to "keep it"? User your own ID (primary key, I'd rather say) to uniquely identify information stored in a table.

Report message to a moderator